Mysql Series (Seventeen) Complete Collection of Mysql Instructions

Mysql Series (Seventeen) Complete Collection of Mysql Instructions

1, MySQL: (structured query language) A standard language used to access and process databases

2, What is SQL?

SQL refers to Structured Query Language

SQL enables us to access the database (a database is a warehouse that organizes, accesses and manages data according to the data structure)

SQL is An ANSI standard computer language

3, what can SQL do?

SQL can execute queries against the database

SQL can retrieve data from the database

SQL can insert new records in the database

SQL can update the database Data

SQL can delete records from the database

SQL can create a new database

SQL can create a new table in the database

SQL can create a new table in the database Create stored procedures

SQL can create views in the database

SQL can set permissions on tables, stored procedures and views

4, on the terminal Commonly used commands (desktop-based file management)

touch + file name.File type //Create a file

open + file name //Open the corresponding file or folder

                                                                                                                                                                                                                         Create directory (file)

cp + Parameter+ source file+ target file+ copy // mobile file

# RM+ parameter+ file // Delete file

CD ../ // Return to the previous class directory

ping                                                                                                     use   with                       ’ s ’ s ’ s ’ s ’ s ’ s ’ s ’ s ‐ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​    //Display operating system related information

who who List all currently logged in users

                                                                                                                                                                 w / /Display the current console

History                                                                                                                                                                             ’ ’ take’s to go ’s to ward off--                                                                                              # Please pay attention to the PHP Chinese website (www.php.cn) for content!