INSERT INTO t (t.a, t.b, t.c)
VALUES ('key1','key2','value'), ('key1','key3','value2')
ON DUPLICATE KEY UPDATE
t.c = VALUES(t.c)
- Dec 29 Fri 2017 00:01
insert into duplicate key update 多個row一次插入
- Dec 28 Thu 2017 22:17
foreign key cascade restrict set null, index 範例
- Dec 28 Thu 2017 15:28
mysql 配對問題
- Dec 28 Thu 2017 00:27
mysql select case null
- Dec 28 Thu 2017 00:18
Fatal error: Cannot use object of type as array in
- Dec 27 Wed 2017 22:00
mysql 大量 insert
- Dec 27 Wed 2017 21:26
php mysql sql injection
- Dec 27 Wed 2017 20:48
mysql 插入 當不存在相同值時
insert into t1 (name) select 'john' from dual where not exists (select 1 from t1 where name='john' limit 1 )
解:
- Dec 27 Wed 2017 17:10
alter table 修改欄位名或欄位type ,create index
- Dec 27 Wed 2017 16:39
mysql f exist用法 drop table 和