Collections:
Getting Help Information from the Server in MySQL
How To Get Help Information from the Server in 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 ...] ...
⇒ Running "mysql" Commands from a Batch File in MySQL
⇐ Non-Standard SQL Commands in MySQL
2018-02-08, 1489🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...