first record is skipped in select and shows up last

2004-07-06 Thread leegold
What would be the cause of the following situation?

I do a select * from a table and sort by the pk. The first line/record
is notably empty/not there, and content starts w/2nd record, and what
should be the 1st record appears at the end after the what should be the
very last record. But doing a limit 0,1 will get the 1st rec btw.

Is there more info I can give you? I'm I overlooking something?

Thanks,

Lee G.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: first record is skipped in select and shows up last

2004-07-06 Thread Paul DuBois
At 10:22 -0400 7/6/04, leegold wrote:
What would be the cause of the following situation?
I do a select * from a table and sort by the pk. The first line/record
is notably empty/not there, and content starts w/2nd record, and what
should be the 1st record appears at the end after the what should be the
very last record. But doing a limit 0,1 will get the 1st rec btw.
Is there more info I can give you? I'm I overlooking something?
The actual queries and some sample output to demonstrate the problem
would be helpful.  Otherwise, we're just guessing.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]