MySQL simple command line operation and configuration of environment variables

1. Configure Environment variables

-Locate the MySQL Bin directory and configure it to the environment variable under path.

2. Simple command-line operation

-1. Login: Mysql-hlocalhost (-H followed by database IP address)-uroot (-u followed by user name)-p (password)

-2. Exit: Exit

-3. Database operation:

-1. Build Library: Create Database mydb;

-2. Delete Library: drop database mydb;

-3. Show all databases: show databases;

-4. Select the library (select the database to use): using MyDB;

-4. Table Operation:

-1. View all tables: show tables;

-2. View table structure: Describe table_name (select a table);

MySQL simple command line operation and configuration of environment variables