nianyixiaotian的博客

yum安装mysql5.7 1,安装mysql源： yum -y localinstall http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm yum repolist enabled | grep “mysql.*-community.*” 2,安装mysql： yum -y install mys...

导出数据和表结构： mysqldump -u user_name -p pwd db_name > db_name.sql 只导出表结构 mysqldump -u user_name -p pwd -d db_name > db_name.sql information_schema 信息 use information_schema; #查询所有数据的大小： sele...

DELIMITER $$ DROP FUNCTION IF EXISTS `Num_char_extract`$$ CREATE FUNCTION `Num_char_extract`(Varstring VARCHAR(100)CHARSET utf8, flag INT) RETURNS VARCHAR(50) CHARSET utf8 BEGIN DECLARE len INT D...