/SQL/Auto increment column in mysql query results

Auto increment column in mysql query results

Auto increment column in mysql query results

SET @auto_increment=0;
SELECT @auto_increment := @auto_increment+1 AS `No`;

1

Add auto_increment column to existing table mysql

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT UNIQUE FIRST

-1

Similar codes

3 votes155 views1 answer
What is having
SQL
2 votes133 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote139 views1 answer
Sql select column name like from multiple tables
SQL
0 vote114 views1 answer
Import sql mysql ubuntu
SQL
0 vote123 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote131 views1 answer
Mysql xampp reset root password
SQL
22 votes130 views4 answers
Show list of users in mysql
SQL
3 votes143 views1 answer
Oracle list invalid password logon denied
SQL
0 vote121 views1 answer
Import big data to mysql
SQL

Share