MySQL Forums
Forum List  »  Stored Procedures

What is incorrect for this mySQL stored procedure?
Posted by: Jack Luk
Date: August 13, 2013 11:07PM

Create Procedure GenerateTransactionID()
BEGIN
SELECT CONCAT(ASCII(max(serials.SerialNo)), '-',
ASCII(customers.CustomerID), '-' ,ASCII(employee.EmployeeID),
'-', ASCII(orders.PurchaseDate), '-',
ASCII(orders.PurchaseTime))
from customers, employee, orders
where orders.EmployeeID = employee.EmployeeID
and orders.CustomerID = customers.CustomerID;

update serials set SerialNo = SerialNo+1
END



Thank you
Jack

Options: ReplyQuote


Subject
Views
Written By
Posted
What is incorrect for this mySQL stored procedure?
1651
August 13, 2013 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.