1.创建删除数据库:
create database <库名>;
drop database <库名>;
2. 查看当前数据库、字符集及其效验值:
select database();
show variables like '%character%'; #字符集相关的系统变量值
show variables like 'collation%'; #校对相关的值,校对是字符集的一个属性,定义了字符之间的比较规则
3.创建、插入和查询语句:
mysql> create table test1 (
id int auto_increment primary key,
name varchar(255)
);mysql> insert into test1 (name)
-> values('jjjj');select name from test1;
4.用所有数据类型创建表:
TEXT:
CREATE TABLE text (
name CHAR(255),
nick_name VARCHAR(255),
sothat TINYTEXT,
article TEXT,
dist BLOB,
big MEDIUMTEXT,
amazing MEDIUMBLOB,
what LONGTEXT,
ok LONGBLOB,
sex ENUM('man','woman')
);NUMBER:
CREATE TABLE number_table (
age TINYINT,
height SMALLINT,
weight MEDIUMINT,
salary INT,
savings BIGINT,
price DECIMAL(10,2),
temperature FLOAT(8,2),
distance DOUBLE(15,2),
is_no BOOLEAN
);DATA:
CREATE TABLE date_table (
date DATE,
time TIME,
year YEAR,
datetime DATETIME,
timestamp TIMESTAMP
);