Hi,
I think you have to query like this..
C:\MySQL5.1.7\bin>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.1.7-beta-community
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SELECT description FROM mysql.help_topic WHERE name="CONCAT";
+--------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
| description
+--------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
| Syntax:
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments. May
have one or more arguments. If all arguments are non-binary strings,
the result is a non-binary string. If the arguments include any binary
strings, the result is a binary string. A numeric argument is converted
to its equivalent binary string form; if you want to avoid that, you
can use an explicit type cast, as in this example:
SELECT CONCAT(CAST(int_col AS CHAR), char_col);
CONCAT() returns NULL if any argument is NULL.
|
+--------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
mysql>
mysql>SELECT description FROM mysql.help_topic WHERE name="JOIN";
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221