Basic operation of Hive

Article directory 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) Six, query 6.1 basic query ...

Posted by PyroX on Sun, 23 Feb 2020 09:38:46 +0100

Failure analysis | Crash caused by binlog flush failure

By xuty 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

PDO basic operation of PHP

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

laravel code focus

1. To create a project through composer: composer create-project --prefer-dist laravel/laravel laravel 2. Enter project: cd /var/www/html/laravel 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

springboot ~ integrated DataSource and Druid monitoring configuration

introduce 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

python django project creation steps

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

How to use TCP Wrappers to protect MySQL from service interruption

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/ case 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

PG database kernel analysis learning notes log recovery strategy In PostgreSQL, the StartupXlog entry function is called when the system restarts after a crash // xlog.c /* * This must be called ONCE during postmaster or standalone-backend startup */ void StartupXLOG(void) { XLogCtlInsert *Insert; ...

Posted by trouble706 on Mon, 17 Feb 2020 11:05:04 +0100

3-Use databases in Django

Database Settings 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

MySQL query operation

Introduction to MySQL database Learning notes (2) Simple query 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 Conditional query where clause is required for condition q ...

Posted by the-hardy-kid on Sun, 16 Feb 2020 05:48:27 +0100