Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get Help Information from the Server
How To Get Help Information from the Server? - MySQL FAQs - Command-Line End User Interface mysql
✍: FYIcenter.com
While you are at the "mysql>" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples:
>cd \mysql\bin >mysql -u root mysql> HELP; ... List of all MySQL commands: Note that all text commands must be end with ';' ? (\?) Synonym for `help'. clear (\c) Clear command. connect (\r) Reconnect to the server. ... mysql> HELP SHOW; Name: 'SHOW' Description: SHOW has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following: SHOW CREATE DATABASE db_name SHOW CREATE FUNCTION funcname SHOW CREATE PROCEDURE procname SHOW CREATE TABLE tbl_name SHOW DATABASES [LIKE 'pattern'] SHOW ENGINE engine_name {LOGS | STATUS } ... mysql> HELP CREATE TABLE; Name: 'CREATE TABLE' Description: Syntax: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_option ...] ...
2007-05-10, 4711👍, 0💬
Popular Posts:
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you ...
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose ...
What are the different storage classes in C? C has three types of storage: automatic, static and all...
How to convert a Unix timestamp to a Win32 FILETIME or SYSTEMTIME? The following function converts a...
Assuming that the structure of a table shows two columns like this: --------+------------+-- ----+---...