1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
create temporary table t1 (col1 int not null, col2 char(4) not null, primary key(col1)) engine=memory; alter table t1 engine=myisam; insert into t1 values (1,1),(5,2),(2,3),(3,4),(4,4); select * from t1; col1 col2 1 1 5 2 2 3 3 4 4 4 update t1 set col2='7' where col1='4'; select * from t1; col1 col2 1 1 5 2 2 3 3 4 4 7 DROP TABLE t1; |