-
Inserting Multiple Rows
As part of a project I have to write a java application that will read a text file and then send the values to a specified database.
I have a limited knowledge of SQL and don't know if I can do the following.
If my database has 3 columns and the text file appears like this
val1,val2,val3
val1,val2,val3
Can I write an SQL statement like this,
INSERT INTO Table VALUES('val1','val2','val3','val1','val2','val3')
Hence both rows are inserted at the same time?
Or do I have to write a loop to insert each row, individually?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|