.ben, Monday, May 20, 2002, 3:15:11 PM, you wrote: b> hi. i'm new to the list and have only been playing with mySQL for a few b> weeks now, i have a question regrading the syntax of an UPDATE statement - i b> hope nobody minds me asking.
b> i want to uopdate a table with the data from another, i've written the b> following: b> update trackinfo SET trackinfo.postcode = newtrackinfo.postcode FROM b> trackinfo, newtrackinfo WHERE trackinfo.telephone = newtrackinfo.telephone; b> it should update trackinfo with the postcodes from newtrackinfo, as long as b> the telephone numbers match - but i get an errror - it complains about the b> 'FROM...' onwards. b> am i missign something simple? Yeah. Description of UPDATE syntax you can find in our manual: http://www.mysql.com/doc/U/P/UPDATE.html However, MySQL doesn't support mutli-table updates yet. b> cheers, b> .ben -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php