04 2016 档案

mysql replace用法

摘要：replace into 插入记录 mysql> select * from testreplace; mysql> replace into testreplace(id,name) values(1, '1'), (2, '2'), (3,'3'); mysql> select * from testreplace; replace(object,search... 阅读全文

posted @ 2016-04-29 10:28 leungcnblogs 阅读(169) 评论(0) 推荐(0) 编辑

MySQL transaction

摘要：MySQL事务操作事务rollback mysql> start transaction; Query OK, 0 rows affected (0.00 sec) mysql> insert into tbtest(stu_ID,stu_Name) values(201,'stu_1'); Qu 阅读全文

posted @ 2016-04-28 12:06 leungcnblogs 阅读(515) 评论(0) 推荐(0) 编辑