mysql中where错误_MySQL错误：'where子句'中的未知列(MySQL error: Unknown column in 'where clause')...

backticks (`) are used for identifiers, like table names, column names, etc. Single quotes(') are used for string literals.

You want to do:

SELECT b.balance FROM bank AS b WHERE b.nick='Alex' LIMIT 1

Or, to be more explicit:

SELECT `b`.`balance` FROM `bank` AS b WHERE `b`.`nick`='Alex' LIMIT 1

When there is no chance of ambiguity, and when table/column names do not have special characters or spaces, then you can leave the ` off.

Here is some documentation that is dry and hard to read: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html