MySQL special system induction and quick start (common cmd commands, common function summary, SQL statement elaboration with examples) is suitable for beginners and quick check of usage
π
Όππππ
»
π
³π
° π
Ήπ
Έπ
° π
·π
°π
ΎοΌπ
Έ'π
Ό π
π
π
€ π
§π
π
π
π
π
π
€ΚΚΜ―β’Ν‘Λβ’Μ―α·
ΚΙ
πΉκ§κ¦Ώππ
΄π
»π
²π
Ύπ
Όπ
΄βοΈ ππ
Ύβ¨ π
Όπ β€οΈπ
±π
»π
Ύπ
ΆπΉκ§κ¦Ώ
β¨β focus is not lost. Bloggers are still making efforts to prepare more wonderful content~ β ΚΚΜ―β’Ν‘Λβ’Μ― α·
ΚΙ Xiao Joo is here to thank you for your support!
β¨ π
²π
Όπ
³ entry and exit π
Όππππ
»
πΉ Connect to local database
mysql -uroot -p
. Exit mysql
exi ...
Added by westen on Wed, 09 Feb 2022 12:54:03 +0200
MySQL homework question (supplement: calculate the difference between two dates in MySQL)
MySQL homework questions
Three tables
mysql> select * from emp; // Query all data from the emp table* On behalf of all
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+-- ...
Added by Divine Winds on Wed, 09 Feb 2022 08:15:48 +0200
Moher College - SQL injection vulnerability test (Boolean blind injection)
SQL injection vulnerability test (Boolean blind injection)
The first step is to judge the injection point: Enter a single quotation mark in the url and an error is found. Then enter and1=1. The page is normal and and1=2 reports an error This indicates that there is a SQL injection vulnerability in this url
http://219.153.49.228:48551/new_list ...
Added by andy2006 on Wed, 09 Feb 2022 05:48:07 +0200
Advanced MySQL - storage engine, index, lock, transaction
Storage engine
1. Overview
MySQL's storage engine is plug-in. Users can choose the best storage engine according to the actual application scenario. MySQL supports multiple storage engines by default to meet different application requirements.
MySQL 5.7 supports storage engines such as InnoDB, MyISAM, MEMORY, CSV, MERGE, FEDERATED, etc. Sinc ...
Added by kryppienation on Wed, 09 Feb 2022 01:52:33 +0200
5, Annotation for automatic assembly
(the notes of the article are from the video of station b. when you meet the crazy God, you can carry the notes as a study for your reference and study together) Automatic assembly instructions
Automatic assembly is a way to use spring to meet bean dependenciesspring will find the bean that a bean depends on in the application context.
There ...
Added by spetsacdc on Tue, 08 Feb 2022 23:36:52 +0200
mysql advanced part 1: stored procedures and functions
Overview of stored procedures and functions
Stored procedures and functions are a collection of SQL statements that have been compiled and stored in the database in advance. Calling stored procedures and functions can simplify a lot of work of application developers and reduce the transmission of data between the database and the ap ...
Added by mandukar on Tue, 08 Feb 2022 21:16:52 +0200
MySQL 8.0 password changes
MySQL 8.0 password modification process
Problem background: after MySQL is installed, the wrong option is set in the process of initializing the root account password, resulting in failure to log in.
step.1. Enter the command line interface of mysql
Modify / etc / MySQL / MySQL conf.d/mysqld. CNF file, add the skip grant tables option, so th ...
Added by big_c147 on Tue, 08 Feb 2022 20:25:47 +0200
Install and deploy MGR cluster | explain MGR in simple terms
The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]This paper introduces how to use GreatSQL 8.0.25 to build a three node MGR cluster.1. Installation PreparationPrepare the following three servers:IPportrole172.16.16.103306mgr1172.16.16.113306mgr2172. ...
Added by sparrrow on Tue, 08 Feb 2022 19:10:28 +0200
Database backup: Xtrabackup realizes full backup and incremental backup
5.3 xtrabackup backup tool
5.3.1 introduction to xtrabackup tool
Percona: Official website: www.percona.com com percona-server InnoDB --> XtraDB
Xtrabackup backup tool:
percona Provided mysql Database backup tool, the only open source tool that can innodb and xtradb Tools for database hot standby
Manual: https://www.percona.com/doc/ ...
Added by paolo on Tue, 08 Feb 2022 17:33:59 +0200
SpringBoot builds a Markdown based blog - Part 1
In this article, I will set up a personal blog, which contains articles written in the way of Markdown.
We will use Spring Boot to develop the project and some other tools and libraries. We will push the project to the GitHub repository and post the post to our blog using Heroku's automatic deployment function.
In addition, we will use the ...
Added by kritikia on Tue, 08 Feb 2022 16:12:04 +0200