I have tried stored procedures, but met another problemo. > <
programming is like solving problem after problem...
I am using MySQL, and using MySQL administrator as a GUI. When trying
to create a stored procedure, like the one following, I often meet
error 1607, when I hit the 'Execute SQL' button.
[code]
CREATE procedure sp_search_part_no()
BEGIN
SELECT customer FROM table1;
END
[/code]
The error says" Error while executing query.
MySQL Query number 1607.
Cannot create stored routine 'sp_search_part_no'; Check Warnings.
But I don know where I can go to check warnings.
Does anyone know what's wrong? =/
