How to concatenate two strings in SQL statement?

.. ...
Note that there are two variations of the equals and not equals operators. Equals can be either = or ==. The non-equals operator can be either != or <>. The || operator is "concatenate" - it joins together the two strings of its operands. The operator % outputs the remainder of its left operand modulo its right operand.
... ...

Unix ODBC

• UnixODBC.org
• PostgreSQL ODBC
• PostgreSQL ODBC - PgFoundry
  
• ODBC@MSDN

[keywords: unix odbc postgresql]

[MySQL] Can't connect to MySQL server on '192.168.3.100' (111)

$ mysql -ufoo -pbar -h192.168.3.100 mydb
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.3.100' (111)

默认情况下 mysql 只 listen 到 127.0.0.1 上, 修改 `/etc/mysql/my.cnf', 注释掉下面一行即可:

bind-address = 127.0.0.1