Navicat 运行SQL文件报错，求大神帮忙解决

Question

[Err] 1629 - Comment for field 'status' is too long (max = 609)
[Err] INSERT INTO b_goods VALUES ('25', '测试2', '19', '吨', '1');
INSERT INTO b_goods VALUES ('26', '大豆', '22', '吨', '1');
INSERT INTO b_goods VALUES ('27', '糖果', '4', '某', '1');

---

-- Table structure for b_inquiry

---

DROP TABLE IF EXISTS b_inquiry;
CREATE TABLE b_inquiry (
id int(11) NOT NULL AUTO_INCREMENT,
order_id varchar(30) DEFAULT NULL COMMENT '运单id',
inquiry_num varchar(40) DEFAULT NULL COMMENT '询价单序号',
carrier_id int(20) DEFAULT NULL COMMENT '承运人id',
money varchar(20) DEFAULT NULL COMMENT '承运人报价',
car_id int(10) DEFAULT NULL COMMENT '车辆表id',
PRIMARY KEY (id),
UNIQUE KEY inquery_num (inquiry_num) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

---

-- Records of b_inquiry

---

INSERT INTO b_inquiry VALUES ('1', '161122000002', '16112200000201', '1', null, null);
INSERT INTO b_inquiry VALUES ('2', '161122000002', '16112200000202', '7', null, null);
INSERT INTO b_inquiry VALUES ('3', '161122000002', '16112200000203', '8', '3600', null);
INSERT INTO b_inquiry VALUES ('4', '161122000002', '16112200000204', '12', '4300', null);
INSERT INTO b_inquiry VALUES ('5', '161122000002', '16112200000205', '13', null, null);
INSERT INTO b_inquiry VALUES ('6', '161122000007', '16112200000706', '7', null, null);
INSERT INTO b_inquiry VALUES ('7', '161122000007', '16112200000707', '8', '4500', null);
INSERT INTO b_inquiry VALUES ('8', '161122000007', '16112200000708', '12', null, null);
INSERT INTO b_inquiry VALUES ('9', '161122000009', '16112200000909', '1', '88', null);
INSERT INTO b_inquiry VALUES ('10', '161122000009', '16112200000910', '7', '77', null);
INSERT INTO b_inquiry VALUES ('11', '161122000009', '16112200000911', '8', null, null);
INSERT INTO b_inquiry VALUES ('12', '161122000009', '16112200000912', '12', '0', null);
INSERT INTO b_inquiry VALUES ('13', '161122000014', '16112200001413', '1', '2500', null);
INSERT INTO b_inquiry VALUES ('14', '161122000014', '16112200001414', '7', null, null);
INSERT INTO b_inquiry VALUES ('15', '161122000013', '16112200001315', '1', '13', null);
INSERT INTO b_inquiry VALUES ('16', '161122000013', '16112200001316', '7', null, null);
INSERT INTO b_inquiry VALUES ('17', '161122000013', '16112200001317', '8', null, null);
INSERT INTO b_inquiry VALUES ('18', '161122000013', '16112200001318', '12', null, null);
INSERT INTO b_inquiry VALUES ('19', '161123000002', '16112300000219', '1', '1', null);
INSERT INTO b_inquiry VALUES ('20', '161123000002', '16112300000220', '7', null, null);
INSERT INTO b_inquiry VALUES ('21', '161123000002', '16112300000221', '8', null, null);
INSERT INTO b_inquiry VALUES ('22', '161123000002', '16112300000222', '12', null, null);
INSERT INTO b_inquiry VALUES ('23', '161122000003', '16112200000323', '1', null, null);
INSERT INTO b_inquiry VALUES ('24', '161122000003', '16112200000324', '7', '', null);
INSERT INTO b_inquiry VALUES ('25', '161122000003', '16112200000325', '8', '580', null);
INSERT INTO b_inquiry VALUES ('26', '161122000003', '16112200000326', '12', null, null);
INSERT INTO b_inquiry VALUES ('27', '161122000003', '16112200000327', '13', null, null);
INSERT INTO b_inquiry VALUES ('28', '161123000004', '16112300000428', '8', '7200', null);
INSERT INTO b_inquiry VALUES ('29', '161123000003', '16112300000329', '7', '2500', null);
INSERT INTO b_inquiry VALUES ('30', '161123000005', '16112300000530', '1', '122', null);
INSERT INTO b_inquiry VALUES ('31', '161123000005', '16112300000531', '7', null, null);
INSERT INTO b_inquiry VALUES ('32', '161123000005', '16112300000532', '8', null, null);
INSERT INTO b_inquiry VALUES ('33', '161123000005', '16112300000533', '12', null, null);
INSERT INTO b_inquiry VALUES ('34', '161124000001', '16112400000101', '1', '5432', null);
INSERT INTO b_inquiry VALUES ('35', '161124000001', '16112400000102', '7', null, null);
INSERT

[Msg] Finished - Unsuccessfully

Answer 1

你的b_inquiry表有6个字段，你的values 里只有5个字段，所以报错了。
如果就是只想插入5个字段的值的话，可以使用：
insert into b_goods(id,order_id,inquiry_num,carrier_id,money) value('25', '测试2', '19', '吨', '1');
或者
insert into b_goods(id,order_id,inquiry_num,carrier_id,money)
select '25', '测试2', '19', '吨', '1';

参考自：MySQL insert用法详解 http://www.data.5helpyou.com/article421.html