Lines Matching refs:label
34 …!$link->query("CREATE TABLE test (id INT auto_increment, label varchar(10) not null, PRIMARY KEY (…
35 !$link->query("INSERT INTO test (id, label) VALUES (null, 'a')")) {
65 if ($link->query("INSERT INTO test (id, label) VALUES (null, null)")) {
108 if (!$link->query("INSERT INTO test(id, label) VALUES (LAST_INSERT_ID(id + 1), 'b')"))
116 if (!$link->query("INSERT INTO test(label) VALUES ('c')"))
124 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
129 printf("id = %d, label = '%s'\n", $row['id'], $row['label']);
133 if (!$link->query("INSERT INTO test(label) SELECT CONCAT(label, id) FROM test ORDER BY id ASC"))
141 …if ($link->query("INSERT INTO test(id, label) SELECT id, CONCAT(label, id) FROM test ORDER BY id A…
155 …if (!$link->query(sprintf("INSERT INTO test(id, label) VALUES (%d, 'z') ON DUPLICATE KEY UPDATE id…
166 if (!($res = $link->query("SELECT id, label FROM test ORDER BY id ASC")))
171 printf("id = %d, label = '%s'\n", $row['id'], $row['label']);
184 id = %d, label = 'b'
185 id = %d, label = 'a'
186 id = %d, label = 'c'
188 id = %d, label = 'b'
189 id = %d, label = 'a'
190 id = %d, label = 'c'
191 id = %d, label = 'a%d'
192 id = %d, label = 'c%d'
193 id = 101, label = 'b%d'