[jude]

Hi Ashwin,

Thank you very much for your reply. That makes me understand this problem more.

Now, when I create a new row, the automatically generated 'id' is 10000. But I want the automatically generated 'id' is 9800, rather than 10000, how can I do that? Btw, Can I disable this “Auto-increment”?

Thanks.

Huang

'ashwin' wrote:

Hi,

The row ordering is done by the server not by SQLyog. This is because the “Auto-increment” is enabled on the column('id' in your case). So MySQL assigns sequence numbers automatically.

To start with an AUTO_INCREMENT value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

ALTER TABLE tbl AUTO_INCREMENT = 100;

Refer: http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

Thanks,

Ashwin A

[Author]

Posts