71 thoughts on “inserting data from one mysql table into another mysql table”

  1. 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

  2. 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;

  3. 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;

  23. 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.

  29. 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.

  31. 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.

  34. 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.

  38. 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.

  40. 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!

  44. 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!

  58. 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.

  60. 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.

  64. 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.

  65. 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

  68. 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.

  69. 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.

  70. 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.

  71. Pingback: Google

Leave a Comment