CREATE TEMPORARY TABLE tmp_table (
name VARCHAR(10) NOT NULL,
value INTEGER NOT NULL
)
http://www.it201.com/jianzhan/wzkf/shujuku/MySQL/200510/3696.html
name VARCHAR(10) NOT NULL,
value INTEGER NOT NULL
)
http://www.it201.com/jianzhan/wzkf/shujuku/MySQL/200510/3696.html
select * from tmp;
(
name varchar(255),
shift varchar(100))insert into t_name(name,shift) value('tome','DV')
这样对不对,数据能保存到吗?