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 insta ...

Posted by MrXander on Sat, 26 Mar 2022 07:20:38 +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