Re: LOAD DATA INFILE / Stored Procedures

[pearsojd]

Hi Niti,

I am not sure what you are trying to achieve combining update statements with 'load data infile'(LDF). LDF cannot read SQL statements, only plain data. If your file contains 'update' statments then use either;

1. Command line
shell>mysql [options] < update_file.sql

2.Source Command
mysql> source /path to/update_file.sql;

Stored procedures are avalaible in version 5 (see
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html)

James