Run multiple commands at a time 4m notepad

[abhi_tec]

I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it
UPDATE sal SET sal= sal+3000
select * from ..................
insert into table tab_name values(........)
insert into table tab_name values(........)
insert into table tab_name values(........)
.........so on

Is there any SQL query like that if I ran it by provide the path ( D:\SQL.txt) of the notepad in the query itself it will execute one by one command from the notepad.
If it is not there in the SQL can I do it in Oracle DB or DB2.

[abhi_tec]

Guys any update on this??????????????

[Shanti C]

use this MySQL command

LOAD DATA INFILE 'path/to/text/file'

IGNORE INTO TABLE mytable;

[Shanti C]

see this link for reference:
http://www.mwasif.com/2007/5/download-data-csv-using-php/
http://dev.mysql.com/doc/refman/5.0/en/insert.html

[Shanti C]

sorry,,,
the above two are for inserting the data from notepad to mysql table...
please ignore them...

[Shanti C]

i think you just import your notepad file to your mysql database.....
check this:
http://www.clockwatchers.com/mysql_dump.html