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