Vish,
> I can not isssue 'delimiter' command.
I assume that you are trying to create an output file with fields delimited by a specified character? The MySQL syntax is:
SELECT (columns) INTO OUTFILE '/path/to/filename'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM tables
WHERE conditions;
The FIELDS TERMINATED BY ',' option is where you would specify the delimiter.
See
http://dev.mysql.com/doc/mysql/en/SELECT.html for more details.
> Also,I can not compile procedure using 'SOURCE' command. It say 'You have
an error in SQL syntax.......'
Err, you have an error in your SQL statement then ;-)
can you post the statements in the procedure that you refer to?
--
Nick Roper