Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to write a complete graph
How to write a complete graph
Do you want to modify the starting id of the auto-increment column of a table in the database?

Do you have the data in that table now?

If you already have the data, start with 1, and then there will be errors later.

If the table is empty and there is no data, then you can

Truncated table name

Resets the current value of automatic increment to 1 by completely emptying the specified table.

Note: The above treatment methods

Used to identify the SQL Server database (1, 1).

Or MySQL AUTO_INCREMENT is valid.

If it is an Oracle database, you may need to recreate the serial number object.