Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
simple sql select does not return the correct number of rows
I have 2668 rows in my table. select count(distinct ID) from mytable; gives the following results: 2668 However, when I use: select ID from uniprot; I only get 1000 rows returned, what could be the problem? I use windows xp 1 GB ram, and mysql 4.0.18 Any help is appreciated. -
mysqlimport syntax error
Hi, Tony; thanks for the answer. It still gives me an error: Error 1064: You have an error in your SQL syntax. I begin to think that maybe there is a corruption in the installation. Or is there any other possibilities? I also tried : Try the following: mysqlimport -u user -p... -
mysqlimport syntax error
I tried the command from the dos command window from %mysql_home%\bin I tried the command from the mysql command line client mysql> both give me the same error. I tried the following and get another error: mysqlimport -u user -p --fields-terminated-by="|" database 'f:\\path\\*.dat' I get... -
mysqlimport syntax error
Dear all; I am up to my hairs. I am new to mysql. I installed mysql 4.0.18 on my windows xp machine. I am trying to import a DB from flat files. I have created the database and tables. Then I try to use the mysqlimport to do the task. I get errors. Here is two versions of syntax I used...
