darkcarnival Posted March 27, 2006 Share Posted March 27, 2006 hi,i plan to improve a part of my script and it will require spliting a table into 2.now my question is, what way would be easiest in moving data into another table?thanks :) Quote Link to comment https://forums.phpfreaks.com/topic/5951-going-from-table-to-table-in-mysql-question/ Share on other sites More sharing options...
obsidian Posted March 27, 2006 Share Posted March 27, 2006 [!--quoteo(post=358997:date=Mar 27 2006, 02:30 PM:name=darkcarnival)--][div class=\'quotetop\']QUOTE(darkcarnival @ Mar 27 2006, 02:30 PM) [snapback]358997[/snapback][/div][div class=\'quotemain\'][!--quotec--]hi,i plan to improve a part of my script and it will require spliting a table into 2.now my question is, what way would be easiest in moving data into another table?thanks :)[/quote]if at all possible, i'd recommend using the [a href=\"http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html\" target=\"_blank\"]SELECT INTO TABLE[/a] syntax Quote Link to comment https://forums.phpfreaks.com/topic/5951-going-from-table-to-table-in-mysql-question/#findComment-21304 Share on other sites More sharing options...
darkcarnival Posted March 28, 2006 Author Share Posted March 28, 2006 well i know of a way to do it but it will require alot of extra work and i was hoping there was a built-in function to better ease this.but I'll read up on this kind of query and give it shot, hopefully it'll be what I'm looking for. Quote Link to comment https://forums.phpfreaks.com/topic/5951-going-from-table-to-table-in-mysql-question/#findComment-21434 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.