Michael Satterwhite wrote: > > Are you saying that it will propogate through the _existing_ rows, or only > > on rows added later? > > It will number all existing rows and continue with rows added later.
Interesting. In the case where you want to begin numbering existing rows at 1, is it necessary to set the autoincrement number to that of the next, i.e: > Alter Table X Auto_Increment = 201; or do you just go in, create a column with autoincrement set and wait a bit for the table to be numbered? What criteria will MySQL use to number the existing rows? Does it know the chronological order of these rows (based on physical position in the file?), or would the numbering essentially be unpredictable? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
