Mysql database 2: DML operation, multi table relationship and query operation
catalogue
1. DML - modify operation
2. DML delete
3. Mysql simple query operation
4. Multi table relationship and table building principle
4. Mysql multi table Association query
4.1 mysql Association query classification
4.2 write sql statement to realize mysql multi table Association query
5. Mysql query operation
1. DM ...
Posted by drag0n on Fri, 20 May 2022 23:14:59 +0300
Interviewer: talk about redis6 Three ways to build cluster in version 0
Friends interested in PHP back-end technology and PHP architecture technology, my official group Click here , study together and discuss with each other.
There are already managers in the group to sort out the knowledge system (source code, learning videos and other materials). Welcome to add the group for free.
1, Single node instance
The s ...
Posted by alex.hughson on Fri, 20 May 2022 17:24:46 +0300
Pyhton3, database table design and data storage for website construction~
Building your own website is one of the signs of success as a coder,
Then there are other signs of success, holding Bai Fumei in your left hand, rolling a small barbecue in your right hand, and stepping on Santana under your feet
Um
Crawling data
Some children will say, uncle fish, aren't you designing a database table? How do you return the p ...
Posted by kingcobra96 on Fri, 20 May 2022 09:38:56 +0300
Shell script integer value comparison, logic test, if statement
1. Conditional test operation
[conditional expression]
(1) document test[file or directory]-d: Whether the directory is directory (test) -e: Test whether the directory or file exists (Exist) -f: Test whether it is a file -r: Test whether the current user has permission to read, -w: Test whether the current user has permission to write -x: T ...
Posted by Sneo on Fri, 20 May 2022 07:41:43 +0300
JDBC connection database
1, jdbc connection to mysql above 8.0
After the mysql version above 8.0 is updated, the corresponding jdbc connection has also changed.
First of all, we need to configure the mysql environment. It is recommended that you go to the Internet to find a tutorial and follow it. I won't talk about the installation and configuration of mysql here.
...
Posted by mjl4975 on Fri, 20 May 2022 03:06:37 +0300
Source code compilation and installation LAMP
preface
The lamp architecture based on apache is one of the mature enterprise website application modes and one of the highest market share in the market. Learning to deploy a basic lamp architecture can be the start of our in-depth study and understanding of the more complex architecture.
1, LAMP overview
LAMP architecture is one of the ...
Posted by ShimmyShine on Fri, 20 May 2022 01:48:27 +0300
Connecting MySQL database with Linux (C + +)
1, Environmental installation
The first is the installation of MySQL, which is directly installed only with apt get command (this method is recommended here, because it does not need to link the relevant path when compiling later programs)
sudo apt-get install mysql-server
After my installation, the relevant header files and dynamic lib ...
Posted by posidon on Fri, 20 May 2022 01:31:35 +0300
Technology sharing | MySQL uses MariaDB audit plug-in
Author: Yao yuanFocus on Oracle and MySQL databases for many years, Oracle 10G and 12C OCM, MySQL 5.6, 5.7, 8.0 OCP. Now Dingjia technology serves as a consultant to improve database training and technical support services for colleagues and customers.Source: original contribution*It is produced by aikesheng open source community. The original ...
Posted by BrianWald on Wed, 18 May 2022 22:57:05 +0300
Applet development learning record - get user openid
Main function: the applet obtains the user's openid as the user's unique identification code.
Function Description: the reason to obtain the openid of the user is that it has unique identification and is used as the unique identification to identify the user. With a unique ID, we can know who used our applet. The rules formulated by wechat mak ...
Posted by jlp09550 on Wed, 18 May 2022 15:48:25 +0300
[Java+JDBC+MySQL] use Java to operate JDBC and connect to MySQL database
1. Import jar package
Copy the jar to the lib directory, right-click the jar package - [Add as Library] and import it into the project
2 operation steps (addition, connection, language, execution and interpretation)
2.1 loading registration driver
Register the Driver through the following statement. The principle is that this statement will Cl ...
Posted by Pr0digy on Wed, 18 May 2022 08:08:51 +0300