#删除已有存储过程

DROP PROCEDURE if exists insertdata;

#设定命令行出现//后再执行语句

delimiter //

#创建存储过程

CREATE PROCEDURE insertdata()

#设定开始事务

begin

#申明变量

declare yourid int;

set yourid = ;

#循环执行

while yourid <  do

  insert into t_car(VIN, LicensePlate, TerminalCode, DomainCode, CarGroupId, AddTime, UpdateTime, CarType, CarModelCode, CustomerCode, CarColor, CarImg, motorNum, Remark)

  values(yourid, '浙A00002', yourid, 'BYD', , '2017-03-14', '2017-03-14', , , '', '', '', '', '');

  set yourid=yourid+;

end while;

end//

#重新设置分隔符为';'

delimiter ;

#执行存储过程

call insertdata();