Transferring Data from One Table to Another

This is to transfer data from one table to another within a single database

To transfer all data from one table to another within the same database:

"INSERT INTO TABLE2 SELECT * FROM TABLE1"

Dipesh Tuesday 20 August 2013 - 08:34 am | | Default
Used tags: , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« How to see the record… | Home | Changing the MySQL pa… »