Lucas

alter table 表名 modify column 字段名 类型;例如数据库中user表 name字段是varchar(30)可以用alter table user modify column name varchar(50) ;

配置mysql出错是因为方法更新了#安装rpm包一. 下载mysql wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm安装rpm包 rpm -ivh mysql-community-release-el7-5.noarch.rpm安装mysql yum install mysql-

MySQL慢查日志的开启方式和存储格式show variables like 'slow_query_log';+----------------+-------+| Variable_name | Value |+----------------+-------+| slow_query_log | ON |+----------------+-------+ set gl...