UC知道MYSql的问题，请问有错吗？多参数的存储过程怎么写？
来源：百度知道 编辑：UC知道 时间：2024/06/07 10:47:15
create procdure add_book
(
IN BookName VARCHAR(50),
IN Author VARCHAR(20),
IN Price DECIMAL(8,2),
IN PublishTime DATETIME,
IN BookCategory INT,
IN LatestAmendTime TIMESTAMP,
IN InStoreTime TIMESTAMP
)
insert into book(BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
values (BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
;
(
IN BookName VARCHAR(50),
IN Author VARCHAR(20),
IN Price DECIMAL(8,2),
IN PublishTime DATETIME,
IN BookCategory INT,
IN LatestAmendTime TIMESTAMP,
IN InStoreTime TIMESTAMP
)
insert into book(BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
values (BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
;
DROP PROCEDURE IF EXISTS `add_book
CREATE PROCEDURE add_book
(
IN BookName VARCHAR(50),
IN Author VARCHAR(20),
IN Price DECIMAL(8,2),
IN PublishTime DATETIME,
IN BookCategory INT,
IN LatestAmendTime TIMESTAMP,
IN InStoreTime TIMESTAMP
)
BEGIN
insert into book(BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
values (BookName,Author,Price,PublishTime,BookCategory,LatestAmendTime,InStoreTime)
;
END