Mysql相关

create database lixx;
create schema [数据库名称] default character set utf8 collate utf8_general_ci;--创建数据库

drop database lixx;

create user ‘[用户名称]‘@‘%‘ identified by ‘[用户密码]‘;--创建用户
密码8位以上，包括：大写字母、小写字母、数字、特殊字符
%：匹配所有主机，该地方还可以设置成‘localhost‘，代表只能本地访问，例如root账户默认‘localhost‘
grant select,insert,update,delete,create on [数据库名称].* to [用户名称];--用户授权数据库

use lixx;

CREATE TABLE IF NOT EXISTS `runoob_tbl`(
   `runoob_id` INT UNSIGNED AUTO_INCREMENT,
   `runoob_title` VARCHAR(100) NOT NULL,
   `runoob_author` VARCHAR(40) NOT NULL,
   `submission_date` DATE,
   PRIMARY KEY ( `runoob_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE table_name ;

INSERT INTO table_name ( field1, field2,...fieldN )
                        VALUES
                       ( value1, value2,...valueN );

SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]   --LIMIT返回数据条数  OFFSET偏移量设置

SELECT field1, field2,...fieldN FROM table_name1, table_name2...
[WHERE condition1 [AND [OR]] condition2....