Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql query to make a existing column auto increment

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle select first 10 rows 
Sql :: possgress drop if exists table 
Sql :: mysql show indexes on table 
Sql :: how to remove characters from string in mysql 
Sql :: how to duplicate table in mysql 
Sql :: mysql 1 day ago 
Sql :: sql drop schema 
Sql :: select records for day before yesterday mysql 
Sql :: postgresql print sessions using the database 
Sql :: mysql backup 
Sql :: oracle start job 
Sql :: oracle user last connection date 
Sql :: mariadb alter user host 
Sql :: alter sequence postgres 
Sql :: postgresql datetrunc too slow 
Sql :: postgresql select all column names 
Sql :: sql convert datetime to year month 
Sql :: postgres extract number from string 
Sql :: mysql select table names 
Sql :: how to alter table name in mysql 
Sql :: how much every mysql database record takes from diskspace 
Sql :: check database size in mysql 
Sql :: psql is not recognized 
Sql :: execution plan oracle 
Sql :: oracle kill session by sql_id 
Sql :: operator does not exist: integer = text 
Sql :: mysql add comment to column 
Sql :: mysql breakline on string 
Sql :: change table to innodb mysql 
Sql :: add column to table sql 
ADD CONTENT
Topic
Content
Source link
Name
9+8 =