AW: [PHP-DB] Subquery trouble :)
| From: | Andreas Cahen | Date: | Tue, 13 May 2003 21:40:24 +0000 |
| Subject: | AW: [PHP-DB] Subquery trouble :) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27726@lists.php.net to get a copy of this message | ||
Hi Maxim!
> 3 questions:
> 1. what DB is it for? Looks like Oralce to me :)
> 2. What sense can it make updating town_id to 910 on any row that
already contains it? 3. what is this 'Domain'? That could actually be
your syntax error.
So far... 2 questions :)
1. I use mySQL, such subqueries were working the days I used to work
with Oracle, but those days are gone now :)
2. Let me explain you the structure..
I got 3 tables involved...
CREATE TABLE
details_domains_a (
ID int(10) NOT NULL auto_increment,
Domain varchar(255) NOT NULL default '',
.
.
Lotsa fields :)
.
.
town_ID int(11) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM AUTO_INCREMENT=370 ;
CREATE TABLE domains_a (
domain varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
check int(11) NOT NULL default '0',
check_date date NOT NULL default '0000-00-00',
town_ID int(11) NOT NULL default '0',
KEY domain (domain),
KEY name (name)
) TYPE=MyISAM;
CREATE TABLE towns (
town_ID int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
check int(11) NOT NULL default '0',
check_date date NOT NULL default '0000-00-00',
PRIMARY KEY (town_ID)
) TYPE=MyISAM AUTO_INCREMENT=4171 ;
And I need to do following:
UPDATE details_domains_a SET town_id = 910 WHERE Domain IN (
SELECT domain
FROM domains_a
WHERE town_id = 910
)
Maybe it's just a typo... :(
Cheers,
Andreas Cahen