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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JoLiang
  • Content: Threads
  • Order by date
  1. JoLiang

    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.
  2. JoLiang

    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...

Part and Inventory Search

Back
Top