MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Yao Feng Date:March 19 1999 4:14am
Subject:How to rielize such func.?
View as plain text  
  There exist 2 tables in one database:log,url_ip,the TABLE log have one 
column:url varchar(100), and the TABLE url_ip have columns :url 
varchar(100) ,ip varchar(15) refelecting the mapping of ip of url.

I want to replace the url in TABLE log with it's ip address using the 
second TABLE url_ip's values:

UPDATE log set url=url_ip.ip where log.url=url_ip.url;

but it failed. saying"fields url_ip.url not exist..."

How can I do with it? any substitute?

How to rielize such func.?Yao Feng19 Mar
  • Re: How to rielize such func.?Christian Mack19 Mar