yolly

MySQL-5.6.22-1.el6.i686.rpm-bundle.tarMySQL-5.6.25-1.el6.x86_64.rpm-bundle.tar下载地址：https://pan.baidu.com/s/1pMBCuoV删除过程1.查看原有的mysqlrpm -qa | grep -i mysql2.移除mysql和其他依赖yum remove mysql-libs-5.1.71-1.e...

selectrule_no ,rule_name,COUNT(1) as RuleFireTimes ,sum(if( choose_result_type=0 ,1,0))as RuleHitTimesfrom rule_record where creat_time > '2017-02-15 03:19:32' and creat_time < '2018-03-20

方法一：show full columns from res_store_place;这种方法会将所有表的表字段信息列出来。方法二：select t.TABLE_SCHEMA as '表空间' ,t.TABLE_NAME as '表名' , t.COLUMN_KEY as '是否主键' ,t.COLUMN_NAME as '字段名称' , t.IS_NULLABLE as '是否...

select t.TABLE_SCHEMA as '表空间',t.TABLE_NAME as '表名',t.TABLE_ROWS as '行数',t.TABLE_COLLATION as '字符集',t.TABLE_COMMENT as '注释'from information_schema.tables t wheretable_schema in ('sinochem_order_go...

有时候当sql文件较大时，导入导出数据库会非常耗时，这是我们可以通过改变packet大小来加快速度，具体操作办法如下：1 找安装目录 进入mysql命令行输入：show variables like "%char%";2 打开MySQL安装目录下的my.ini文件：2.1输入%ProgramData%2.2找到C:\ProgramData\MySQL\MySQL Server ...