create table table name(
Column name 1 data type 1,
Column name 2 data type 2,
Column name 3 data type 3,
...
Column name n data type n
);
Note: The last column, no need to add a comma (,)
< div class="Highlighter">
create table table name like the name of the copied table;
Common data types:
Detailed data type:
Note< /strong>: timestamp: timestamp type, including year, month, day, hour, minute and second yyyy-MM-dd HH:mm:ss, if not in the future Assign a value to this field, or assign it to null, the current system time will be used by default to automatically assign the value
show tables;
desc table name;
show create table table name;
alter table Table name rename to new table name
alter table table name character set character set name;
alter table table name add column name data type
alter table table name change column name new column name new data type;
alter table table name modify alias new data type;
alter table table name drop column name
drop table Name;
drop table if exists table name;
create table name(
Column name 1 data type 1,
Column name 2 data type 2,
Column name 3 data type 3,
...
Column name n data type n
);
create table table name like is copied The name of the table;
show tables;
desc table name;
show create table table name;
alter table rename to new Table name
alter table table name character set character set name;
alter table table name add column name data type
alter table table name change column name new column name new data type;
alter table table name modify alias new data type;
alter table table name drop column name
drop table table name;
drop table if exists table name;