MySQL Forums
Forum List  »  CSV Storage Engine

i am not able to use BEGIN,END,DECLARE to create stored procedures
Posted by: sandeshas naik
Date: January 10, 2007 04:53AM

hi All..
i am trying to create a stored procedure using my sql 5.0 and client as 3.2,
stored procedures are creating if i didnt declare any variables and with out using BEGIN and END keyword, but if use any key words like BEGIN,END,DECLARE then it is giving error "you have an error in sql syntax,check manually near line 1".
what i have to do to add begin,end and declare keyword...
below code is excuting

create procedure
LOAD DATA
INFILE 'C:/temp/data.csv'
INTO TABLE student_info
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
;

but if i use the same code to create sp with begin and end key word its giving error

i am not able to use begin,end ,declare..
please help me any one to resolve this issue,

Options: ReplyQuote


Subject
Views
Written By
Posted
i am not able to use BEGIN,END,DECLARE to create stored procedures
11007
January 10, 2007 04:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.