MySQL Database Forum

I see nothing on the mysql.com site abnout certificaiton for version 5.0 yet there's a book for it (http://www.amazon.com/gp/product/0672328127/qid=1136142424/sr=1-2/ref=sr_1_2/103-0022201-6281410?s=books&v=glance&n=283155) please help me

Hi guys, I was wondering if someone could help me a bit here. Im trying to desing an electronic register system for a school. In terms of the table design, I obviously need a Student Details table with such attributes as ID, FNAME, SNAME, Age, Tutor Group, Class, Dependant. The bit i'm having trouble conceptualising is the system...

I am creating a server indexing files in my local area network, in order to provide a searching feature. So i want to make it possible to searchsuch rows where the 'name' (VARCHAR) column contains a substring submitted by user. an i use a full-text index to make it faster? from my first sight i noticed that this index can be used to search...

Hi I want to select a single row called "row1" but let mysql auto append a NON-exist column call "row2" of it. And i want that non-exist column be auto-increment. how to? If i "select row1 from mytable", then i get ----------- - row1 -

We have a recordset with the following structure id (int), mls (varchar) What we need to do is within a single sql call we need to show all records where the mls = '' and all unique records where mls!='' In other words, there will be multiple records with duplicate mls entries. We do not want to show duplicate enties for where the mls has...

Hi all, I have a curious problem with the ERROR 1044 and 1045: -system: OS X 10.4.3 (bash shell) -bash schell prompt: /~ kssun$ -I have set passwd to 'kssun' -I set path: PATH=${PATH}:/usr/local/mysql/bin - symptom 1

Hi, all, my server crashed at odbc my_strcasecmp_8bit(). OS: redhat linux 9.0, DB: MySQL-server-4.1.14-0.glibc23,MyODBC-3.51.11-2, unixODBC-2.2.3-6 I guessed it caused by odbc driver. but how to fix it? when the server crashed it output a coredump as follows: -----------------------------------------------------------

I have made a basic left join statement say "Select t.*, p.usenet_id from usenet_group_1 u left join user_table t on u.id = t.usenet_id; but only want the recordset to return values from user_table if field in user_table have a certain value ( if usenet_group = 5 ) - can this be done within the above sql statement or do i have to make 2...

Hi Guys, I have seen this is the only website to provide the list of mysqldata base web interface list for beginers and this is very useful i found. http://www.debianhelp.co.uk/mysqlweb.htm thanks

Hi, I have these 3 tables in my DB. 1. tbl.Member a. name b. email c. username(pri key) ...and other stuff 2. tbl.Product

Hi I have one Java app writing records to a database (App A) and another, a Java web application running under Tomcat, displaying the records. Call this App B. When I first log into App B and get a connection, all records in the database at that point get displayed OK. But after that, any new records inserted by App A do not get...

I want my software to be independant of operation system and databases. That's why I want to use odbc, and don't want to use MFC. Here I have some questions to ask: 1. On unix (like sun solaris), does there exists any kind of midware like odbc? 2. I search on the internet, and find most of the examples are based on PHP. Is there any c++...

Hello Recently changed from using Access to MySQL. Looked at the online docs but could not find anything about the process of distributing a database to customers. Can anyone give me a general idea of what is required. I sort of did a test by simply moving the database files to a different directory but was unable to connect after that...

Hi, I have the following straightforward query, which is taking up to 8 seconds. SELECT markers.*, relevance FROM grouped_matches LEFT JOIN markers ON (grouped_matches.markerid = markers.markerid); Table 'grouped_matches' has 338 records and table 'markers' has 5 million. 'markerid' is the primary key of markers.

Are some single character aliases not compatible with MySQL 5.0? After upgrading to mysql 5.0 it appears that some queries featuring aliases are are failing Is there some configuration option available to make them work?

I've got some kind of a strange thing going on. a view, lets call it 'xyxj' that shows up when I run > show tables Using MySQL Administrator it shows up as a view, I can drop it, but it reappears on refresh. Using the CL, as 'root' I've tried both drop table 'xyxj' and drop view 'xyxj' I get errors table/view does not...

Hi I need to load a csv file into mysql, which is easy enough. But I need it to be automated so when the file is uploaded to my webserver, it will automatically load the file to update table data. Any help would be brill. Cheers Shahram

Thanks Rich - that's great. Before I found this group, I thought I had a reasonable understanding of SQL (well, MySQL's implementation of it, at least) but the truth is there are great chunks that I have no knowledge of. I've read three or four books about MySQL and PHP all of which gave (in retrospect) very basic examples of the use of SQL,...

Hi, I'm looking for an efficient way to do the following: "given a column of entries with double values, select the greatest value less than D", where D is given as the upper bound. so if I have 0.1, 1.4, 10.11, 5.5 etc. then for D = 5, i should get 1.4. My current solution stores all entries in an array and sorts them... which I know...

What is the best way to achieve alphabetically ordered lists that will index phrases starting with 'The' as if the word was at the end rather than the start of the phrase? Michael

I'm programming with c++, I store the data I need in mysql. Now want to read data from mysql and put to parameters in my program. I use c api to program. In c api there seems to have many api to query the database. but can't find one to get data out of the database. can someone tell me how ? or just tell me which api I should use . thanks a...

I have a table with business names and contact lastnames and firstnames. Some records don't have a business name, and some don't have contact names. Does anyone know whether it is possible to have results sorted by business name, unless the field is empty, in which case, use the surname followed by the first name in place of the business...

Hi, I have a problem with mysql joins, which are always a bit complicated to me. I use mysql version 4.0.25-standard. This is my SQLstatement, used to check if user #1 has the right to login: SELECT users.*, rights.* FROM users

A virus was found in this message and it was automatically deleted by the Pacific Online mail server. The message was sent from ""PayPal® Inc."<service@paypal.com>", the original subject was "PayPal® Confirm Message!". Please note the from address may not represent the true sender of this message. In many cases the from address on such...

hi together i need to write an sql statement which follows a recursive dependency. but i just dont get it to work as i want...:-) on the links at the bottom is a graphical explanation of the table definition and how i want to use it. now i need a query with a where. for example, select all torrents which are in category xy or in a...