If you start mysqld with the --ansi option, the following behavior of MySQL changes: || is string concatenation instead of OR. You can have any number of spaces between a function name and the `('.

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep reissuing the entire query but can refer to the stored ...