Steve Grosz wrote:
I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 exactly.
I'm not 100% sure but this is what I think happened. You imported data from Excel into MySQL then used the MySQLCC GUI to look at the data in the table. MySQLCC only returns the first 1000 records when you view a table. If you right click on the table name and select Open Table -> Return Limit, and then enter a number high enough to get all your records you will then see all of them. If you want to know how many records you have in the table, after opening the table click on the SQL button and change,
SELECT * FROM `table`
to
SELECT count(*) FROM `table`
and you will get the total number of records.
If I'm wrong and you were taking data from MySQL and importing it to Excel, I don't know for sure what happened.
-- Chris W
Gift Giving Made Easy
Get the gifts you want & give the gifts they want
http://thewishzone.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
