/SQL/Primary key start from number

Primary key start from number

Primary key start from number

#only if the table is created
ALTER TABLE tbl AUTO_INCREMENT = 1000;

#if table is yet to be created
CREATE TABLE tbl (tbl_id AUTO_INCREMENT = 1000);

0

Source: stackoverflow.com

Similar codes

0 vote302 views1 answer
Authentication modes in sql server
SQL
0 vote282 views1 answer
Get number of tables in database sql
SQL
0 vote314 views1 answer
How to create notes in mysql
SQL
0 vote291 views1 answer
Mysqlcli how to load external sql file
SQL
1 vote282 views1 answer
Mysql change root mysql_native_password
SQL
7 votes295 views1 answer
Oracle pagination query offset
SQL
0 vote298 views1 answer
How to reset the database value in SQL server
SQL
3 votes293 views1 answer
Kill mysql processlist in whose time more than 200
SQL
3 votes323 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote286 views1 answer
How to get data between a last week in mysql
SQL

Share