About insert sql on duplicate key update
来源:互联网 发布:鼠标自动点击器 mac 编辑:程序博客网 时间:2024/05/21 06:22
Here was a useful insert sql like this : insert into `table` (`field1`,`field2`,`field3`) values('value1','value2','value3') on duplicate key update `id`=`id`,`count`=`count`+1; It means if the values of field1,field2,field3 value1, value2,value3 are exist, it will update the exist row , otherwise , it will insert the row with value1, value2 ,value3. Before use this you must set `field1`,`field2`,`field3` was unique index.
- About insert sql on duplicate key update
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- insert...on duplicate key update
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE
- INSERT ... ON DUPLICATE KEY UPDATE Syntax
- INSERT INTO ON DUPLICATE KEY UPDATE 用法
- [mysql 语法]INSERT ... ON DUPLICATE KEY UPDATE
- insert ... on duplicate key update 性能
- mysql INSERT ... ON DUPLICATE KEY UPDATE
- Mysql insert xxx on duplicate key update
- UE32 删除空行正则表达式
- struts 2 的配置问题
- NPO PB问题之:Minimum 3-dimensional assignment
- MTK手机软件系统工程和配置简介
- C#图片处理基本应用(裁剪,缩放,清晰度,水印)
- About insert sql on duplicate key update
- 第一帖
- 菜鸟的起点
- 程序出错后 程序员给测试人员的20条高频回复
- 【转】Linux各种信号
- 家园守卫战关于提升双倍还是提升攻速的建议
- 关于Android平台下的H264客户端
- linux目录名称改回英文
- Inline Assembler 内联汇编