在“Into”后加表名:Insert Into tbTable (Inc,........... 去掉“Line”一词。Insert Into YourTableName(Inc,Start,End,Pass,Unit,Space,Number,Run_Type,End_Unit,Anthorize,Class,Category,Brand,Traffic,CoachModel,CoachType,Grade,Seat,Ago_Anthorize,Kind,Province,Highspeed,Tour,Tender,Re) Line Value('湖北公路客运集团有限公司 ','长沙','常德','43534','宏基岁安','555','5','单开','','鄂A-44442','乙','五','鄂A-5552','A0K55552','奔驰','小','高一','5','44444442','跨市','蜀',1,0,1,'5')
Sorry,刚才按错了。上面的应该去掉“Line”: Insert Into YourTableName(Inc,Start,End,Pass,Unit,Space,Number,Run_Type,End_Unit,Anthorize,Class,Category,Brand,Traffic,CoachModel,CoachType,Grade,Seat,Ago_Anthorize,Kind,Province,Highspeed,Tour,Tender,Re) Value('湖北公路客运集团有限公司 ','长沙','常德','43534','宏基岁安','555','5','单开','','鄂A-44442','乙','五','鄂A-5552','A0K55552','奔驰','小','高一','5','44444442','跨市','蜀',1,0,1,'5')
LINE是tablename 没有超过字段长度
Insert Into Line (Inc,Start,End,Pass,Unit,Space,Number,Run_Type,End_Unit,Anthorize,Class,Category,Brand,Traffic,CoachModel,CoachType,Grade,Seat,Ago_Anthorize,Kind,Province,Highspeed,Tour,Tender,Re) Values ('湖北公路客运集团有限公司 ','长沙','常德','43534','宏基岁安','555','5','单开','','鄂A-44442','乙','五','鄂A-5552','A0K55552','奔驰','小','高一','5','44444442','跨市','蜀',1,0,1,'5')
the insert sql statement should be like thisinsert into tablename (column1, column2,...) values (value1,value2,...)you wroteinsert into (column1,column2,...) tableName value (value1,value2,..)
去掉“Line”一词。Insert Into YourTableName(Inc,Start,End,Pass,Unit,Space,Number,Run_Type,End_Unit,Anthorize,Class,Category,Brand,Traffic,CoachModel,CoachType,Grade,Seat,Ago_Anthorize,Kind,Province,Highspeed,Tour,Tender,Re) Line Value('湖北公路客运集团有限公司 ','长沙','常德','43534','宏基岁安','555','5','单开','','鄂A-44442','乙','五','鄂A-5552','A0K55552','奔驰','小','高一','5','44444442','跨市','蜀',1,0,1,'5')
Insert Into YourTableName(Inc,Start,End,Pass,Unit,Space,Number,Run_Type,End_Unit,Anthorize,Class,Category,Brand,Traffic,CoachModel,CoachType,Grade,Seat,Ago_Anthorize,Kind,Province,Highspeed,Tour,Tender,Re) Value('湖北公路客运集团有限公司 ','长沙','常德','43534','宏基岁安','555','5','单开','','鄂A-44442','乙','五','鄂A-5552','A0K55552','奔驰','小','高一','5','44444442','跨市','蜀',1,0,1,'5')
没有超过字段长度