MySQL query to Backup table records by creating a new table
Posted by admin
Here is a MySQL query to Backup a table records by creating a new table in the database and insert the specific Updated or Deleted records.
SELECT * INTO `database_name`.`name_of_backup_table`
FROM `database_name`.`table_to_backup`
WHERE
`table_to_backup`.`id`
IN ('1','2','3','4','5','6');
UPDATE or DELETE Query here...
Back to List | Comments (0) | October 03, 2009 at 03:24 pm
Leave a Reply
Latest News (2)
iWebProvider.com No 1 at Yahoo search engine for the keyword -filipino web developer.
Posted on October 02, 2009
On Sept 6, 2009 iWebProvider.com is No. 1 at Yahoo and Google for keyword "filipino web developer".
continue reading
Launching of the updated iWebProvider.com
Posted on October 02, 2009
Now as of July 7, 2009 the launching of iWebProvider.com with its improve feature and the used of its very own CMS. It now has features like Blogs, comments on News articles and the upcoming user registration.
continue reading
Wise Words
"It's not about how many you have learned but how much you have utilized and mastered what you have learned."
- by: Mark Lester
0 Responses
No Records Yet.