At 5:34 PM -0500 7/15/07, Andrew Carlson wrote:
I have created a new table, with an auto_increment value. I would like the
first auto_increment value to be 1001. So I -
1) inserted a fake record with an id of 1000
2) alter table tblname auto_increment=1000 (with and without a fake record)
3) alter table tblname auto_increment=1001 (with and without a fake record)
Mysql version is 5.0.38 using MyIsam tables. Can someone explain
auto_increment, more than what is in the manual? I have read it, and
apparently I am missing something or don't understand it. Thanks!
We could probably explain it better if you said just what it is you're
wondering about. For example, did the things you try not work and you're
wondering why? You didn't say what were the results of your actions,
nor whether they were what you expected.
Please clarify.
--
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]
