MySQL service installation and command usage

1. Installation

If installed, the online installation can

Install Mysql-server mysql-client

2. Start the server

sudo service MySQL start

3. Log in to MySQL (-U on behalf of user username, log in as root)

Mysql-u Root

4. Exit the MySQL Service

Quit

5. Query version

Select version ()

6. What the prompt means

1 . Wait for the semicolon; MySQL > Select User ()        -2. Wait for quotation marks 'mysql>select * from family where name ='  and<        '>3. Wait for double quotes "Mysql>select * from family WHERE name = "Smith and age <30        " > What should I do if I go to this step? 1. Complete the completion 2. Enter command \c to cancel command

MySQL service installation and command usage