Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Wamaniyma Akolwa
February 4, 2006, 4:04 pm
rate this thread
I am running MYSQL 5.0 ON WINXP pro.
I have the following procedure:
DROP PROCEDURE IF EXISTS LSMW_COST_SWITCH $$
CREATE PROCEDURE LSMW_COST_SWITCH()
SELECT * FROM C003_COSTING_LSMW ORDER BY NG_PART ASC limit 100;
SELECT * INTO OUTFILE 'E:/Work/Processed Files/test.txt' FIELDS TERMINATED
BY '|' LINES TERMINATED BY '\r\n' FROM C003_COSTING_LSMW ;
This fails returning the following error message:
"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 '$$ DELIMITER' at
If I remove the SELECT INTO... CLAUSE the procedure works just fine.
I have tried the SELECT * INTO OUTFILE 'E:............. as a simple query ,
and it works just fine.
Can someone pls help?
thanks and greets
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum