如何写一个mysql程序来插入数据？

Question

CREATE PROCEDURE dasd (

IN aSupplierID varchar(4),
IN aSupplierName varchar(100),
IN aSupplierAddress varchar(255),
IN aSupplierTelPhone varchar(10))

BEGIN

insert 
into 
supplier
(SupplierID,SupplierName,SupplierAddress,SupplierTelPhone)
values 
(aSupplierID,aSupplierName,aSupplierAddress,aSupplierTelPhone);

END

I find an error in the line 'values(aSupplierID,aSupplierName,aSupplierAddress,aSupplierTelPhone); END'.

Answer 1

Please can you try following one

CREATE PROCEDURE dasd (

IN aSupplierID varchar(4),
IN aSupplierName varchar(100),
IN aSupplierAddress varchar(255),
IN aSupplierTelPhone varchar(10))

BEGIN

insert 
into 
supplier
(SupplierID,SupplierName,SupplierAddress,SupplierTelPhone)
values 
(in_aSupplierID,in_aSupplierName,in_aSupplierAddress,in_aSupplierTelPhone);    
END