Help with mysql query..

hey guys, was hoping u could help me out...

ok i do know some sql, but im new to mysql... and theres this simple query that i just cant figure out whats wrong with it...

Quote:


CREATE PROCEDURE inserttoscrapbookSD
(owner1 VARCHAR(50),
poster1 VARCHAR(50),
Scrap1 VARCHAR(50),
Date_time1 DECIMAL,
InsertedOrNot DECIMAL
)
BEGIN

INSERT INTO scrapbook (Owner)

VALUES(owner1)

END



i know there are a lot of variables being passed, but just using one variable atm because if it works for one, itll work for all.. i tried with and without a semicolon (;) at the end of "END" but no luck.. it says

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 14

thanks in advance
3 answers Last reply
More about help mysql query
  1. hmm, i'm not that much into mysql, but i'd go with a missing semicolon at the end of the insert statement " ... VALUES(owner1) ;" and after the procedure definition "... END ;"
  2. mgwildi said:
    hmm, i'm not that much into mysql, but i'd go with a missing semicolon at the end of the insert statement " ... VALUES(owner1) ;" and after the procedure definition "... END ;"



    no luck, this is what i tried:

    Quote:


    CREATE PROCEDURE inserttoscrapbookSD
    (owner1 VARCHAR(50),
    poster1 VARCHAR(50),
    Scrap1 VARCHAR(50),
    Date_time1 DECIMAL,
    InsertedOrNot DECIMAL
    )
    BEGIN

    INSERT INTO scrapbook (Owner)

    VALUES(owner1);

    END ;

  3. hmmm okay...! could it be about the parameters directions?

    I just rapidly checked for mysql procedure syntax, I think you have to specify it for PROCEDURE (which doesn't seem to be the case when creating a FUNCTION)
Ask a new question

Read More

Programming MySQL SQL Apps