MySQL installation and configuration and login and exit

MySQL installation and configuration and login and exit

Introduction to the installation directory

Start/stop MySQL service

net start MySQL

net stop MySQL

Log in/out of MySQL

Modify the MySQL command prompt

MySQL Common commands:

SELECT VERSION (); Show current Version

SELECT now (); Show current date Time

SELECT USER (); Show Current User

specification for MySQL statements

Keyword and function name all uppercase

SQL statement must end with a delimiter

SQL The statement supports wrap operations, so that you can continue writing on the next line as long as you don't split the word, tag, or quote string into two parts

try not to use the database name, table name, field name, etc. MySQL the reserved words, if needed, use the anti-quote (``) enclose the name.

Database name, table name, field name, and so on all lowercase

MySQL installation and configuration and login and exit