基本语句

建表：
create table testdatebase(id int,names char(100))
插入数据：
insert into testdatebase(names)
select lastname from t_users group by lastname having count(*)>1
insert into b_ip(ip) values('192.168.0.72')
删除表
drop table lutest