 |
mysql> CREATE TABLE temp_table (col01 int,col02 char(10)) ENGINE=BLACKHOLE; 
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO temp_table VALUES (1,“AAAAAA”),(2,“BBBBBB”),(3,“CCCCCC”); 
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM temp_table; 
Empty set (0.00 sec)
mysql> UPDATE temp_table SET col02=“DDDDD” WHERE col01 = 1; 
Query OK, 0 rows affected (0.02 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> SELECT * FROM temp_table; 
Empty set (0.00 sec)
|
|