Questions about SQL insert clause [message #597942] |
Wed, 09 October 2013 06:17 |
|
Totulas
Messages: 1 Registered: October 2013
|
Junior Member |
|
|
Hello, eneryone, I have encountered some problems in SQL, hope someone can help me.
I want to create a table with a bunch of prepared data. For ease of use, I choose to generate a SQL file which contains all
the sql clauses used to create the table and insert the data. So all the data can only be inserted to a table using sql clause.
My questions:
1) If data of a column is large (for example, 1 M text), how to insert it using SQL, is there a piecewise method.
2) And how can I insert BLOB data using SQL clause.
What I what is to enclose all the operations in a single SQL file, and when the table is needed, just execute this SQL file.
Can anyone give me some help, thanks.
[Updated on: Wed, 09 October 2013 06:27] Report message to a moderator
|
|
|
|
|