MySQL-DML-添加数据insert

MySQL-DML-添加数据insert

DML

• insert
  
  

-- DML:数据操作语言
-- DML：插入数据 - insert
-- 1. 为tb_emp表的username,name,gender字段插入值
insert into  tb_emp(username,name,gender,create_time,update_time) value ('wujing','张无忌','1',now(),now());



-- 2.为tb_emp表的所有字段插入值
insert into tb_emp(id, username, name, password, gender, image, job, entrydate, create_time,update_time)
    value (null,'zhiruo','周芷若','1234','2','1.jpg','1','2010-01-01',now(),now());

insert into tb_emp value (null,'zhiruo2','周芷若','1234','2','1.jpg','1','2010-01-01',now(),now());

-- 3. 批量为tb_emp表的username,name,gender字段插入数据
insert into  tb_emp(username,name,gender,create_time,update_time) value
                    ('weifuwang','韦蝠王','1',now(),now()),('xiexun','谢逊','1',now(),now());