Linux下安装MySQLserver:apt-get install mysql-server
Linux下访问MySQL:mysql -uroot -p
修改表名:alter table 表名 rename to 新表名
建表:
CREATE TABLE `mapping_session` (
`mapping_session_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`old_db_name` varchar(80) NOT NULL DEFAULT '',
`new_db_name` varchar(80) NOT NULL DEFAULT '',
`old_release` varchar(5) NOT NULL DEFAULT '',
`new_release` varchar(5) NOT NULL DEFAULT '',
`old_assembly` varchar(20) NOT NULL DEFAULT '',
`new_assembly` varchar(20) NOT NULL DEFAULT '',
`created` datetime NOT NULL,
PRIMARY KEY (`mapping_session_id`)
) ENGINE=MyISAM AUTO_INCREMENT=392 DEFAULT CHARSET=latin1;
创建数据库:
CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
查看字符集:
show variables like '%char%';