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

1 vote385 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote269 views1 answer
Oracle last user logon
SQL
3 votes322 views1 answer
Oracle apex warning message
SQL
0 vote338 views1 answer
Postgres create extension if not exists
SQL
2 votes340 views1 answer
Mysql now format
SQL
0 vote331 views1 answer
Alter fedora mysql 8.0 user
SQL
1 vote387 views1 answer
Default
SQL
0 vote336 views1 answer
Max mysql
SQL
-1 vote339 views2 answers
Postgresql user permissions to database
SQL
3 votes321 views2 answers
Oracle synonym
SQL