/SQL/Mysql set id auto increment

Mysql set id auto increment

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

Auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;

2

Mysql reset auto increment id

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;

1

Source: stackoverflow.com

Mysql check auto increment value

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

0

Similar codes

2 votes180 views1 answer
Where clause for child record apex
SQL
0 vote194 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote159 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote183 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote177 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
5 votes174 views2 answers
Add column postgres with default value
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
0 vote159 views1 answer
Mysql drop multiple tables at once
SQL
-1 vote175 views3 answers
Psql get last rows
SQL
0 vote229 views1 answer
ORA-01400
SQL

Share