mysar

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	
	<groupId>com.boot</groupId>
	<artifactId>spring-boot-study</artifactId>
	<version>1.0.0-SNAPSHOT</version>
	<packaging>jar</packaging>
	

mysar

[client]
#no-beep
socket =/data/mysql5.7/mysql.sock
# pipe
# socket=0.i0
port=3306

[mysql]
default-character-set=utf8

mysar

Mysql 5.7.18 安装部署
#安装好开发环境各种依赖包
yum groupinstall "Development tools"
 #安装依赖包
 yum search libaio # search for info
 yum install libaio # install library

 #新建用户组和用户
 groupadd mysql
 useradd mysql -g mysql

mysar

#!/bin/bash
#
###############################################
#author: im.yan
#email:i@wasis.cn
#date: 2017-06-16
###############################################
 
base_dir=$(cd "$(dirname "$0")";pwd)

mysar

-- 假设要按照用户表 user 用户名 Username 的拼音排序
SELECT * FROM user ORDER BY CONVERT(Username USING gbk) COLLATE gbk_chinese_ci DESC;