Top "Mysql-error-1054" questions

How to use a temp column in the where clause

Why can't I use a temporary column in the where clause? For example, this query: Select product_brand, (CASE WHEN …

mysql sql mysql-error-1054

Zend DB - Count(*) not working

My sql statement is not working with Zend, its complaining about the Count(*) field... what am I doing wrong? // get …

php mysql zend-framework zend-db-table mysql-error-1054

MySQL error in Trigger "Unknown column in 'NEW'"

I'm having an inconsistent error with a "before insert trigger" in MySQL and cannot figure out the reason. I Have …

mysql sql triggers mysql-error-1054

Sum of calculated field

I have two tables: table1 (a,b,c) table2 (a,d,f) I want to get for each b to …

mysql sql aggregate-functions mysql-error-1054