Create a table with an id in mysql

CREATE TABLE DemoT (
    Personid int NOT NULL AUTO_INCREMENT,
    LastName varchar(111) NOT NULL,
    FirstName varchar(111),
    Age int,
    PRIMARY KEY (Personid)
);

Similar codes

6 votes124 views5 answers
Sql add months to date
SQL
0 vote183 views2 answers
Fanyi
SQL
11 votes127 views2 answers
How to import mysql database command line
SQL
5 votes116 views3 answers
Oracle list columns in schema
SQL
3 votes114 views1 answer
Uppercase and lowercase in sql
SQL
0 vote134 views1 answer
Default password for mysql_secure_installation in mac
SQL
17 votes135 views6 answers
MySQL ORDER BY
SQL
8 votes114 views2 answers
Between operator
SQL
31 votes126 views2 answers
Grant all priviledges to mysql user
SQL
0 vote109 views1 answer
Min mysql
SQL