Introduction to commonly used MySQL commands in Linux environment

mysql -u+(user name) -p+(password)

The mysql statement command must be followed by a ";"

show databases;

use library name;

create database 【if not exists】【database name】;

show create database 【database name】;

show create table [table name];

desc [table name];

 select database();

create table 【if not exists】table name (attribute)

drop database [database name]

drop table [table name] 

For example:

create table student (int id (length) (extra attributes), name varchar (length));

The default length of the int type in the database is 11

 If varchar does not provide a length, an error will be reported

not null

auto_increment

primary key (attribute name) 

Attributes are separated by ","

charset 【Type】

engin