Results 1 to 2 of 2

Thread: Store other mysql table data into another table.

  1. #1
    Join Date
    Mar 2012
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Store other mysql table data into another table.

    HI,

    I have a "registration" new table with some fields like Guid, ClientGuid, RegistrationDate, DeregistartionDate, Status, Created and LastUpdate.

    I have another table with almost 5000 records and the table name is "Client" with so many fields including Guid, RegistrationDate, DeregistartionDate.

    Now i want to put Guid, RegistrationDate, DeregistartionDate data from client table and put this date in "registration" table.

    i wrote a queary like this but its not working.. it says #1062 - Duplicate entry '' for key 'PRIMARY'

    INSERT INTO `registration` (`ClientGuid`, `RegistrationDate`,`DeregistrationDate`)
    SELECT `Guid`, `RegistrationDate`, `DeregistrationDate` FROM `Client`;

    Thanks in advance..

    kiran

  2. #2
    Join Date
    Jul 2020
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Open SQL Server Management Studio.

    Right-click on the database name, at that point select "Assignments" > "Fare data..." from the item pioneer.

    The SQL Server Import/Export wizard opens; click on "Next".

    Give verification and select the source from which you need to duplicate the information; click "Next".

Similar Threads

  1. Replies: 7
    Last Post: 11-05-2012, 04:16 PM
  2. Replies: 5
    Last Post: 04-28-2010, 05:18 AM
  3. From an html form in https:// url save the credit card data in a mysql database table
    By leonidassavvides in forum MySQL and other databases
    Replies: 4
    Last Post: 05-26-2009, 02:15 AM
  4. Replies: 2
    Last Post: 11-30-2008, 07:32 PM
  5. Adding Data Into A MySQL Table
    By tomyknoker in forum PHP
    Replies: 2
    Last Post: 03-31-2007, 10:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •