摘要:1. add mysql 5.7 rpm repo source rpm -ivh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm 2. search mysql in the yum repo yum sear
阅读全文
随笔分类 - mysql
摘要:1. 下载 https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.20-winx64.zip 2. 解压到特定目录 本例中解压到C:\UserDefined\mysql-5.7.20-winx64 3. 准备my.ini 创建目录C:\UserDefi
阅读全文
摘要:rename database hive to hive_cdh_1_1.
阅读全文
摘要:https://blog.csdn.net/wwwdc1012/article/details/88388552
阅读全文
摘要:1. command 2. sample The output result indicate the row number of the table: customers is 4.
阅读全文
摘要:Statement stmt = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); stmt.setFetchSize(Integer.MIN_VALUE); return stmt;
阅读全文
摘要:https://www.cnblogs.com/qq_841161825/p/8830436.html
阅读全文
摘要:首先上官网上下载LINUX版本: http://www.navicat.com/download/navicat-for-mysql 1. 下载 navicat110_mysql_en.tar.gz 文件 2. 下载后解压tar文件 tar -zxvf /home/rain/download/nav
阅读全文
摘要:0. precondition a) install mysql 5.7, for detail please refer my blog post. 1. login mysql and check the variables to see if the binlog has been enabl
阅读全文
摘要:https://www.cnblogs.com/phpstudy2015-6/p/6706465.html https://www.cnblogs.com/phpstudy2015-6/p/6485819.html
阅读全文
摘要:https://www.cnblogs.com/starof/p/4680083.html https://www.jianshu.com/p/c0b7a2b1f981 https://www.cnblogs.com/sunny18/p/10244263.html https://blog.csdn
阅读全文
摘要:mysql 5.7支持的最高版本是Ubuntu17 ,即使安装成功后,也会出现各种妖蛾子,本人就被这种问题困扰了好一会。在Ubuntu 18.04下安装mysql,建议安装8.0以上版本! 1. 配置apt source 下载mysql-apt-config_0.8.11-1_all.deb 2.
阅读全文
摘要:mysql 数据库脚本为: /* */ /* DBMS name: MySQL 5.0 */ /* Created on: 2018/11/23 1:09:10 */ /* */ DROP DATABASE IF EXISTS mysql_sales_source; CREATE DATABASE
阅读全文
摘要:Usage: mysql [OPTIONS] [database] //命令方式 -?, --help //显示帮助信息并退出 -I, --help //显示帮助信息并退出 --auto-rehash //自动补全功能,就像linux里面,按Tab键出提示差不多,下面有例子 -A, --no-aut
阅读全文
浙公网安备 33010602011771号