Hi everyone! The mySQL DB I have to rebuild was only one big table. Afer developing a new DB design for it, I ran into the problem of transfering the data from the old to the new database. I need to split up the records and insert them into the specific tables. My problem is that I can not figure out (as a total novice on mySQL) how to insert the data properly. Every time I try there's either a SQL error or the data is messed up and not ordered as it should be.
I tried to use the following statement: insert into priv_details (hobbies, experi, quali, marital [.....]) select me.hobbies, me.experi [..] from memberscopy me, priv_details pd where pd.id=me.id; What can i do? For help I would be really grateful!! Regards, Sven --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
