/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

0 vote151 views1 answer
SQL FROM-Klausel
SQL
0 vote159 views1 answer
Plsql check for string in numeric
SQL
25 votes149 views1 answer
Mysql grant all privileges to a user
SQL
0 vote156 views1 answer
Sql search all columns of database oracle sql
SQL
14 votes176 views6 answers
Finding duplicate rows mysql
SQL
0 vote152 views1 answer
Create database store
SQL
0 vote146 views1 answer
Oracle current timestamp
SQL
8 votes141 views1 answer
Unique vs primary key
SQL
0 vote148 views1 answer
Oracle current timestamp insert statement
SQL
0 vote171 views1 answer
Mysql into outfile with headers
SQL

Share