bulk_replace.result
Upload User: romrleung
Upload Date: 2022-05-23
Package Size: 18897k
Code Size: 0k
Category:

MySQL

Development Platform:

Visual C++

  1. drop table if exists t1;
  2. CREATE TABLE t1 (a int, unique (a), b int not null, unique(b), c int not null, index(c));
  3. replace into t1 values (1,1,1),(2,2,2),(3,1,3);
  4. select * from t1;
  5. a b c
  6. 3 1 3
  7. 2 2 2
  8. check table t1;
  9. Table Op Msg_type Msg_text
  10. test.t1 check status OK
  11. drop table t1;