MySQL Shell中跑出霸气的Reports

最新推荐文章于 2024-05-21 09:46:31 发布
最新推荐文章于 2024-05-21 09:46:31 发布
阅读量212 收藏
点赞数
分类专栏： 深入mysql的世界 DBA 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011868279/article/details/127314020
版权

Filling Test Data Using Python's Data Science Modules

Check which version of Python MySQL Shell is running .

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import sys
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > sys.version
3.9.6 (default, Aug 25 2021, 16:22:38) 
[GCC 8.5.0 20210514 (Red Hat 8.5.0-3)]
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > sys.path.append("/home/maxwell/.local/lib/python3.9/site-packages")

Data filling step-by-step

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import numpy as np
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import pandas as pd
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import random
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import string
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > from datetime import datetime
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > from datetime import timedelta
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > num_rows=1000
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

 Names and genders

[maxwell@MaxwellDBA datasets]$ pwd
/home/maxwell/datasets
[maxwell@MaxwellDBA datasets]$ head top-male-and-female-names.csv
Rank,Female Name,Count,Male Name,Count_ 
1,Mary,54276,John,108533 
2,Margaret,49170,William,87239 
3,Elizabeth,36556,James,69987 
4,Sarah,28230,David,62774 
5,Patricia,20689,Robert,56511 
6,Catherine,19713,Michael,51768 
7,Susan,19165,Peter,44758 
8,Helen,18881,Thomas,42467 
9,Emma,18192,George,39195 
[maxwell@MaxwellDBA datasets]$
MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import sys
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > sys.version
3.9.6 (default, Aug 25 2021, 16:22:38) 
[GCC 8.5.0 20210514 (Red Hat 8.5.0-3)]
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > sys.path.append("/home/maxwell/.local/lib/python3.9/site-packages")
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import numpy as np
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import pandas as pd
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import random
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import string
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > from datetime import datetime
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > from datetime import timedelta
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > num_rows=1000
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > female_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",usecols=["Female Name"]).rename(columns={'Female Name': 'name'})
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > male_names=pandas.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",usecols=["Male Name"]).rename(columns={'Male Name': 'name'})
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > male_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",usecols=["Male Name"]).rename(columns={'Male Name': 'name'})
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > female_names['gender']=(['F']*female_names.count()['name'])
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > male_names['gender']=(['M']*male_names.count()['name'])
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > names=pd.concat([female_names, male_names],ignore_index=True)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import os
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > os.getcwd()
/home/maxwell
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > os.chdir('/home/maxwell/datasets')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > os.getcwd()
/home/maxwell/datasets
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > names
         name gender
0        Mary      F
1    Margaret      F
2   Elizabeth      F
3       Sarah      F
4    Patricia      F
5   Catherine      F
6       Susan      F
7       Helen      F
8        Emma      F
9        John      M
10    William      M
11      James      M
12      David      M
13     Robert      M
14    Michael      M
15      Peter      M
16     Thomas      M
17     George      M
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > names=names.sample(num_rows, replace=True).set_index(pd.Series(range(num_rows)))
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

Surnames

MySQL  127.0.0.1:33060+ ssl  cookbook  Py > surnames=pd.read_csv("/home/maxwell/datasets/Names_2010Census.csv",usecols=["name"],skipfooter=1,engine='python').rename(columns={'name': 'surname'})
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > surnames=surnames.sample(num_rows,replace=True).set_index(pd.Series(range(num_rows)))
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

Diagnoses

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > diagnoses=pd.read_csv('/home/maxwell/datasets/diagnosis.csv')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > diagnoses
                               diagnosis  frequency
0                Acute coronary syndrome        2.1
1                Alcoholic liver disease        0.3
2                              Pneumonia        3.6
3  Chronic obstructive pulmonary disease        2.1
4                Gastro-intestinal bleed        0.8
5                          Heart failure        0.8
6                                 Sepsis        0.8
7                Urinary tract infection        2.4
8                            Data Phobia        6.2
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > diagnoses=diagnoses.sample(num_rows,replace=True,weights=diagnoses['frequency']).set_index(pd.Series(range(num_rows)))

