Re: Why doesn't thisw work - syntax error

[Per-Erik Martin]

In the SQL-99/2003 standard (and mysql) syntax this would be:

CREATE PROCEDURE `leswana`.`accounts` (IN clientnumber INT)
BEGIN

select * from clientdetails cd where cd.clientnumber=clientnumber;

END

Note that @ is not used for parameters and variables (@ denotes a 'global' user variable in mysql), and the semicolon at the end of the statement.
(In this case 'cd.clientnumber' is used to tell it apart from the variable - an alternative is to use a different variable name to avoid confusion.)

pem, Senior Software Dev., MySQL AB