MySQL Forums
Forum List  »  Docs

Re: Help tables in mysql
Posted by: Umesh Shastry
Date: April 13, 2006 02:34AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
5409
April 12, 2006 02:04AM
Re: Help tables in mysql
2270
April 13, 2006 02:34AM
2456
April 14, 2006 01:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.