MySQL

Before I installed MySQL, I always installed it with a compressed package. If you have previously installed MySQL, you must delete the registration file to completely delete MySQL.Download the MySQL version on the website first. Download the package

How to find the relationship between two tablesanalysis steps: # 1 , first stand in the angle of the left table to find whether the left table of multiple records can correspond to a record of the right table, if so, prove a field of the left table

#!/bin/bash#scripts sh recovery_increment.sh Time date for example: 14 20180228Bakfile=/data/dbbackupLogfile=/data/bak.logDbuser=xxxDbpasswd=xxxxip=ifconfig | grep "inet addr"| grep Bcast| awk ‘{print $2}‘| awk -F":" ‘{print

Enumeration types and collection typesThe value of a field can be selected only in a given range, such as a radio box, a multi-marqueeThe enum radio can only select a value within a given range, such as gender sex sex male male/female femaleSet

MySQL formatted date: date_format (date, format)Date: Time fields format: Date formatFormat the date value according to the format string:%s,%s two digits in seconds (00, 01, ..., 59)%I,%I two digits in the form of points (00, 01, ..., 59)%H two

One, integerInteger and Smallint,mysql are supported in standard SQL to extend the tinyint, mediumint, and bigint.MySQL supports specifying the display width of the data type, such as int (8), which specifies that the display width of type int is

View: is a virtual table, which is the essence of your own definition of a query SQL statement, through this view (statement), you each time to get the view data is equivalent to using a SQL statement even query, generate dynamic datasets (data do

The result is that when you try to import a CSV file into a MySQL table, the following error occurs:"The MySQL server is running with the--SECURE-FILE-PRIV option so it cannot execute this statement"Baidu a bit, the reasons given are:MySQL new

Backup process Create a backup directory$ cd ~$ mkdir backup$ cd backup To create a backup Shell script:Vim databasenamebackup.sh#!/bin/bashMysqldump-uusername-ppassword DBName | Gzip > ~/dbname$ (date +%y%m%d%h%m%s).

Continue learning in Django ...The database that Django uses by default is Python's own SQLlite3, but Sqllite doesn't apply to large projects, so I swapped the database for MySQL, and here's how Django configures the database ...The version I am

[Daily] MySQL memory failure solution, mysql Solution 1. Failed to start mysql. Check the error log/var/log/mysql/error. log. 2. The main error messages are as follows: [ERROR] InnoDB: mmap (136151040 bytes) failed; errno 12 [ERROR] InnoDB:

Database optimization instances and stories, database optimization instances Brief:Every technology is inseparable from the database. The database is like a human brain. Once a problem (fault) occurs, pause, and the consequences of the card master

C # implement MySQL command line backup and recovery, There are many tools available for MySQL database backup. In the past two days, I wrote a tool that uses C # To Call MYSQL's mysqldump command to complete MySQL database backup and recovery. How

Install and configure Mysql5.7 and centos7mysql5.7 on Centos7 Step 1: Obtain the mysql YUM Source Go to the mysql website to obtain the RPM package Https://dev.mysql.com/downloads/repo/yum/   Right-click Copy link

Mysql Time query optimization skills based on time, mysql Time query skills For example, to query newly registered users yesterday, the statement is as follows: EXPLAINselect * from chess_user u where DATE_FORMAT (u. register_time, '% Y-% m-% D') =

Database ~ Description of Explain in Mysql, mysqlexplain You can add an Explain statement before the select statement to implement the execution plan of mysql. It tells us about the statement performance. The following is a specific description of

Mysql field pre-sorting method, multi-field sorting method, mysql Field Background: Under SEO, select a query condition to query the display information for the decoration designer and designer's work. The designer's prototype is as follows: if you

Database ~ Notes for Mysql derived tables ~ Mysql is derived from the slow query of millions of data Basic Concepts A derived table is a virtual table returned from a SELECT statement. A derived table is similar to a temporary table,SELECTIt is much

A good mysql interview exercise, having comprehensive application, mysqlhaving Write an SQL statement to calculate the average score of two or more failed subjects. > Two or more subjects must fail. > Calculate the average score of all the subjects

How to synchronize data from MySQL to MongoDB !, Mongodb Data Synchronization With the business development of many companies, a single database instance can no longer meet business needs, and data exchange needs to be conducted regularly to