MySQL数据表的基本操作命令(DML)

mysql： （insert，delete，replace，alter，update）

时间函数：curtime，timestamp，interval）

插入数据的几种方式：

insert into  runoob_tbl (runoob_title,runoob_author,submission_date)  values("学习 PHP","龟叔",now());

insert into runoob_tbl values(null,'linux','unix',null);

replace  into  runoob_tbl (runoob_title,runoob_author,submission_date)  values("学习 PHP","龟叔",now());

replace  into  runoob_tbl (runoob_title,runoob_author,submission_date)  values("学习 C++","computer",now());

replace 和insert的区别

删除数据

delete  from rock  where runoob_id = 8;

删除表

drop table rock；

清空表

truncate table  rock；

修改表字段

alter table runoob_tbl modify column submission_date date;

alter table runoob_tbl modify column submission_date timestamp null default current_timestamp on update current_timestamp comment '创建时间';

alter table runoob_tbl modify column submission_date timestamp not null default current_timestamp  comment '创建时间';

修改表中数据

update runoob_tbl set submission_date=null where runoob_id =1;

修改日期为1天前

update runoob_tbl set submission_date=DATE_SUB(curtime(),INTERVAL 1 DAY)  where runoob_id =3;

修改日期为1个小时之后

update runoob_tbl set submission_date=DATE_SUB(curtime(),INTERVAL -1 hour)  where runoob_id =5;