insert(新增一条数据)
insert 语法 :insert into 表名(字段名,字段名,字段名) values (字段值,字段值,字段值,字段值,字段值):
插入的时候保证字段的类型一致,个数一致
insert into t_student (no,name,gender,birth,email) values (1,'lili','1',str_to_date('1949-04-06','%Y-%m-%d'),'lili@qq.com');
insert into t_student (no,name,gender,birth,email) values (2,'lihua','0','1999-04-06','lihua@qq.com');
insert into t_student (no,name,gender,birth,email) values (3,'han','0',str_to_date('04-06-1902',‘%m-%d-%Y’),'han@qq.com');
insert into t_student (no,name,gender,birth,email) values (4,'lilei','1');
给哪个指定字段赋值就写那个字段
insert into t_student values (5,'jerry','1','1969-06--06','jerry@qq.com'); (程序的可读性太差,不健壮,容易出错 )(默认给每一个字段赋值)
给哪一个字段赋值,就写那一个字段(指定字段赋值)
tips:myspl数据库默认的格式是年月日
update(修改数据)
语法:update 表名 set 字段名称 = 字段值,字段名称 = 字段值 where 限制条件;(要有限制条件,否则会把表中的所有的数据改变)
update t_student set birth = str_to_date('1946-06-06','%Y-%m-%d') where no = 4;
update t_student set gender = 0,birth = str_to_date('1946-06-06','%Y-%m-%d') where no = 4;
delete(删除数据)
语法:delete from 表名;(删除所有的数据)
delete from t_student;
delete from t_student where no = 4;