Jump to content


Photo

going from table to table in mysql question


  • Please log in to reply
2 replies to this topic

#1 darkcarnival

darkcarnival
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts

Posted 27 March 2006 - 07:30 PM

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 :)

#2 obsidian

obsidian
  • Staff Alumni
  • Advanced Member
  • 3,202 posts
  • LocationSeattle, WA

Posted 27 March 2006 - 07:36 PM

[!--quoteo(post=358997:date=Mar 27 2006, 02:30 PM:name=darkcarnival)--][div class=\'quotetop\']QUOTE(darkcarnival @ Mar 27 2006, 02:30 PM) View Post[/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
You can't win, you can't lose, you can't break even... you can't even get out of the game.

<?php
while (count($life->getQuestions()) > 0)
{   $life->study(); } ?>
  LINKS: PHP: Manual MySQL: Manual PostgreSQL: Manual (X)HTML: Validate It! CSS: A List Apart | IE bug fixes | Zen Garden | Validate It! JavaScript: Reference Cards RegEx: Everything RegEx

#3 darkcarnival

darkcarnival
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts

Posted 28 March 2006 - 03:23 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users