原生数据库操纵语句

插入数据

INSERT INTO a_user (xm_user_name,xm_user_pwd) VALUES ("大白","124325436")

更新数据

update a_user set xm_user_pwd='mima123',xm_user_mail='972069047@qq.com' where xm_uid=20

删除语句

DELETE FROM a_user WHERE xm_uid=20

查询语句

SELECT xm_uid,xm_user_name FROM a_user WHERE xm_uid<10

 

posted @ 2016-11-11 13:29  简庆旺  阅读(350)  评论(0编辑  收藏  举报