| Author |
Take table backup without Select * into
|
Tushar Londhe
Greenhorn
Joined: Jul 08, 2008
Posts: 3
|
|
Hi Guys,
I want to take backup of a table.
But I dont want to use Select * into, so is there any other query
which I can fire in order to get table backup.
|
 |
Campbell Ritchie
Sheriff
Joined: Oct 13, 2005
Posts: 32689
|
|
|
Depending on your database program, you ought to have a dump utility. This example is for MySQL5.0.
|
|
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
I don't understand, SELECT is the only query that reads data from the database, so unless you want to make a backup out of thin air, you'll need to use the SELECT command in some fashion or another.
|
My Blog: Down Home Country Coding with Scott Selikoff
|
|
 |
|
|
subject: Take table backup without Select * into
|
|
|
0
