MySQL Common examples of statements

Login Database

Mysql-hlocalhost-uroot-p123456-u behind is the user name-P followed by the account password-H is followed by host

View the list of databases show databases;

Create DATABASE test;

Delete database drop DB test;

Use database using Test;

View data sheet show tables;

Creating a data Table CREATE TABLE test (ID INT not NULL);

Delete data table drop table test;

Inserting data insert INTO test (' id ', ' name ') VALUES (1, "XM");

Delete the data delete from test where id=1 and name= "BGG";

MySQL Common examples of statements