Results

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > results=pandas.DataFrame({"result":["R","N","D"],"frequency":[6,3,1]})
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > results=results.sample(num_rows,replace=True,weights=results['frequency']).set_index(pd.Series(range(num_rows)))
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

The table

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > patients=session.get_schema('cookbook').get_table('patients')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > # we'll start start the loop
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > for i in range(num_rows):

National ID

national_id=str(random.randrange(10,99)) +''.join(random.sample(string.ascii_uppercase, 2)) + str(random.randrange(100000, 999999))

Age

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > age=random.randrange(15,99)

Dates a patient spent in the hospital

MySQL  127.0.0.1:33060+ ssl  cookbook  Py > date_arrived=datetime.strptime('2020-01-01','%Y-%m-%d')+ timedelta(days=random.randrange(365))
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > date_departed=date_arrived+timedelta(days=random.randrange(60))
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > date_arrived=date_arrived.strftime('%Y-%m-%d')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > date_departed=date_departed.strftime('%Y-%m-%d')
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

 Putting it all together

import numpy as np
import pandas as pd
import random
import string
from datetime import datetime
from datetime import timedelta
num_rows=1000

def generate_patients_data(num_rows):
  # read datasets
  # names and genders
  female_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",
  usecols=["Female Name"]).rename(columns={'Female Name':'name'})
  female_names['gender']=(['F']*female_names.count()['name'])
  male_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",
  usecols=["Male Name"]).rename(columns={'Male Name':'name'})
  male_names['gender']=(['M']*male_names.count()['name'])
  names=pd.concat([female_names,male_names],ignore_index=True)
  surnames=pd.read_csv("/home/maxwell/datasets/Names_2010Census.csv",
  usecols=['name'],skipfooter=1,engine='python').rename(columns={'name':'surname'})
  # diagnoses
  diagnoses=pd.read_csv('/home/maxwell/datasets/diagnosis.csv')
  # Possible results
  results=pd.DataFrame({
  "result":["R","N","D"],
  "frequency":[6,3,1]})
  # Start building data
  diagnoses=diagnoses.sample(
  num_rows,replace=True,
  weights=diagnoses['frequency']).set_index(pd.Series(range(num_rows)))
  results=results.sample(num_rows,replace=True,weights=results['frequency']).set_index(pd.Series(range(num_rows)))
  names=names.sample(num_rows,replace=True).set_index(pd.Series(range(num_rows)))
  surnames=surnames.sample(num_rows,replace=True).set_index(pd.Series(range(num_rows)))
  # Get table object
  patients=session.get_schema('cookbook').get_table('patients')
  # Loop, inserting rows
  for i in range(num_rows):
    national_id=str(random.randrange(10,99))+ \
    ''.join(random.sample(string.ascii_uppercase,2))+ \
    str(random.randrange(100000,999999))
    age=random.randrange(15,99)
    date_arrived=datetime.strptime('2020-01-01','%Y-%m-%d')+ \
    timedelta(days=random.randrange(365))
    date_departed=date_arrived+timedelta(days=random.randrange(60))
    date_arrived=date_arrived.strftime('%Y-%m-%d')
    date_departed=date_departed.strftime('%Y-%m-%d')
    name=names['name'][i]
    gender=names['gender'][i]
    surname=surnames['surname'][i]
    result=results['result'][i]
    diagnosis=diagnoses['diagnosis'][i]
    patients.insert(
    'national_id','name','surname',
    'gender','age','diagnosis',
    'result','date_arrived','date_departed'
    ).values(
    national_id,name,surname,
    gender,age,diagnosis,
    result,date_arrived,date_departed
    ).execute()
  
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > def generate_patients_data(num_rows):
                                          ->   # read datasets
                                          ->   # names and genders
                                          ->   female_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",
                                          ->   usecols=["Female Name"]).rename(columns={'Female Name':'name'})
                                          ->   female_names['gender']=(['F']*female_names.count()['name'])
                                          ->   male_names=pd.read_csv("/home/maxwell/datasets/top-male-and-female-names.csv",
                                          ->   usecols=["Male Name"]).rename(columns={'Male Name':'name'})
                                          ->   male_names['gender']=(['M']*male_names.count()['name'])
                                          ->   names=pd.concat([female_names,male_names],ignore_index=True)
                                          ->   surnames=pd.read_csv("/home/maxwell/datasets/Names_2010Census.csv",
                                          ->   usecols=['name'],skipfooter=1,engine='python').rename(columns={'name':'surname'})
                                          ->   # diagnoses
                                          ->   diagnoses=pd.read_csv('/home/maxwell/datasets/diagnosis.csv')
                                          ->   # Possible results
                                          ->   results=pd.DataFrame({
                                          ->   "result":["R","N","D"],
                                          ->   "frequency":[6,3,1]})
                                          ->   # Start building data
                                          ->   diagnoses=diagnoses.sample(
                                          ->   num_rows,replace=True,
                                          ->   weights=diagnoses['frequency']).set_index(pd.Series(range(num_rows)))
                                          ->   results=results.sample(num_rows,replace=True,weights=results['frequency']).set_index(pd.Series(range(num_rows)))
                                          ->   names=names.sample(num_rows,replace=True).set_index(pd.Series(range(num_rows)))
                                          ->   surnames=surnames.sample(num_rows,replace=True).set_index(pd.Series(range(num_rows)))
                                          ->   # Get table object
                                          ->   patients=session.get_schema('cookbook').get_table('patients')
                                          ->   # Loop, inserting rows
                                          ->   for i in range(num_rows):
                                          ->     national_id=str(random.randrange(10,99))+ \
                                          ->     ''.join(random.sample(string.ascii_uppercase,2))+ \
                                          ->     str(random.randrange(100000,999999))
                                          ->     age=random.randrange(15,99)
                                          ->     date_arrived=datetime.strptime('2020-01-01','%Y-%m-%d')+ \
                                          ->     timedelta(days=random.randrange(365))
                                          ->     date_departed=date_arrived+timedelta(days=random.randrange(60))
                                          ->     date_arrived=date_arrived.strftime('%Y-%m-%d')
                                          ->     date_departed=date_departed.strftime('%Y-%m-%d')
                                          ->     name=names['name'][i]
                                          ->     gender=names['gender'][i]
                                          ->     surname=surnames['surname'][i]
                                          ->     result=results['result'][i]
                                          ->     diagnosis=diagnoses['diagnosis'][i]
                                          ->     patients.insert(
                                          ->     'national_id','name','surname',
                                          ->     'gender','age','diagnosis',
                                          ->     'result','date_arrived','date_departed'
                                          ->     ).values(
                                          ->     national_id,name,surname,
                                          ->     gender,age,diagnosis,
                                          ->     result,date_arrived,date_departed
                                          ->     ).execute()
                                          -> 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \sql truncate table patients
