That SQL 101.
It's a basic INSERT / SELECT.
Scroll down for the examples.
From: clint lenard [mailto:clint.lenard@stripped]
Sent: Wednesday, March 08, 2006 8:54 PM
Subject: Need help with a Basic Query.
I was wondering if I could get some assistance with building a Simple
Import Script using PHP and MySQL. Basically I'm trying to pull info out
of one Table and Insert it into the other Table.
Can anyone show me a simple example of this? I can figure out how to do
the rest if I had a simple example.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql