Mysql Common commands

I. Common commands
Create database name
Select Database: use databasename
Directly Delete the database. Don't remind me: drop database name
Display table: show tables
Table Description: describe tablename
Remove duplicate fields: Add distinct to select
Before deleting a database, the following message is displayed: mysqladmin drop database name
Displays the current mysql version and date: select version (), current_date;
2. Modify the password in mysql:
Shell> mysql-u root-p
Mysql> update user set password = password ("abc123456") where user = 'root ';
Mysql> flush privileges // refresh the database
Mysql> use dbname; open the database
Mysql> show databases; displays all databases
 
 
Author: "The path to learning networks"