mysql操作表的语句

mysql的增删改查

#查询
select * from table1
#添加
insert into table1 (name,password,age) values(444,4444,4444.44);
#删除
delete from table1 where `id`=3
#修改
update table1 SET  name=555,password=555,age=55 where id=4