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
ame or address> samp_db -u -p
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]
---
nitely need to be able 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 posti
e time and message 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 Lt