MySQL

1. MySQL Foundation1) MySQL storage structure: Data SQL statements, tables, database2) Management database:Add: Create database default character UTF8;Delete: Drop database;Modified: ALTER DATABASE default character GBK;Query: Show databases/show

Almost every time the database is modeled, there is a problem with the type of data storage.MySQL storage time typically chooses these four types: datetime, timestamp, int and bigint four ways, exactly what type to use, need to look at the specific

Introduction to Environment >>>>>>>>>>>>>>>>>>Operating system: Centos 7.1MySQL database version: mysql5.7.9MySQL official website: http://www.mysql.com------------------------------------------1, before installing the new version of MySQL, we need

1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p dbname users>

1. Query interface input command, check whether the scheduled task is open, does not start off:show variables like '%event_scheduler% '; 2. Query interface Input command, open timed task: Set global Event_scheduler =1 (then use show variables like '%

In enterprises, the high availability of databases has always been the top priority of enterprises, many small and medium-sized enterprises are using MySQL master-slave scheme, a master and many from, read and write separation, but single-master

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements. Simply put, its role is to analyze query performance.The Explain keyword is very simple to

Mysql> Select Id,avatar from tf_user;+----+--------------+| ID | Avatar |+----+--------------+| 1 | Avatar_1.png | | 2 | Avatar_6.png | | 3 | Avatar_1.png | | 4 | Avatar_5.png | | 5 | Avatar_5.png | | 6 | Avatar_4.png | | 7 | Avatar_6.png | |

llbakt2.sh Features:Back up all records from the USERDB Library T2 table on the server to the native/mybak fileIn the clip. Use the system date to make a backup file name such as 2017-05-25-t2.sqlMkdir/shellvim/shell/allt2bak.sh#!/bin/bashday= '

1.mysql master-Slave backup FundamentalsMySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers. MySQL replication tracks all changes to the database

Transfer from https://www.jianshu.com/p/628bcf8bb557As of MySQL 5.7.18, is my-default.ini no longer included in or installed by distribution packages.MySQL no longer comes with the default configuration fileJust write one manually.Cd/etcsudo vim

Case Description:Two operators of the bank operate the same account simultaneously.For example, A, B operators simultaneously read a balance of 1000 yuan account, a operator for the account increase of 100 yuan, b operator at the same time for the

sudo apt-get install Python-mysqlSuppose there is a database test1, there is a product information table products, insert a product information into it, the program is as follows:#-*-Coding:utf-8-*-Import MySQLdbTryConn=mysqldb.connect (host= '

yumthe general version of MySQL installed is older, but it runs stably. If you want to try the latest features or you need to specify special features, you need to manually compile the installation.First, download the installation package(a), first

1. Download the DMG installation file on the official website.2. After the download is complete, run the installation file, follow the steps to install, the installation will pop up a box to show the temporary password !3. Edit the ~/.BASHRC file,

Data typeTruncate t1 (delete table) # unsigned type ALTER TABLE t1 modify ID tinyint unsigned (table has value, cannot be changed directly) desc t1======================================== tinyint[(m)] [unsigned] [Zerofill] small

Aggregated by year, statistics:Select SUM (Mymoney) as Totalmoney, COUNT (*) as sheets from MyTable Group by Date_format (Col, '%Y ');Summary by month, statistics:Select SUM (Mymoney) as Totalmoney, COUNT (*) as sheets from MyTable Group by

MySQL is a true multi-threaded, multi-user SQL database service that has become the most popular open source database system in the server domain with its high performance, reliability, and ease of use. Currently, the Oracle company is responsible

(1) Ideas Install MySQL Database Create a database, table, insert data authorize a user name and password to back up the database Backup DATABASE commands: Mysqldump-u root-p 1234-d mysqldb > 1.sql introduce an If statement to make a backup of all

MySQL Database Basics1. Database system The database system is a kind of system that manages the array resources specially, the database stores one or more groups of processed data, the software that manages this database becomes the database