4,348
edits
MySQL: Difference between revisions
→Update auto_increment value for a table: Read the auto_increment of a table
→Checking the status of the replication setup: Update auto_increment value for a table |
→Update auto_increment value for a table: Read the auto_increment of a table |
||
| Line 140: | Line 140: | ||
== Update auto_increment value for a table == | == Update auto_increment value for a table == | ||
Read the auto_increment of a table. | |||
<source lang="mysql"> | <source lang="mysql"> | ||
mysql> alter table auto_increment = 388; | mysql> select `auto_increment` from information_schema.tables where table_schema = 'iechomain' and table_name = 'user_sites'; | ||
</source> | |||
<source lang="mysql"> | |||
mysql> alter table users auto_increment = 388; | |||
</source> | </source> | ||