Linux命令

1. command -options parameter
2. 当touch所创建的文件名不存在时则创建新文件，如果存在的话，就会对该文件进行修改时间的刷新
3. 只有mv 命令例外，其他涉及到文件夹的命令 例如 rm cp 都要使用-r参数  
4. rmdir  可以删除空文件夹
5. tar 打包  解包  压缩  解压

6. CREATE DATABASE work CHARSET = utf8;
   USE work;
   CREATE TABLE classes(
       id int PRIMARY KEY ,
       name varchar(10)
   );
   INSERT INTO classes
   VALUES (1,'1班'),(2,'2班'),(3,'3班'),(4,'4班');
   CREATE TABLE students(
       studentNo int PRIMARY KEY ,
       name      varchar(10),
       sex         varchar(5),
       hometown    varchar(15),
       age        int,
       class_id    int,
       card       int
   );
   # 这里card使用varchar（）类型
   ALTER TABLE students CHANGE card card varchar(20);
   INSERT INTO students VALUES
   (1,'王昭君','女','北京',20,1,340322199001247654),
   (2,'诸葛亮','男',' 上海', 18, 2,340322199002242354),
   (3,' 张飞 ',' 男','南京',24 ,3 ,340322199003247654),
   (4,'白起',' 男 ','安徽', 22, 4,340322199005247654),
   (5,'大乔 ','女','天津 ',19 ,3 ,340322199004247654),
   (6,'孙尚香  ','女','河北 ', 18, 1,340322199006247654),
   (7,'百里玄策 ',' 男 ','山西  ', 20,2 ,340322199007247654),
   (8,'小乔','女',' 河南', 15,3 , NULL),
   (9,'百里守约',' 男 ','湖南',21 , 1,NULL),
   (10,'妲己','女','广东',26 , 2, 340322199607247654),
   (11,'李白',' 男 ',' 北京', 30, 4, 340322199005267754),
   (12,'孙膑',' 男 ','新疆', 26, 3,340322199000297655);
   SELECT * FROM students ORDER BY sex;
   SELECT DISTINCT hometown FROM students;
   SELECT * FROM students WHERE sex LIKE '%男%' ORDER BY age;
   SELECT count(*) AS '学生数'FROM students;
   SELECT count(*) FROM students WHERE age>20;
   SELECT avg(age) FROM students WHERE sex LIKE '%男%';
   SELECT max(age) FROM students WHERE class_id = 1;
   SELECT count(*) AS '男生人数' FROM  students WHERE class_id=1 AND sex LIKE '%男%';
   SELECT count(*) AS '女生人数' FROM students WHERE class_id=1 AND sex LIKE '%女%';
   # 11题
   SELECT  FROM students ;
   #
   #
   #
   USE work;
   CREATE TABLE book(
       id int,
       name varchar(15),
       pub_date varchar(20),
       price decimal
   );
   INSERT INTO book VALUES
                       (1,'射雕英雄传','1970-05-01 00:00:00', 36.60      ),
                        (2,'天龙八部 ','1986-07-24 00:00:00 ',50.20      ),
                        (3,'笑傲江湖 ','1995-12-24 00:00:00 ', 40.00      ),
                        (4,'雪山飞狐',' 1987-11-11 00:00:00', 29.00       );
   ALTER TABLE book CHANGE price price double;
   UPDATE book SET price=36.60 WHERE id=1;
   UPDATE book SET price=50.20 WHERE id=2;
   UPDATE book SET price=40.00 WHERE id=3;
   UPDATE book SET price=29.00 WHERE id=4;
   
   CREATE TABLE heroes (
       id int,
       name varchar(10),
       age int,
       gender varchar(10),
       skill varchar(10),
       book_id int
   );
   INSERT INTO heroes VALUES
                          (1,'郭靖',30,'男','降龙十八掌',1),
                          (2,'黄蓉',30,' 女 ','打狗棍法',1),
                          (3,' 黄药师',60,'男','弹指神通',1),
                          (4,' 欧阳锋 ',65,'男','蛤蟆功',1),
                          (5,' 梅超风',40,' 女 ','九阴白骨爪',1),
                          (6,'乔峰',33,'男','降龙十八掌',2),
                          (7,'段誉  ',25,'男','六脉神剑',2),
                          (8,' 虚竹',27,'男','天山六阳掌 ',2),
                          (9,'王语嫣  ',18,' 女 ','神仙姐姐',2),
                          (10,'令狐冲',32,'男','独孤九剑 ',3),
                          (11,' 任盈盈',24,'女','弹琴',3),
                          (12,'岳不群',50,'保密','华山剑法',3),
                          (13,' 东方不败',99,'中性','葵花宝典 ',3),
                          (14,'胡斐',26,'男','胡家刀法 ',4),
                          (15,'苗若兰  ',16,' 女 ',' 黄衣',4),
                          (16,' 程灵素   ',20,' 女 ','医术',4),
                          (17,' 袁紫衣',22,' 女 ','六合拳',4);
   ALTER TABLE book CHANGE pub_date pub_date date;