MySQL对表数据进行增删改查

插入

INSERT INTO `db_student`.`t_student` (`id`, `stuName`, `age`, `sex`, `gradeName`)VALUES('15','tom', '22', '男', '大四'); 

删除

DELETE FROM `db_student`.`t_student` WHERE `id`='16'; 

修改

UPDATE `db_student`.`t_student` SET `sex`='男',`gradeName`='大四' WHERE `id`='16';

查找

SELECT * FROM db_miaosha.`t_user` WHERE id=14;