mysql 建表

--------------------  mysql --------------------
show global variables like 'port';
use database_name;
show databases;
show tables;

mysql -u root -p

set password for root@localhost = password('123');

 创建数据库

　　1、 CREATE DATABASE 数据库名;

　　2、 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON 数据库名.* TO 数据库名@localhost IDENTIFIED BY '密码';

　　3、 SET PASSWORD FOR　'数据库名'@'localhost' = OLD_PASSWORD('密码');

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON ABC.* TO  ABC@localhost IDENTIFIED BY 'admin';

CREATE TABLE 表名 (字段名 VARCHAR(20), 字段名 CHAR(1));

====
CREATE TABLE company(id int(10) NOT NULL,name varchar(20) NOT NULL,age int(10) NOT NULL,address varchar(50),salary float(15.2),PRIMARY KEY (id));

--------------------  mysql --------------------