Shulou(Shulou.com)05/31 Report--

This article mainly explains the "MySQL built-in help analysis", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "MySQL built-in help analysis" bar!

1. Log in to MySQL and ask for the built-in instructions of the system

Root@db02 scripts] # mysql-uroot-S / data/3306/mysql.sock Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 1Server version: 5.6.36 Source distributionCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >? Contents # # We didn't know how to use it, so we asked the system, what do you have? Here's what it feeds back to you: Account Management # # account management Administration # manage Compound Statements # # compound statement Data Definition # # data definition Data Manipulation # # data operation Data Types # # data type Functions # # function Functions and Modifiers for Use with GROUP BY # # functions and modifiers used with groups Geographic Features # # Geography Feature Help Metadata # # help metadata Language Structure # # language structure Plugins # # plug-in Procedures # # Program Storage Engines # # Storage engine Table Maintenance # # Table maintenance Transactions # # transaction User-Defined Functions # # user-defined function Utility # # Utility

2. According to the instructions given by it, we make the following inquiry.

1) for example: we want to create a new database, how to find the syntax?

Mysql >? Data Definition # looked at the instructions above, and it should be in how the data is defined, so? Question mark it; You asked for help about help category: "Data Definition" For more information, type 'help', where is one of the followingtopics: CREATE DATABASE CREATE EVENT CREATE FUNCTION CREATE INDEX CREATE LOGFILE GROUP CREATE PROCEDURE CREATE SERVER CREATE TABLE CREATE TABLESPACE CREATE TRIGGER. Several omission options

2) through the above, I found the CREATE DATABASE option, but I still can't build a database, so keep asking.

Mysql >? CREATE DATABASEName: 'CREATE DATABASE'Description:Syntax:CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name # find the syntax for creating a new database this time. You can create [create_specification] directly. # # you need to note that {} curly braces are optional and can be ignored. Other required options are create_specification: [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_nameCREATE DATABASE creates a database with the given name. To use thisstatement, you need the CREATE privilege for the database. CREATESCHEMA is a synonym for CREATE DATABASE.URL: http://dev.mysql.com/doc/refman/5.6/en/create-database.html

3) according to the syntax prompted by the system, create a new database of qiuyuetao

Mysql > create database qiuyuetao;Query OK, 1 row affected (0.05sec) mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | qiuyuetao | | test | +-+ 5 rows in set (0.07 sec)

3There are three types of SQL statements.

1) DDL: the language of data definition, but? Data Definition to inquire.

Create, alter, drop, manage basic data: for example, libraries, tables

2) DCL:Data control Language- data control language

Grant, revoke, commit,rollback, user authorization, rights recovery, data submission rollback

3) DML:Date Manipulation Language- data manipulation language

Select, update, delete, insert, do operations on tables and records thank you for your reading, these are the contents of "MySQL built-in help parsing". After the study of this article, I believe you have a deeper understanding of the problem of MySQL built-in help parsing, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.