4, DDL data definition
4.1 create database
4.2 query database
4.3 modify database
4.4 delete database
4.5 create table
4.6 zoning table
4.7 modification table
5, DML data operation
5.1 data import
5.2 data export
5.3 clear data in the table (Truncate)
6.1 basic query ...
Posted by PyroX on Sun, 23 Feb 2020 09:38:46 +0100
Open a pit to record the process of MySQL source code tracking and learning due to problem solving needs or interest research.
1, Problem phenomenon
MySQL Crash occurs in a project. The related error log logs are as follows. From the logs, it can be seen that the problem is caused by binlog error, but the specific reason can not be c ...
Posted by mars_rahul on Fri, 21 Feb 2020 14:43:21 +0100
The difference between PDO and Mysqli
For PHP 5 and above, the following methods are recommended to connect to MySQL:
MySQLi extension ("i" means improved)
PDO (PHP Data Objects)
PDO is used in 12 different databases, MySQL is only for MySQL database.
Both support preprocessing statements to ...
Posted by Zssz on Fri, 21 Feb 2020 08:49:47 +0100
1. To create a project through composer:
composer create-project --prefer-dist laravel/laravel laravel
2. Enter project:
3. To create a controller:
php artisan make:controller StudentController
4. Create model classes and data migration files:
php artisan make:model Student ...
Posted by ibanez270dx on Thu, 20 Feb 2020 04:54:06 +0100
Druid is first a database connection pool. Druid is the best database connection pool at present, surpassing other database connection pools in function, performance and scalability. Druid has deployed more than 600 applications in Alibaba, which has passed the severe test of large-scale deployment of production environment for more t ...
Posted by siric on Wed, 19 Feb 2020 04:40:15 +0100
There are many different Web frameworks under Python. The common ones are Django, Flask,Torand,. Django is the most representative of the heavyweight players. Many successful websites and apps are based on Django. Django adopts the framework mode of MVC, namely model M, view V and controller C.
1, P ...
Posted by Kookedoh on Tue, 18 Feb 2020 12:59:24 +0100
By Ananias Tsalouchidis
Translated by: Meng Wei
Original text: https://www.percona.com/blog/2020/01/07/how-securing-mysql-with-tcp-wrappers-can-cause-an-outage/
Protecting MySQL is always a challenge. There are general best practices for installing reinforcement, but the more complex your settings are, the more likely you are to encou ...
Posted by Solarpitch on Tue, 18 Feb 2020 11:08:40 +0100
PG database kernel analysis learning notes log recovery strategy
In PostgreSQL, the StartupXlog entry function is called when the system restarts after a crash
* This must be called ONCE during postmaster or standalone-backend startup
Posted by trouble706 on Mon, 17 Feb 2020 11:05:04 +0100
In the previous section, you learned how to create a Django project, create a web application in a Django project, and reference the URL of a web application in the URL of a Django main program.Here's how to use databases in Django.To use a database in Django, you first need to understand the settings for the database connecti ...
Posted by Sinikka on Sun, 16 Feb 2020 21:48:32 +0100
Introduction to MySQL database Learning notes (2)
SELECT column_name1, column_name2 FROM table_name;
#select name,phone from person;
SELECT * FROM table_name;
#select * from person; * indicates all contents in the query table
where clause is required for condition q ...
Posted by the-hardy-kid on Sun, 16 Feb 2020 05:48:27 +0100