Lifelesspeople.com
Home Hosting News Forum Links Status Support About

 Forum FAQsForum FAQs  Knowledge BaseKnowledge Base  RulesRules   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   HostingHosting   RegisterRegister 
 DonateDonate   WikiWiki   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

MySQL Query

 
Lifelesspeople.com Forum Index -> Web Architects' Abode
Post new topic   Reply to topic View previous topic :: View next topic  
Author Message
rajasekar
Forum Regular


Joined: 30 May 2004
Posts: 445
Location: Nothing but Net
PostPosted: Sun Dec 02, 2007 7:43 pm    Post subject: MySQL Query Reply with quote
Hello, I want to insert some or all of the data form one database table to another through mysql query. Please provide me any samples. Thank you.
_________________
Free Online Classifieds - Reach thousands of users world-wide!
[img:0a37bba199]http://www.freelineads.com/banners/banner01.gif[/img:0a37bba199]
Back to top
 
nooc
Master Poster


Joined: 10 Aug 2005
Posts: 215
PostPosted: Wed Dec 05, 2007 8:03 pm    Post subject: Reply with quote
Insert data into xy_dst from a select operation on xy_src:

Code:

INSERT INTO xy_dst  (pos_x, pos_y)
   SELECT s.new_x, s.new_y
      FROM xy_src s
      WHERE ...
Back to top
 
Display posts from previous:   
Post new topic   Reply to topic    Lifelesspeople.com Forum Index -> Web Architects' Abode All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


[ Home | Hosting | News | Forum | Links | System Status | About | Archive | Donate ]
Powered by phpBB © 2001, 2002 phpBB Group
All trademarks and copyrights on this page are owned by their respective owners. Posts and comments are owned by the poster. Everything else © 2001 - 2007 Lifelesspeople.com