基础MySQL的数据库和表的创建以及数据的增删改查

1、创建的是一个员工表

①创建数据库的语句

create database des;

②创建表的sql语句：

create table emp(
    id int comment '编号',
    warkno varchar(10) comment '工号',
    name varchar(32) comment '姓名',
    gender varchar(10) comment '性别',
    age int comment '年龄',
    idcard char(18) comment '身份证号',
    workaddress varchar(32) comment '地址',
    entrydate date comment '入职时间'
) comment '员工表';

③添加数据

（1）给指定的字段添加值

语法：insert into 表名（字段1，字段2,...）values（值1，值2,...）；

1. 给全部字段添加数据

语法：inser into 表名 values （值1，值2...）

批量添加数据

语法：insert into (字段1,字段2,...) values (值1,值2,...),(值1,值2,...);

表格中所用到的数据：

insert into emp (id,warkno,name,gender,age,idcard,workaddress,entrydate)
values (1,'1','李勇','女','22','null','河南新乡','2001-01-09'),
       (2,'2','张晨','男','20','410888000666686668','河南汝州','2001-06-09'),
       (3,'3','张碧','男','22','410899000666688668','河南信阳','2001-09-09'),
       (4,'4','刘文','女','21','41089900066666666X','河南新乡','2001-08-09'),
       (5,'5','王梓','女','25','410899770666686668','河南商丘','2001-01-29'),
       (6,'6','张佳佳','女','28','41089900066699666X','河南焦作','2001-01-19'),
       (7,'7','刘麻子','女','20','410899990666686668','河南新乡','2001-02-09'),
       (8,'8','张三','女','24','410899900666686668','河南新乡','2001-08-09'),
       (9,'9','李四','男','20','null','河南新乡','2001-08-09'),
       (10,'10','姚浮','女','25','410899008866686668','河南','2001-11-09'),
       (11,'11','冯涵','女','28','41066600066668666X','河南','2011-06-09'),
       (12,'12','李欣','男','20','null','河南','2008-09-09'),
       (13,'13','肖寒','男','23','410787000666666668','河南','2009-08-09'),
       (14,'14','王麻子','女','28','410899770667865668','河南','2001-08-29'),
       (15,'15','张浩','男','20','null','河南','2010-01-19'),
       (16,'16','张伞','女','20','41089999099068666X','河南','2008-02-09'),
       (17,'17','鲁尼','男','29','416668900666686668','河南','2007-08-09'),
       (18,'18','嗯哼','女','22','410886000699686668','河南','2009-08-09');

/*1、查询字段name，warkno,age返回*/
select name,warkno,age from