mysql基本操作，及多表操作

*假设有两张表user，info

            1.insert
1.1 在一张表中插入数据
INSERT INTO USER (NAME, AGE)
VALUES ('xiaoming', 18);

1.2 把info表中的name,age数据插入到user表中
INSERT INTO USER (NAME, AGE) SELECT
    NAME,
    AGE
FROM INFO;

           2.update
2.1 一张表中更新数据
update user set name='laowang',age=16 where id=8;

2.2 借助info表更新数据
update user AS a 
       JOIN
       info AS b 
       SET a.AGE=b.AGE;
这里JOIN 等于 inner join，as可省略

            3.alter
3.1 表中新增字段
ALTER TABLE user ADD email varhcar(40);
3.2 表中更新字段
ALTER TABLE user CHANGE age love varchar(40) not null;

   4.其它
insert into info(name,password) select name,password from user group by password having password like concat(concat('%','123'),'%') order by password;