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, 1478🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...