mrherman Posted November 2, 2010 Share Posted November 2, 2010 I have 6 MySQL tables of approximately 2000 rows each. Each table has lots of columns (200+). There is not a primary key. When I receive the tables, I update them and number one of the columns to number the rows sequentially from 1 to 2000. I process the tables (just run some stats) one row at at time and output each row into another table. So, I end up with 6 output tables with about 2000 rows each. Four of the output tables are as I'd expect...The rows are in the same sequence as the input tables per the row numbers. However, two of the output tables contain a completely random arrangement of the rows. They are process by the same script as the others. I cannot understand why this happens with two tables. So my question is, just from what I've stated above, what might be the explanation for this? Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 7, 2010 Share Posted November 7, 2010 I don't know what you mean -- rows are in arbitrary order unless you specify an order by clause. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.