Horje
how to auto increment in sql Code Example
sql query to make a existing column auto increment 
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
Source: stackoverflow.com
how to auto increment in sql 
CREATE TABLE Persons (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (Personid)
);
INSERT INTO Persons (FirstName,LastName)
VALUES ('Lars','Monsen');




Related
get all table name in sql through php Code Example get all table name in sql through php Code Example
sql server substring Code Example sql server substring Code Example
finding duplicate column values in table with sql Code Example finding duplicate column values in table with sql Code Example
select duplicates in sql Code Example select duplicates in sql Code Example
selecting name that contain certain word in sql Code Example selecting name that contain certain word in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 11



 

Horje