Placeholders for LOAD DATA?

Hi!

Catching up with some old emails...

>>>>> "Tim" == Tim Bunce <Tim.Bunce@xxxxxxxxx> writes:

Tim> As an addition to
Tim>    LOAD DATA INFILE 'file_name.txt' INTO TABLE foo ...

Tim> could this be supported:

Tim>    LOAD DATA INSTRING '...string of data...' INTO TABLE foo ...

Tim> and thereby enable using a placeholder:

Tim>    LOAD DATA INSTRING ? INTO TABLE foo ...

Tim> This would enable placeholders to be used to do multi-row inserts
Tim> with a single round-trip to the server per-execute.

Intersting idea;  I have now put this on our long-time todo.

This is a bit similar to the idea of doing:

EXECUTE SELECT blob_column from table_name;

to execute the SQL statement code that we select from the table.

Regards,
Monty


-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=gcdmd-internals@xxxxxxxxxxx