Example #1
0
 public function testInsertStatement_OnDuplicateKeyUpdate_arrayKeyValue()
 {
     $query = new Query("INSERT INTO table (a,b,c) VALUES (1,2,3)");
     $query->onDuplicateKeyUpdate(array("a" => 15, "c" => 14));
     $this->assertEquals("INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE `a` = 15, `c` = 14", (string) $query);
 }