增删改查简单的sql语句

insert

        INSERT   INTO    t_stu   (name,age)  VALUES  ('wang',12)

        INSERT INTO    t_stu   VALUES(NULL,'wang',12)

delete

        DELETE   FROM   t_stu   WHERE   id = 6

query

        SELECT  *   FROM t_stu

update

        UPDATE   t_stu SET age = 38 WHERE  id = 1

posted @ 2019-02-10 15:27  大花猫爱吃鱼  阅读(150)  评论(0编辑  收藏  举报