mysql - 从存储过程中创建表时出错

Question

我创建了以下存储过程。但它给出了语法错误。我无法指出问题。

DELIMITER |
CREATE PROCEDURE createtables()
BEGIN
CREATE DATABASE test;
USE test;
CREATE TABLE employee(eid int PRIMARY KEY, ename varchar(45));
CREATE TABLE account(accid int PRIMARY KEY, amount float);
CREATE TABLE department(dip int PRIMARY KEY, depname varchar(45), eid int, FOREIGN KEY(dip) REFERENCES employee(eid));
END |
DELIMITER ;  

Answer 1

我认为您不能在存储过程中使用USE。因此，请尝试:

DELIMITER |
CREATE PROCEDURE createtables()
BEGIN
CREATE DATABASE test;
CREATE TABLE test.employee(eid int PRIMARY KEY, ename varchar(45));
CREATE TABLE test.account(accid int PRIMARY KEY, amount float);
CREATE TABLE test.department(dip int PRIMARY KEY, depname varchar(45), eid int, FOREIGN KEY(dip) REFERENCES test.employee(eid));
END |
DELIMITER ;