Will this actually work? Because I can't select from the table into which
I'm inserting.
Also I don't want to insert. I want to update a bunch of records that
already exist.
Here is exactly what I want to do.
I have two tables set up that I'm dealing with right now. One is the main
information table, and one is a table that I set up from a filemaker export.
These are tables with information about a bunch of centers our company has,
and the information I'm dealing with will be the sponsors field and the zip
code.
Basically I want to find a record in the export table, and then take the
sponsors info from that row and insert it into the sponsors slot in the
other row in the other table that correspond to the same zip code.
The code I would use is logically like this. But it seems I can't get the
SQL right. I do this, and it tells me it can't find my table.
Update tblOrganizations set OrgSponsors = tblCenters.CenterSponsors where
OrgZip like tblCenters. CenterZip;
Any help would really be great. Thanks.
-eric
On 9/10/2001 2:51 PM, Sheridan Saint-Michel [EMAIL PROTECTED] wrote:
I think what you are looking for is the Insert...Select statement
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: Eric Spletzer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 4:38 PM
Subject: Copying data from one table to another.
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and
thanks
for the help in advance.
I have two table and I want to copy info from one table to another. I can
pull the correct information out with a select statement that looks
something like this
Select x1 from tbl1, tbl2 where y1 = y2
(numbers correspond to different tables)
This returns a table of the info I want to use. Logically, what I would
like to do is:
Update tbl1 set x1 = x2 where y1 = y2;
But this won't work because x1 and x2 are from different tables, as are y1
and y2. However, I've tried including tbl2 in the update parts, and that
doesn't work either. I'm at a loss.
Thanks for any help.
-eric spletzer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php