insert into table1 select * from table2 --------------------------------------------------a例中有些值插不进去,真是怪事了.... 意思是,a中明显有数据但是插到table1表后,发现变成空值了? 注:table1,table2的结构是一样的。。这样也不行:
CREATE TABLE table1 AS select * from table2 where id=1000098;------------值还是空的
table2的表结构如下:CREATE TABLE `table2` (
`id` int(4) unsigned NOT NULL auto_increment,
`NAME` varchar(7) character set gb2312 collate gb2312_bin NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
select * from table2的结果如下:id name
1000098 輹仇鍺—select * from table1的结果如下:id name
1000098
CREATE TABLE table1 AS select * from table2 where id=1000098;------------值还是空的
table2的表结构如下:CREATE TABLE `table2` (
`id` int(4) unsigned NOT NULL auto_increment,
`NAME` varchar(7) character set gb2312 collate gb2312_bin NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
select * from table2的结果如下:id name
1000098 輹仇鍺—select * from table1的结果如下:id name
1000098
这样也不行:
CREATE TABLE table1 AS select * from table2 where id=1000098; -----------------------这样还会不一至吗?
or
SHOW CREATE TABLE tbl_name
你这样建立的表的字符集为系统默认的字符集,跟table2的不一样而引起的
SHOW CREATE TABLE tbl_name
结果