CREATE TABLE stu
(
id
int(7) NOT NULL,
name
varchar(11) DEFAULT NULL,
age
int(7) DEFAULT NULL,
birthday
date DEFAULT NULL,
insert_time
timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into stu(列名…)//可省略 values(值…);
delete from stu where id=1;
TRUNCATE table stu;清空表
UPDATE stu SET age = 117 WHERE id =1;