Re: stored procedure

[Rick James]

> After I create a stored procedure in notepad, oin which folder do I save it ?
You don't.
When you do CREATE STORED PROCEDURE ..., that puts the proc in a special place inside mysql, namely the "proc" table inside the "msyql" database (mysql.proc).

If you are having trouble with the CREATE statement, remember to use DELIMITER.

Better yet, do not use STORED PROCEDUREs, FUNCTIONs, TRIGGERs, EVENTs, etc, until you are fluent in the basic commands (CREATE TABLE, INSERT, SELECT, etc).