gojohnnygogogogo
Programmer
hello,
I have one table with about 800,000 records in it, I need to export the data to files where the value in one field is equal to others.
eg.
select * from table1 where number = '1'
this creates file1
then
eg. select * from table1 where number = '2'
this creates file2
and so on.
instead of doing indivdual queries and exports can I somehow automate this ?
thanks for any help
I have one table with about 800,000 records in it, I need to export the data to files where the value in one field is equal to others.
eg.
select * from table1 where number = '1'
this creates file1
then
eg. select * from table1 where number = '2'
this creates file2
and so on.
instead of doing indivdual queries and exports can I somehow automate this ?
thanks for any help