Dameng DSC cluster construction

DMDSC principle: in one sentence, it can realize multiple instances to control a database; Each node of DSC is an instance, and the database exists in the shared disk. The effect of instance operation database on each node is equivalent. Therefore, the effect of instance operation database of multiple nodes is equivalent to that of one instance ...

Posted by mahakmx on Sat, 26 Mar 2022 07:48:44 +0300

2021 Centos 7 installs mysql through the terminal, with basic operation and detailed explanation, and interacts with Python (with code)

This blog is a follow-up to (). After crawling the data back, I wanted to directly turn it into excel, which is simple and convenient, but when I thought about how we are also programmers and can't be lazy, I put a database on the virtual machine and wrote a blog 😃 1. First look at the system version, Centos 7 2. wget obtains the mysql instal ...

Posted by MrXander on Sat, 26 Mar 2022 07:20:38 +0300

Use Python to dynamically generate SQL statements for creating tables (using Pandas Library) according to the attribute table excel file of a specific format

Problem description There are 33 national standard attribute table excel files, and the database table needs to be built according to these standard attribute tables. The format of each excel is as follows: For such heavy and basically brainless work, I choose Python to do it: code import pandas import re def getStandardDataType(x): ...

Posted by LiamOReilly on Sat, 26 Mar 2022 06:52:41 +0300

MySQL knowledge summary (Part 9) database driver + detailed explanation of environment configuration + JDBC program instance + detailed explanation of Connection class, Statement class and ResultSet class

preface: This article learned from: https://www.bilibili.com/video/BV1NJ411J79W?p=38 Make this note to help deepen your impression and facilitate future review 1, Database driven The concept of driver here is the same as that heard in ordinary times. For example, the sound card purchased in ordinary times cannot be used when the network ...

Posted by jakobdoppler on Sat, 26 Mar 2022 06:12:24 +0300

Using python and MySql for storage encryption

Source download http://www.byamd.xyz/hui-zong-1/ Python 2.7IDE Pycharm 5.0.3PyMySQL 0.7.6MySQL 5.7MySQL Workbench 6.3 Application scenario If the database is temporarily stored in a third party, and the stored data does not want to be seen by the third-party database administrator, and the message involves privacy and can only be seen ...

Posted by satheshf12000 on Sat, 26 Mar 2022 04:59:26 +0300

Basic operation of MySQL database

Basic operation of MySQL database I use MySQL database special software MySQL 5 seven Special software is still very easy to use. If you don't have MySQL 5 7. It doesn't matter. You can also use the built-in database operation software of windows, the shortcut key win + R, and then enter cmd in the dialog box to pop up a and MySQL 5 7 similar ...

Posted by kwong on Sat, 26 Mar 2022 02:23:14 +0300