MySQl basic query

I. data preparation First, define the data table. The input statement is as follows. CREATE TABLE fruits ( f_id char(10) NOT NULL, s_id INT NOT NULL, f_name char(255) NOT NULL, f_price decimal(8,2) NOT NULL, PRIMARY KEY(f_id) ); Insert the fo ...

Posted on Sat, 08 Feb 2020 02:34:10 -0500 by Amplifier

python3 connects to MySQL database and performs basic operations of adding, deleting, modifying and querying database

This is a detailed description of python connecting to the database. If you continue to use python to connect to the database, please see this template article python3 connection MySQL database template We need to install pymysql when python3 is connected to MySQL database pip install pymysql After ins ...

Posted on Fri, 07 Feb 2020 11:45:08 -0500 by EZbb

python+mysql hands-on small project (add, delete, change and check mobile phone information)

*mysql partI used the db1 database and built two tablesPhone meter -------- store phone informationuser table store account password*python section 1. Connect to the database (connection() function) #Get connection def connection(sql,para): coon=pymysql.connect(host='localhost', ...

Posted on Fri, 07 Feb 2020 11:37:10 -0500 by purtip3154

MySQL 8.0.19 installation tutorial

There are many online installation tutorials, which are basically the same and the same. During the installation process, the installation may fail due to small details. I also refer to many installation tutorials to install successfully. During the installation process, there will be a variety of probl ...

Posted on Fri, 07 Feb 2020 07:19:09 -0500 by gwolgamott

The introduction and application of k8s storage mode

k8s storage: (persistent) docker containers have a lifecycle.volume 1. Storage class is a kind of k8s resource type. It is a logical group created by administrators to manage PV more easily. It can be classified according to the performance of storage system, or comprehensive service quality, backup strategy, etc. But k8s itself doesn't know w ...

Posted on Fri, 07 Feb 2020 06:50:25 -0500 by gotissues68

Ambari 2.7.0 + hdp3.1.4.0 installation, hdfs data backup and recovery, hive data backup and recovery, hbase data backup and recovery

Catalog 1 Ambari + HDP offline installation 1.1 INTRODUCTION 1.1.1 introduction to ambari 1.1.2 HDP 1.1.3 HDP-UTILS 1.2 address of ambari official website 1.3 Ambari and HDP Downloads 1.4 system requirements 1.4.1 software requirements 1.5 modify the maximum number of open files 1.6 cluster node plann ...

Posted on Fri, 07 Feb 2020 06:30:42 -0500 by ryanyoungsma

MySQL in python

1> Installation of mariadb under. Linux 1.Find and mariadb Relevant security subcontracting version yum search mariadb 2.install mariadb Customer and service packages for yum install mariadb mariadb-server.x86_64 -y 3.start-up mariadb service systemctl start mariadb systemctl enable mariadb 4.maria ...

Posted on Fri, 07 Feb 2020 06:26:53 -0500 by samyl

Introduction to the LNMP architecture and software deployment

The lnmp architecture is often heard at work, so what exactly is it? lnmp is the mainstream WEB architecture of Internet companies. In lnmp l is a linux operating system Nginx is a nginx for Publishing Web sites (for static web pages, disconnected databases (html)) nginx is a high performance HTTP and r ...

Posted on Fri, 07 Feb 2020 00:38:27 -0500 by cleanice

ansible installation and module management

brief introduction 1. The process of installing and deploying ansible is very simple and the learning curve is flat.2. There is no need to install the client separately. Knowledge can be leveraged using existing SSHD services (protocols).3. Based on Python development, it combines the advantages of many operation and maintenance tools (puppet, ...

Posted on Thu, 06 Feb 2020 23:19:08 -0500 by gca07738

A reusable distributed transaction message architecture scheme based on RabbitMQ!

Author: Throwable Blog Park: https://www.cnblogs.com/throwable/p/12266806.html premise Distributed transaction is a difficult problem in micro-service practice. In the micro-service practice schemes implemented by the author, all of them adopt compromise or avoid strong consistency.Referring to the local message table scheme proposed by Ebay ...

Posted on Thu, 06 Feb 2020 22:48:04 -0500 by bigfatpig