mysql - 存储过程错误

Question

我正在创建存储过程但出现错误。

我的存储过程:

Create Procedure Join()
BEGIN
SELECT Orders.orderId, Customers.customerName, Orders.orderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerId=Customers.CustomerId;
END

错误如下:

错误

SQL query: Documentation

Create Procedure Join() BEGIN SELECT Orders.orderId, Customers.customerName, Orders.orderDate FROM Orders INNER JOIN Customers ON Orders.CustomerId=Customers.CustomerId; END MySQL said: Documentation

1064 - Erreur de syntaxe près de 'Join() BEGIN SELECT Orders.orderId, Customers.customerName, Orders.orderDate ' à la ligne 1

Answer 1

创建过程用户()开始选择 Orders.orderId, Customers.customerName, Orders.orderDate来自订单INNER JOIN 客户ON Orders.CustomerId=Customers.CustomerId;结束