Query OK, 0 rows affected (0.0244 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.get_schema('cookbook').get_table('patients').count()
0
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > generate_patients_data(1000)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.get_schema('cookbook').get_table('patients').count()
1000
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > session.get_schema('cookbook').get_table('patients').select().limit(10)
+----+-------------+-----------+----------------+--------+-----+-----------------+-------------------------+--------+--------------+---------------+
| id | national_id | name      | surname        | gender | age | additional_data | diagnosis               | result | date_arrived | date_departed |
+----+-------------+-----------+----------------+--------+-----+-----------------+-------------------------+--------+--------------+---------------+
|  1 | 79AF555574  | Emma      | BALKEY         | F      |  58 | NULL            | Pneumonia               | R      | 2020-12-12   | 2021-01-12    |
|  2 | 11YS819517  | Elizabeth | PAQUETTE       | F      |  60 | NULL            | Heart failure           | R      | 2020-08-18   | 2020-09-09    |
|  3 | 46YL924212  | David     | GLICKER        | M      |  73 | NULL            | Urinary tract infection | R      | 2020-08-07   | 2020-08-12    |
|  4 | 86JD612318  | George    | LOPEZBELTRAN   | M      |  52 | NULL            | Acute coronary syndrome | R      | 2020-08-16   | 2020-09-17    |
|  5 | 55KW110008  | George    | OROZCOGONZALEZ | M      |  25 | NULL            | Urinary tract infection | R      | 2020-07-15   | 2020-08-09    |
|  6 | 24HB929221  | Mary      | KIRKELIE       | F      |  81 | NULL            | Heart failure           | R      | 2020-06-30   | 2020-08-21    |
|  7 | 32HE856471  | David     | CANZONA        | M      |  33 | NULL            | Acute coronary syndrome | R      | 2020-09-21   | 2020-11-07    |
|  8 | 64BK628444  | John      | GANDIA         | M      |  67 | NULL            | Urinary tract infection | D      | 2020-06-20   | 2020-06-25    |
|  9 | 46GC444803  | John      | SHERIFF        | M      |  73 | NULL            | Pneumonia               | R      | 2020-10-28   | 2020-12-12    |
| 10 | 70WC944263  | Sarah     | WILKS          | F      |  95 | NULL            | Acute coronary syndrome | R      | 2020-04-13   | 2020-05-01    |
+----+-------------+-----------+----------------+--------+-----+-----------------+-------------------------+--------+--------------+---------------+
10 rows in set (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >

Reusing Your Scripts for MySQL Shell

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import numpy as np
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import pandas as pd
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \source /home/maxwell/datasets/mysql_shell/generate_patients_data.py
MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \sql
Switching to SQL mode... Commands end with ;
Fetching table and column names from `cookbook` for auto-completion... Press ^C to stop.
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL > \source /home/maxwell/datasets/tables/patients.sql
Query OK, 0 rows affected (0.0002 sec)
Query OK, 0 rows affected (0.0136 sec)
Query OK, 0 rows affected (0.0002 sec)
Query OK, 0 rows affected (0.0179 sec)
Query OK, 0 rows affected (0.0003 sec)
Query OK, 20 rows affected (0.0042 sec)

Records: 20  Duplicates: 0  Warnings: 0
+----+-------------+-----------+-----------+--------+-----+-----------------+---------------+--------+--------------+---------------+
| id | national_id | name      | surname   | gender | age | additional_data | diagnosis     | result | date_arrived | date_departed |
+----+-------------+-----------+-----------+--------+-----+-----------------+---------------+--------+--------------+---------------+
|  1 | 89AR642465  | Mary      | Smith     | F      |  24 | NULL            | Appendicitis  | R      | 2020-01-15   | 2020-01-20    |
|  2 | 71GE601633  | John      | Johnson   | M      |  57 | NULL            | Asthma        | N      | 2020-03-10   | 2020-03-25    |
|  3 | 15QT023022  | Margaret  | Williams  | F      |  50 | NULL            | Breast Cancer | D      | 2020-05-08   | 2020-08-07    |
|  4 | 84DC051879  | William   | Brown     | M      |  64 | NULL            | Arthritis     | N      | 2020-05-10   | 2020-05-27    |
|  5 | 54XT916306  | Elizabeth | Jones     | F      |  39 | NULL            | Data Phobia   | R      | 2020-04-17   | 2020-06-03    |
|  6 | 06VZ647400  | James     | Garcia    | M      |  86 | NULL            | Diabetes      | D      | 2020-08-09   | 2020-08-15    |
|  7 | 02WS884704  | Sarah     | Miller    | F      |  31 | NULL            | Diabetes      | R      | 2020-08-10   | 2020-08-20    |
|  8 | 78FS043029  | David     | Davis     | M      |  75 | NULL            | Arthritis     | N      | 2020-06-13   | 2020-06-22    |
|  9 | 45MY529190  | Patricia  | Rodriguez | F      |  35 | NULL            | Diabetes      | N      | 2020-02-18   | 2020-03-02    |
| 10 | 30NC108735  | Robert    | Martinez  | M      |  35 | NULL            | Appendicitis  | R      | 2020-09-12   | 2020-09-18    |
| 11 | 38BP394037  | Catherine | Hernandez | F      |  61 | NULL            | Asthma        | R      | 2020-07-13   | 2020-07-19    |
| 12 | 96HE717336  | Michael   | Lopez     | M      |  33 | NULL            | Data Phobia   | D      | 2020-09-15   | 2020-09-20    |
| 13 | 26ES505212  | Susan     | Gonzalez  | F      |  81 | NULL            | Data Phobia   | R      | 2020-10-01   | 2020-10-28    |
| 14 | 04WT954962  | Peter     | Wilson    | M      |  86 | NULL            | Diabetes      | N      | 2020-09-26   | 2020-10-07    |
| 15 | 65XJ029932  | Helen     | Anderson  | F      |  57 | NULL            | Data Phobia   | R      | 2020-10-06   | 2020-10-26    |
| 16 | 59DW008178  | Thomas    | Thomas    | M      |  53 | NULL            | Data Phobia   | R      | 2020-09-15   | 2020-10-26    |
| 17 | 99XC682639  | Emma      | Taylor    | F      |  69 | NULL            | Breast Cancer | R      | 2020-07-18   | 2020-09-15    |
| 18 | 72TY932806  | George    | Moore     | M      |  20 | NULL            | Data Phobia   | R      | 2020-11-01   | 2020-11-10    |
| 19 | 28VU492728  | Alice     | Jackson   | F      |  72 | NULL            | Arthritis     | N      | 2020-10-01   | 2020-11-10    |
| 20 | 09SK434607  | Richard   | Martin    | M      |  23 | NULL            | Asthma        | N      | 2020-11-18   | 2020-11-28    |
+----+-------------+-----------+-----------+--------+-----+-----------------+---------------+--------+--------------+---------------+
20 rows in set (0.0008 sec)
 MySQL  127.0.0.1:33060+ ssl  cookbook  SQL >
DB架构
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Shell脚本中执行sql语句操作mysql的5种方法
09-15
主要介绍了Shell脚本中执行sql语句操作mysql的5种方法,本文讲解了将SQL语句直接嵌入到shell脚本文件中、命令行调用单独的SQL文件、使用管道符调用SQL文件等方法,需要的朋友可以参考下
MySQL Shell的简单介绍(r12笔记第95天）
weixin_39214481的博客
06-18 6104
MySQL Shell是在官方版本5.7.12推出，工具的初衷本身都是为了解决一类问题，想必官方从很多方面了解到工具的使用情况，支持的开发语言太多，众口难调，所以这么个命令行工具就出来了，从它的推出，足以看到MySQL的格局，它是把很多能做不能做得都揽过来自己做了。根据官方的shell,python,原生SQL,Java等，格式都是清一色的JSON.如果对这个工具还是有一些疑惑的话，在最新版本的I...
mysql 如何解决memory_解决memory
weixin_31695145的博客
01-19 442
Redis: OOM command not allowed when used memory > ‘maxmemory’阅读目录现象原因解决回到顶部现象日志里出现异常：OOM command not allowed when used memory > 'maxmemory'回到顶部原因内存已满，不允许再存数据了，可以通过redis-cli 查看redis的具体信息127....文章...
php7 + mysql8 + nginx 快速入门
xxx
04-19 1152
这篇文章也是对之前写的关于php的文章的一个小总结，同时，从真正的"0"开始带略微有编程经验的同学如何简单的跑起来一个php项目。如果你是一个编程新手，不建议从php入门，建议先学c。 下面是正文 1、下载并安装 php7、mysql8 和 nginx 2、验证安装 1)、验证php 2)、验证mysql 3)、验证nginx 来到nginx的安装目录，执行 start nginx命令，打开 ...
gitlab CI中单元测试与集成测试的研究与实践
安澜公子的博客
08-17 7386
文章目录gitlab CI中单元测试与集成测试的研究与实践配置说明GitlabGitlab RunnerSonarqubeCI流程图需要解决的问题代码编写项目代码单元测试Service单元测试Controller单元测试集成测试提供专门用于测试的配置文件application-test.yml.gitlab-ci.yml编写gitlab-runner server 安装mysql-client.g...
推荐升级四部曲之 CM 升级，收藏了！
DataFlow范式
04-28 935
概要笔者最近在研究 CDH 大版本升级（CDH 5.16.2 -> CDH 6.3.3）的细节内容，涉及到每个组件的方方面面，确保升级过程中出现各种意外情况能够自主可控，降低未来生...
java葵花宝典中的宝典！
wang915900175的专栏
05-05 3589
葵花宝典之java    一：面向对象的特征有哪些方面     1. 抽象：抽象就是忽略一个主题中与当前目标无关的那些方面，以便更充分地注意与当前目标有关的方面。抽象并不打算了解全部问题，而只是选择其中的一部分，暂时不用部分细节。抽象包括两个方面，一是过程抽象，二是数据抽象。 2. 继承：继承是一种联结类的层次模型，并且允许和鼓励类的重用，它提供了一种明确表述共性的方法。对象的一个新类可以
Astalavista被蹂躏过程(转载自baoz.net)
热门推荐
cnbird's blog
06-09 16万+
里面两个亮点，一是远程获得apache用户权限的shell，banner是LiteSpeed，看来这玩意有0day，但是又怎么是用apache用户跑的，原来LiteSpeed这东西是和apache绑一起的，大概看了下介绍，主要功能是anti-ddos，这东西貌似还有点意思，回头玩玩。具体的看http://www.litespeedtech.com/litespeed-web-server-
大数据各个工具随笔
weixin_30710457的博客
09-20 1358
# 基本配置 ```shell#目录结构： bin：二进制的客户端命令 etc：存放配置文件 etc/conf lib：存放jar包的目录 sbin：存放管理类的脚本启动服务 share：hadoop所有的jar包 #查看主机名 hostname#临时修改主机名 hostname hadoop#永久修改主机名 vi /etc/sysconfig/network #查看主机ip i...
Hbase官方文档中文版
szl的专栏
03-09 3579
http://abloz.com/hbase/book.html#quickstart http://yankaycom-wordpress.stor.sinaapp.com/hbase/book.html?q=/wp-content/hbase/book.html#hbase_default_configurations 目录 序1. 入门 1.1. 介绍
shell的多线程&当前文件夹下批量插入MySQL
09-30
shell的多线程,以及使用多线程编写shell脚本实现当前文件夹下批量插入MySQL。
shell简单处理mysql查询结果的方法
09-09
今天小编就为大家分享一篇shell简单处理mysql查询结果的方法，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧
自动化部署 MySQL Shell脚本
01-04
自动化部署 MySQL Shell脚本
mysql shell安装脚本
03-18
mysql shell安装脚本
python学习-使用pandas库分析excel表，并导出所需的表
SixSix的自留地
05-16 516
使用pandas库分析excel表中多个子表的数据
【MySQL精通之路】管理和实用程序
Anakki的博客
05-19 218
8 mysql_migrate_keyring——keyring密钥迁移实用程序。2 innocchecksum——离线InnoDB文件校验和实用程序。7 mysql_config_editor——mysql配置工具。9 mysqlbinlog——用于处理二进制日志文件的实用程序。6 myisampack——生成压缩的只读MyISAM表。4 myisamchk——MyISAM表格维护实用程序。5 myisamlog——显示MyISAM日志文件内容。3 myisam_ftdump——显示全文索引信息。
MySQL--增、删、改、查，
weixin_65476290的博客
05-15 1159
数据库的概述、发展、现状、历史、分类MySQL关系型数据库、架构（C/S）window系统安装MySQL数据库Linux系统【选学】数据库对象——数据库（database）show、create、drop命令数据库对象——表（table）数据类型数据库表的约束表结构的调整（alter）数据库授权和权限管理（grant）数据库的编码情况【编码一致，建议统一采用utf8mb4】
mysql-8.0.21-winx64 安装
最新发布
hhw199112的博客
05-21 320
但最好能从一个已安装的mysql里把它的my.ini复制一份到自己的安装目录中。该命令执行后，会让输入密码，但是初始化的时候创建的是不带密码的账号root,直接回车即可。将mysql库中的user表，将root所在记录的host改为"%"即可。打开安装目录中的bin文件夹，在当前目录一下打开cmd命令，执行如下命令。该命令用户初始化数据库，创建一个不带密码的账号root。执行该命令，设置root的登录密码是Root_123。还是在bin文件夹中，打开cmd命令，执行如下命令。
mysql shell
09-08
要启动 MySQL Shell，您可以在命令行中输入 "mysqlsh" 命令。一旦启动成功，您可以选择连接到本地或远程 MySQL 服务器，并通过执行相应的命令和查询与数据库进行交互。 例如，以下是通过 MySQL Shell 连接到本地 ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值