To copy all records from table one into table two (except record 1) use this:
INSERT INTO table_two SELECT * FROM table_one WHERE id != '1'
Duplicate MySQL data from one table to another
– 12/09/2010Posted in: MySQL
Buy me a coffee
Spammers!
If you are going to put nonsense comments on my articles at least have the decency to click one of these adverts while you are here.
Even if you are a regular visitor you click a couple of ads while you are here - you might find something you want.
You May Also Like…
Cloud
accessibility block browser cache chrome chunk cms concrete5 CSS curl database date error file firefox form get href ie image input iphone javascript JQuery link magento MODx myqsl MySQL php post profile Revolution select Server session snippet spellcheck spelling table textarea tinymce w3c wordpress xmlInfo
Yes, the images are ambiguous;
Yes, they came from Google images;
No, I didn't get permission to use them*;
I know Magento called isn't Magneto;
And...
Why do spammers who hit this site do it with such a bizarre use of the English language?;
Was actually doing some browsing and came across this website. I must say that this information is on point! Keep writing more. I will be following your posts
What a post!! Very informative also easy to understand. Looking for more such comments!! Do you have a myspace?
I recommended it on digg. The only thing that it's missing is a bit of speed, the pictures are appearing slowly. Nevertheless thank you for this information.
Good post. I've been searching on this. Looking forward to your next post in this blog.
Cool. Your blog looks great, and I’m glad i’ve found something here worth adding to my favorites.
Hello!, I am visiting your site yet again to see more of your updates. I found this really interesting and felt compelled to comment a little thank you for all your effort. Please continue the great work your doing!
The well written summary assited me very much! Bookmarked your website, very excellent categories everywhere that I see here! I really appreciate the info, thanks.
I would like to stay in touch, What is your facebook page?
Great recommendation I recently stumble your blog and have been reading along. I thought I would leave my incipient comment. I don’t know what todivulgeexcept that I have enjoyed reading. Scrupulous blog. I will keep visiting this blog very unexceptionally. Your blog review here z3
I enjoy reading websites like these. It has been an great source of info. I could not locate sites like these. Thanks once more.