Hallo, am Sonntag, 31. Juli 2005 um 09:17 schrieben Sie:
>> 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' SK> OK, so the error is at column 21 - which should be near the = which is SK> wrong! SK> The query should be: SK> SELECT customer_zip zip FROM customer WHERE zip > '90000' SK> (which means that the column customer-zip is renamed to zip in the result) SELECT customer_zip zip FROM customer WHERE zip > '90000' ---- Error ------------------------------- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Column not found;-4005 POS(8) Unknown column name:CUSTOMER_ZIP SELECT customer_zip zip FROM customer WHERE zip > '90000' -- Mit freundlichen Grüßen Daniel Krämer -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
