inserting data from one mysql table into another mysql table
insert into destinationtablename select * from srctablename
71 thoughts on “inserting data from one mysql table into another mysql table”
Leave a Reply
You must be logged in to post a comment.
I have two table consist of same field names except one field as below:
table 1
id_student, studentname, studentnric, studentno, dateofbirth, address, phone, courses, session
table 2
id_graduate, studentname, studentnric, studentno, courses, session
What I am trying to accomplish is, to get the data in the first table into the second table
Ans;
INSERT INTO table2
SELECT id_student as id_graduate, studentname, studentnric, studentno, courses, session
FROM table1
The SQL SELECT INTO Statement
The SELECT INTO statement selects data from one table and inserts it into a new table.
SQL SELECT INTO Syntax
We can copy all columns into the new table:
SELECT *
INTO newtable [IN externaldb]
FROM table1;
Or we can copy only the columns we want into the new table:
SELECT column_name(s)
INTO newtable [IN externaldb]
FROM table1;
SELECT *
INTO CustomersBackup2013
FROM Customers;
Use the IN clause to copy the table into another database:
SELECT *
INTO CustomersBackup2013 IN ‘Backup.mdb’
FROM Customers;
Copy only a few columns into the new table:
SELECT CustomerName, ContactName
INTO CustomersBackup2013
FROM Customers;
Copy only the German customers into the new table:
SELECT *
INTO CustomersBackup2013
FROM Customers
WHERE Country=’Germany’;
Copy data from more than one table into the new table:
SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2013
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID;
I’m impressed, I must say. Seldom do I encounter a
blog that’s equally educative and amusing, and without a doubt, you’ve hit the nail on the head.
The problem is an issue that not enough people are speaking intelligently about.
Now i’m very happy I found this in my search for something concerning this.
Hello, this weekend is nice in favor of me, as this time i am reading
this enormous informative piece of writing here at my home.
It’s the best time to make some plans for the future and it is time
to be happy. I’ve read this post and if I could I desire to suggest you some interesting things or suggestions.
Perhaps you could write next articles referring to this article.
I want to read more things about it!
I am now not certain where you’re getting your info, but great topic.
I must spend a while studying more or figuring out more.
Thank you for fantastic info I was searching for this info for my mission.
Excellent way of describing, and pleasant piece of writing to get information concerning my presentation subject, which i am
going to convey in school.
Thanks for the good writeup. It in truth was once
a leisure account it. Look complex to more introduced agreeable from you!
By the way, how could we keep up a correspondence?
Thanks for a marvelous posting! I quite enjoyed reading it, you will be a great
author.I will remember to bookmark your blog and may come back very soon. I want to encourage you to ultimately continue
your great job, have a nice weekend!
I know this web page offers quality depending content and other stuff, is there any
other site which offers these kinds of stuff in quality?
I am genuinely glad to read this blog posts which includes tons of helpful data,
thanks for providing these information.
Hi, I do think this is an excellent website. I stumbledupon it 😉 I may come back yet again since I saved as a favorite it.
Money and freedom is the greatest way to change, may you be rich and continue to guide
others.
Remarkable things here. I am very satisfied to see
your post. Thank you so much and I’m having a look forward to contact you.
Will you kindly drop me a e-mail?
What a stuff of un-ambiguity and preserveness of valuable experience concerning unpredicted feelings.
Remarkable issues here. I’m very satisfied to look your article.
Thanks so much and I’m looking ahead to contact you.
Will you kindly drop me a e-mail?
Right here is the perfect blog for everyone who hopes to understand this topic.
You know so much its almost hard to argue with you (not that I
really would want to…HaHa). You definitely put a fresh spin on a subject
that has been discussed for years. Excellent stuff, just excellent!
Your method of telling the whole thing in this article is
actually fastidious, all be able to without difficulty
be aware of it, Thanks a lot.
hi!,I like your writing very a lot! percentage we keep in touch extra approximately your article on AOL?
I require a specialist on this space to resolve my problem.
Maybe that’s you! Looking ahead to look you.
It’s going to be finish of mine day, however before finish I am reading this
wonderful piece of writing to increase my know-how.
Appreciate this post. Will try it out.
Hi there, You’ve done a fantastic job. I will certainly digg it
and personally recommend to my friends. I am sure they will be benefited from this web site.
Howdy, i read your blog occasionally and i own a similar one and i
was just curious if you get a lot of spam comments?
If so how do you protect against it, any plugin or
anything you can recommend? I get so much lately it’s
driving me insane so any assistance is very much appreciated.
What’s up, the whole thing is going well here and ofcourse every one is sharing facts, that’s really
fine, keep up writing.
I just could not leave your website prior to suggesting that I actually
enjoyed the usual info an individual supply on your
guests? Is gonna be again frequently in order to check
out new posts
I like the valuable information you provide in your articles.
I’ll bookmark your blog and check again here frequently.
I’m quite sure I’ll learn plenty of new stuff right here!
Best of luck for the next!
I know this web site offers quality dependent articles or reviews and other data, is there any other site
which gives such stuff in quality?
I’m gone to say to my little brother, that he should also go to see this webpage on regular basis to take updated from latest
reports.
With havin so much written content do you ever run into any issues
of plagorism or copyright violation? My website has a
lot of exclusive content I’ve either created myself or outsourced but it appears a lot of it is popping it up all over the web without my
permission. Do you know any ways to help stop content from being stolen? I’d genuinely appreciate it.
Wonderful beat ! I would like to apprentice while
you amend your website, how could i subscribe
for a blog site? The account helped me a acceptable deal.
I had been a little bit acquainted of this your
broadcast provided bright clear concept
Hi, i read your blog occasionally and i own a similar one and i was just
curious if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you can recommend?
I get so much lately it’s driving me crazy so any support is very much appreciated.
Heya i’m for the first time here. I found this board and I find It truly useful
& it helped me out a lot. I hope to give something back and
help others like you aided me.
you’re really a just right webmaster. The
website loading speed is incredible. It kind of feels that you are doing any
distinctive trick. Moreover, The contents are masterwork. you have done
a wonderful job on this subject!
Its like you read my thoughts! You appear to understand a lot approximately this, such as you wrote the guide in it or something.
I feel that you simply can do with some p.c. to pressure
the message home a little bit, but instead of that, that is great blog.
A fantastic read. I’ll definitely be back.
Thanks for the marvelous posting! I seriously enjoyed reading it,
you could be a great author.I will always bookmark your blog and will eventually come back down the road.
I want to encourage you continue your great posts, have a nice morning!
For most recent news you have to visit world wide web and on internet I found this website as a
best web page for most recent updates.
Attractive component of content. I simply stumbled
upon your weblog and in accession capital to say that I get actually enjoyed account your
blog posts. Anyway I’ll be subscribing on your feeds and even I success
you get entry to consistently rapidly.
Hey I know this is off topic but I was wondering if you
knew of any widgets I could add to my blog that automatically
tweet my newest twitter updates. I’ve been looking
for a plug-in like this for quite some time and was hoping maybe you
would have some experience with something like this.
Please let me know if you run into anything.
I truly enjoy reading your blog and I look forward to your new updates.
Hello, I enjoy reading all of your article. I wanted to write a little comment to support you.
Hello! I know this is kind of off-topic but I had to ask.
Does building a well-established website like yours take a
lot of work? I am completely new to writing a blog
but I do write in my journal daily. I’d like to start a blog so I can share my experience and thoughts online.
Please let me know if you have any recommendations or tips for
brand new aspiring blog owners. Appreciate it!
Very shortly this site will be famous among all blogging viewers, due to it’s pleasant content
We’re a group of volunteers and opening a new scheme in our community.
Your site provided us with valuable information to work
on. You have done an impressive job and our whole community will be thankful to you.
Thanks for finally writing about > inserting data from one mysql table
into another mysql table | Eduguru – Good Blogging < Loved it!
Have you ever thought about adding a little bit more than just your articles?
I mean, what you say is important and everything.
However just imagine if you added some great visuals or video
clips to give your posts more, “pop”! Your content is excellent but
with pics and video clips, this site could undeniably be one of
the greatest in its field. Fantastic blog!
ทางเข้า sbobet
I don’t even know how I ended up here, but
I thoughyt this post was good. I don’t know who you are but definitely you are going to a famous blogger if yyou aren’t already 😉 Cheers!
You need to be a part of a contest for one of the most useful blogs on the web.
I will highly recommend this site!
I like the helpful information you provide in your articles.
I will bookmark your weblog and check again here frequently.
I’m quite sure I’ll learn many new stuff right here!
Best of luck for the next!
Hi there, just became aware of your blog through Google,
and found that it is truly informative. I am going to watch out for brussels.
I’ll appreciate if you continue this in future.
Lots of people will be benefited from your writing. Cheers!
This article will help the internet people for
creating new website or even a blog from start to
end.
I’m not sure where you’re getting your information, but great topic.
I needs to spend some time learning more or understanding
more. Thanks for excellent info I was looking for this info for my mission.
At this time it seems like WordPress is the best blogging platform available right now.
(from what I’ve read) Is that what you’re using on your blog?
I truly love your website.. Excellent colors & theme.
Did you create this web site yourself? Please reply back as
I’m attempting to create my own personal site and would like to find out where you got this from or what the
theme is named. Cheers!
Whats up are using WordPress for your blog platform?
I’m new to the blog world but I’m trying to get started and
create my own. Do you require any html coding expertise to make your own blog?
Any help would be greatly appreciated!
Hello There. I discovered your blog the usage of msn. That is an extremely well
written article. I’ll make sure to bookmark it and return to learn extra of your
useful information. Thanks for the post. I’ll definitely comeback.
My brother recommended I might like this blog.
He was totally right. This post actually made my day.
You can not imagine just how much time I had spent for this info!
Thanks!
Keep on working, great job!
Helpful information. Lucky me I discovered your site by accident, and I am stunned why this twist of fate did not took place earlier!
I bookmarked it.
That includes moving a patient from one facility to another, to give them a better chance of survival or
an increased level of treatment. Your sensual session starts at the minute the Leeds
escort girls arrive. Escort services in Toronto are one of the most spoken and hottest services.
If you have no idea where to begin, don’t try it on your own. but the person on the phone, who claims they are in the
U. It means you can study well OR you know a lot about computers.
Appearing with her on the show was the actor
mentioned above. Check out the website of the Birmingham escort agency.
For this, you need to ask your friends who have already availed
the service of the agency or you can also read
out the blog section of the site to get a better review.
I was recommended this website by my cousin. I am not sure whether this post is written bby him as nobody else know
such detailed about my problem. You’re amazing! Thanks!
It’s an remarkable post in favor of all the web users; they will take benefit from it I am sure.
I am glad that I found this website, I got exactly the right
information that I was trying to find!
I’m extremely impressed with your writing skills as well as with the layout on your weblog.
Is this a paid theme or did you modify it yourself?
Either way keep up the excellent quality writing, it’s rare to see
a great blog like this one nowadays.
Undeniably imagine that that you said. Your favourite justification seemed to be at the web the easiest thing to keep in mind of.
I say to you, I certainly get annoyed whilst folks consider worries that they plainly don’t know about.
You controlled to hit the nail upon the top and
also defined out the whole thing with no need side-effects , people can take a signal.
Will likely be back to get more. Thanks
Incredible! This blog looks exactly like my old one!
It’s on a totally different subject but it has pretty much the same page
layout and design. Superb choice of colors!
It’s all about understanding the direction of the industry, andd only the path.
It’s onnly a fantastic product or service particularly for men, who want too learn to fljrt or enrich it.
Magnetic Messaging, it must be stated, doesn’t have only oone miracle text which can persuade the lady nowadays; evn so the solutions inside of the
guide have already bbeen shown to wwork and in addition have achievd optimistic outcomes a lot
of males around the globe.
It can be only a excellent products especially forr males, who wish
tto find out to flirt or increasse it. Magnetuc Messaging, it ought to be stated, doesn’t have only one miracle text that will
convince the lady nowadays; nonetheless thee appraches inside of the book are actually proven to do
the job as well as have achieved optimistic benecits a lot off males across the globe.
Now, however, this super easy technique will produce the number for you in no time flat.
Right-click in the right-hand pane, choose New ->
DWORD Value. If you’d like your bot to fireplace
with a specific player automatically you’ll need
the battlefield 3 aimbot by which you can make use of the bots you have to help
you on the game.
Pingback: Google