Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login


Tycoon Talk > Web Development and Programming Support > PHP Forum > phpmyadmin

Freelance Jobs

Reply
phpmyadmin
Old 05-03-2005, 01:37 PM phpmyadmin
flid76's Avatar
Experienced Talker

Posts: 38
Location: Lancs, England
Trades: 0
Talkupation: flid76 is on a distinguished road
how do i transfer data from one my sql table to another? as i want to transfer my users over?
flid76 is offline
Reply With Quote
View Public Profile Visit flid76's homepage!
 
 
Register now for full access!
Old 05-03-2005, 02:07 PM
Anacrusis's Avatar
Defies a Status

Posts: 2,099
Name: Adam
Location: Colchester CT
Trades: 0
Talkupation: Anacrusis is a jewel in the roughAnacrusis is a jewel in the roughAnacrusis is a jewel in the rough
You can just use an sql statement like this
Code:
INSERT INTO table1 (column1, column2) 
VALUES
  (SELECT col1, col2
   FROM table2)
Anacrusis is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to phpmyadmin
 
Previous Thread | Next Thread Tycoon Talk > Web Development and Programming Support > PHP Forum > phpmyadmin

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.79458 seconds with 12 queries