show databases;
use user;
insert into user(id,name) values(3,'张三');
mysql -u root -proot
select * from user;
show create table user;
show create database ssh;
create databases ssh character set = utf8;
ALTER TABLE 表名 CHANGE 旧字段名 新字段名 新数据类型(size);
ALTER TABLE 表名 CHANGE area_id id int(11);
创建表
CREATE TABLE `product`(
`id` INT(11) AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`name` varchar(255) NOT NULL COMMENT '姓名',
`price` varchar(255) NOT NULL COMMENT '价格'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品表';
CREATE TABLE `mf_fd_cache` (
`id` bigint(18) NOT NULL AUTO_INCREMENT,
`dep` varchar(3) NOT NULL DEFAULT '',
`arr` varchar(3) NOT NULL DEFAULT '',
`flightNo` varchar(10) NOT NULL DEFAULT '',
`flightDate` date NOT NULL DEFAULT '1000-10-10',
`flightTime` varchar(20) NOT NULL DEFAULT '',
`isCodeShare` tinyint(1) NOT NULL DEFAULT '0',
`tax` int(11) NOT NULL DEFAULT '0',
`yq` int(11) NOT NULL DEFAULT '0',
`cabin` char(2) NOT NULL DEFAULT '',
`ibe_price` int(11) NOT NULL DEFAULT '0',
`ctrip_price` int(11) NOT NULL DEFAULT '0',
`official_price` int(11) NOT NULL DEFAULT '0',
`uptime` datetime NOT NULL DEFAULT '1000-10-10 10:10:10',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`dep`,`arr`,`flightNo`,`flightDate`,`cabin`),
KEY `uptime` (`uptime`),
KEY `flight` (`dep`,`arr`),
KEY `flightDate` (`flightDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;