解决方案 »
- erro 4
- mysql 查询语句问题 set @Id := 9;select * from `table` WHERE `Id`=@Id;
- 问个sending data问题
- 求一SQL语句
- 在安装mysql-4.0.26 时,出现了问题,哪位大侠能告诉我是怎么回事呀??(我的操作系统是WIN 2000 server)
- mysql在企业中能否担当象SQL-SERVER这样的角色?
- mysql manager快到期了,怎么办?
- 请问如何在mysql中增加和删除用户?
- 怎么回事?我的mysql数据库用任意用户名都能联接显示?而mysql的user表中没设它们啊????? (请看)
- mysql 可重复执行脚本编写
- 我想问一下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