MySQL Get started command

Connect to MySQL

Mysql-hlocalhost-uroot-p

View Current Database

SHOW DATABASES;

Create a database Shop

CREATE DATABASE Shop

Delete a database shop

DROP DATABASE Shop

Select (open) Database shop

Use Shop

View all tables in the current operations database

SHOW TABLES

View the structure of a table (example: User table)

DESC user;

Create a user table

CREATE TABLE User (id INT UNSIGNED auto_increment PRIMARY key,username char () not Null,password char (+) not Null,unique KEY username (username)) ENGINE = INNODB DEFAULT CHARSET =utf8;

Delete a table

DROP TABLE User;

Insert a piece of data into the table

INSERT into User (Id,username,password) VALUES (null, ' Wangzherongyao ', 20);

Update One piece of data

UPDATE User Set Password = ' mima123456 ' where username= ' Wangzherongyao ';

Delete a piece of data

DELETE from user where id=1;

Query statements

SELECT * from user where id=1;

This article from "ybt-php" blog, declined reprint!

MySQL Get started command