Re: Need help with a Basic Query.

2006-03-09 Thread Peter Brawley 

clint lenard wrote:

Hey Guys,

  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.
  

http://dev.mysql.com/doc/refman/5.1/en/insert-select.html

PB


  



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 3/6/2006


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help with a Basic Query.

2006-03-08 Thread clint lenard 
Hey Guys,

  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.

Thanks!

- Clint

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Need help with a Basic Query.

2006-03-08 Thread Nicolas Verhaeghe 
That SQL 101.

It's a basic INSERT / SELECT.

http://dev.mysql.com/doc/refman/4.1/en/insert-select.html

Scroll down for the examples.

-Original Message-
From: clint lenard [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 08, 2006 8:54 PM
To: mysql@lists.mysql.com
Subject: Need help with a Basic Query.


Hey Guys,

  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.

Thanks!

- Clint

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help with a Basic Query.

2006-03-08 Thread mysql 

13.1.5.1. Silent Column Specification Changes

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
[table_options] [select_statement]
  ^^^

Regards 

Keith

In theory, theory and practice are the same;
In practice they are not. 

On Wed, 8 Mar 2006, clint lenard wrote:

 To: mysql@lists.mysql.com
 From: clint lenard [EMAIL PROTECTED]
 Subject: Need help with a Basic Query.
 
 Hey Guys,
 
   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.
 
 Thanks!
 
 - Clint
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]