笔记：数据库操作

1：创建数据表 并从其他表插入数据 

 create()  select name  from user   //两个语句没有分号隔开

2 多表更新  //使用连接后 set 更新表

update pd inner join brand as bd on  bd.b_name =pd.bandname 

set pd.bandname = bd.id

3 删除表中重复数据

delete p1 from pd as p1 

 left join (select * from pd as p2 group by p2.name having count(name) as count >1) as p2  on p1.name =p2.name 

where p1.id >p2.id