|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 Feng||19 Mar|
|• Re: How to rielize such func.?||Christian Mack||19 Mar|