MySQL Stored Procedure CREATE Error?

You can do IF ROW_COUNT() = 0 THEN rather than IF SELECT ROW_COUNT() = 0 THEN No need for the SELECT.

You can do IF ROW_COUNT() = 0 THEN rather than IF SELECT ROW_COUNT() = 0 THEN. No need for the SELECT.

I suspect that your delimiter is not being set properly. I usually include the delimiter set/unset statements with my SQL source, that way "it just runs" - it's good practice that every SQL file can run stand-alone eg: delimiter ~ create procedure ... end;~ delimiter ; Try changing your delimiter to something less deadly than a pipe char - try my tilda ~ char, which never gives me any trouble. I've seen $$ used often as well.

Edited original post as code gets all messed up when I post it here, but adding the delimiter into the SQL statment made it freeze. – Matt Jun 15 at 3:36 How are you submitting this to mysql? Maybe that pipe is getting in the way - is the command line parsing as an actual pipe?

Try pasting the contents of your file directly in the mysql command line client. – Bohemian Jun 15 at 3:42 I am using php myadmin, I will try a different delim, but I don't think that would be an issue. Changed Delim, still same issue as my last edit.

Hmmm – Matt Jun 15 at 4:10.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.