I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to
table with values from another table in the following manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative way to do this in 4.0.11?
chas
host name or address samp_db -u your user name -p your password
Please also note that samp_db must be exist on your remote machine. Of
course, you should sub. samp_db with your to be achieve database name.
Regards,
--
Charles Lewis
Reliable Computer Services
[EMAIL PROTECTED
to develop/customize applications rapidly.
And finally, I need the finished product (and preferably the development
environment) to be GUI.
Any suggestions?
Charles Lewis
[EMAIL PROTECTED]
-
Before posting, please check:
http
separator
is a : But the time field is also split up with : where as I don't
want to split up the time field.
Does anybody have any suggestions on how I can overcome this problem?
Charles Lewis
HAS Configuration Specialist
Oxford Technology Solutions Ltd.
The Technology Centre
213, Barns Road