基础SQL语句

select name, id, age, address, minzu, gzaddr, zy, whcd, zzmm, phone, updatetime from person.abu_1  

select DISTINCT zzmm from person.abu_1

select name, id, age, address, minzu, gzaddr, zy, whcd, zzmm, phone, updatetime from person.abu_1  where phone like '158%'  --使用单引号

select name, id, age, address, minzu, gzaddr, zy, whcd, zzmm, phone, updatetime from person.abu_1  where phone like '158%' and name LIKE '36%' --and|or

select name, id, age, address, minzu, gzaddr, zy, whcd, zzmm, phone, updatetime from person.abu_1  ORDER BY id --asc|DESC

insert into abu_1(name, id,updatetime) VALUES ('名称','3462347',now())

update abu_1 set name = '名称2' where id = '3462347'

delete from abu_1 where id = '3462347'