Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 2 of 2
  1. #1
    Senior Member igeek's Avatar
    Join Date
    Oct 2005
    Posts
    202
    Member #
    11644
    I have some database issues i am trying to figure out..

    I have the following databases:

    accounts(database contains all accounts students, and employers)

    job_postings

    student_profiles

    I will create 2 a new DBs.... one from students and one for employers

    I need to pull all the student accounts from the accounts DB and put them into a new DB..that is just for students

    then I will have to pull all the data from the student_profiles DB and insert it into the new student accounts DB..where the Student_Profiles accountID matches

    I will also need to pull all the employers data in the accounts DB..and insert into a new DB..
    I can leave the job_postings DB the way that it is because each employer can have more than one job posting.. students on the other hand can have only one student profile..and all the data needs to be available to search on..

    The site is running PhPmyAdmin/MySQL.. is there a way to do this with mysql?

    thanks

  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    Look into the [minicode]INSERT INTO...SELECT[/minicode] syntax: http://dev.mysql.com/doc/refman/5.0/...rt-select.html
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:46 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com