> SELECT customer_zip = zip FROM customer WHERE zip > '90000' > > Error: > > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > Syntax error or access violation;-5015 POS(21) Missing keyword:FROM > SELECT customer_zip = zip FROM customer WHERE zip > '90000'
OK, so the error is at column 21 - which should be near the = which is wrong! The query should be: SELECT customer_zip zip FROM customer WHERE zip > '90000' (which means that the column customer-zip is renamed to zip in the result)
signature.asc
Description: OpenPGP digital signature
