关于MYSQL数据库脚本导入信息异常问题 本帖最后由 buqibushe 于 2011-01-06 22:33:13 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 MYSQL什么版本?mysql -uroot -p*** database < aaa.sqL这样试试 http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspxMySQL 中文显示乱码 pin_is 你这个字段是什么类型呢?整数?那你怎么去插进去一个空字符呢~~~ 楼主不可以把insert 的那些字段都列出来么?不插入的话 就省去别写出来. create table my_list( num_id mediumint unsigned not null, code_id char(20) not null primary key, description varchar(150) not null, unit char(3) not null, create_time timestamp not null, source_id char(10) not null, status_id enum('Active', 'Inactive') not null, item_type char(2) null, pin_is int unsigned null default 0, footprint_is varchar(20) null, family_is varchar(20) null, name_is varchar(30) null, value_is int unsigned null default 0, height_is int unsigned null default 0, diameter_is int unsigned null default 0, voltage_is int unsigned null default 0, current_is int unsigned null default 0, precision_is char(2) null, attribute char(10) null, notes varchar(100) null, use_times mediumint unsigned null default 0, use_quantity mediumint unsigned null default 0, price_rmb float not null default 0, verdor varchar(50) null default '')ENGINE=InnoDB default charset=gbk;你所说的留空是只写, , , , 隔开对应的就行?我试过好像不成呐,会出错,不知道标准的省略语句是怎么写的?多谢 ! insert into erp_bom values ('18568','CN0818022TG','PH2.0','PCS','2010-1-7 15:27','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18569','CN0813022TG','130-PH2.0','PCS','2009-11-18 15:07','ccr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18570','CN0810022KG','PH2.0-K','PCS','2009-9-23 13:51','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18571','CN0810522E','PH2.0-E','PCS','2009-9-23 13:51','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18572','CN0810522EG','PH2.0','PCS','2010-9-4 15:13','ccr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18573','CN0811022TG','PH2.0','PCS','2009-9-23 13:51','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18574','CN0811022A','PH2.0/PH2.0-A','PCS','2009-9-23 13:51','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18575','CN0812022A',PH2.0-A','PCS','2009-9-29 9:53','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18576','CN0812022CG',PH2.0-C','PCS','2009-9-29 9:53','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');insert into erp_bom values ('18577','CN0812022K','PH2.0-K','PCS','2009-9-29 9:53','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');i my_list就是erp_bom,临时写上的 求一存储过程,遍历树 mysql 的二进制分发版 的下载链接? MyISAM的数据表最近总是出问题! linux 下mysql 问题(急) 初学mysql,简单问题 mysql连接与关闭问题 关于日期的两个问题 急呀!在mysql中。。。如何象sqlserve中的返回数据集中的前指定的数据 听说mysql从4.0开始支持transaction? InnoDB表类型是什么意思 我想问一下mysql-5.0.18-win32这个版本支不支持在Win7上安装 mysql集群问题
mysql -uroot -p*** database < aaa.sqL
这样试试
MySQL 中文显示乱码
楼主不可以把insert 的那些字段都列出来么?不插入的话 就省去别写出来.
create table my_list
( num_id mediumint unsigned not null, code_id char(20) not null primary key, description varchar(150) not null, unit char(3) not null, create_time timestamp not null, source_id char(10) not null, status_id enum('Active', 'Inactive') not null, item_type char(2) null, pin_is int unsigned null default 0, footprint_is varchar(20) null, family_is varchar(20) null, name_is varchar(30) null, value_is int unsigned null default 0, height_is int unsigned null default 0, diameter_is int unsigned null default 0, voltage_is int unsigned null default 0, current_is int unsigned null default 0, precision_is char(2) null, attribute char(10) null, notes varchar(100) null, use_times mediumint unsigned null default 0, use_quantity mediumint unsigned null default 0, price_rmb float not null default 0, verdor varchar(50) null default '')ENGINE=InnoDB default charset=gbk;你所说的留空是只写, , , , 隔开对应的就行?我试过好像不成呐,会出错,不知道标准的省略语句是怎么写的?多谢 !
insert into erp_bom values ('18568','CN0818022TG','PH2.0','PCS','2010-1-7 15:27','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18569','CN0813022TG','130-PH2.0','PCS','2009-11-18 15:07','ccr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18570','CN0810022KG','PH2.0-K','PCS','2009-9-23 13:51','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18571','CN0810522E','PH2.0-E','PCS','2009-9-23 13:51','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18572','CN0810522EG','PH2.0','PCS','2010-9-4 15:13','ccr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18573','CN0811022TG','PH2.0','PCS','2009-9-23 13:51','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18574','CN0811022A','PH2.0/PH2.0-A','PCS','2009-9-23 13:51','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18575','CN0812022A',PH2.0-A','PCS','2009-9-29 9:53','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18576','CN0812022CG',PH2.0-C','PCS','2009-9-29 9:53','cr','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
insert into erp_bom values ('18577','CN0812022K','PH2.0-K','PCS','2009-9-29 9:53','cc','Active','P', '', '', '', '', '', '', '', '', '', '', '', '' ,'', '', '', '');
i