随笔分类 -  mysql

摘要:#!/bin/bash DUMP=/usr/bin/mysqldump OUT_DIR=/home/mysql LINUX_USER=root DB_NAME=snale DB_USER=root DB_PASS=password DB_HOST=127.0.0.1 DAYS=7 cd $OUT_DIR DATE=`date +%Y_%m_%d` OUT_SQL="$DA... 阅读全文
posted @ 2016-11-30 14:12 snale1989 阅读(640) 评论(0) 推荐(0)
摘要:or ALTER TABLE table_name DROP COLUMN column_name or SELECT column_nameFROM table_name AS table_alias or CREATE UNIQUE INDEX index_nameON table_name ( 阅读全文
posted @ 2016-10-25 14:23 snale1989 阅读(335) 评论(0) 推荐(0)
摘要:#vim /etc/yum.repos.d/mariadb.repo [mariadb]name = MariaDBbaseurl = https://yum.mariadb.org/10.1.16/centos7-amd64 //不同系统、版本更改此设置gpgkey=http://yum.mari 阅读全文
posted @ 2016-07-29 14:52 snale1989 阅读(438) 评论(0) 推荐(0)