MySQL

Method 1: Log in to MySQL, do the set names Latin1 first, and then execute the UPDATE statement or execute the statement file MySQL>set names Latin1; Method 2: Specify set names latin1 in the SQL file, and then log in to MySQL and execute MySQL with

The previous introduction of Mysqldump backup method is the use of logical backup, the biggest drawback is that the backup and recovery is slow, for a database less than 50G, this speed is acceptable, but if the database is very large, then use

MySQL's SQL useBrief introductionWhat is SQL?SQL refers to Structured query languageSQL gives us the ability to access a databaseSQL is an ANSI standard computer languageRemarks: ANSI, national standardization organization of the United StatesFirst,

First, MySQL multi-instance 1, IntroductionWhat makes multiple instances?Multi-instance is to open a number of different service ports on a single machine (for example: 3306,3307);Run multiple MySQL service processes that provide their own services

MySQL Quick Start batUsing batch processing under Windows to start off MySQL, the main idea is to register MySQL as a service under Windows and recommend it to everyone.The green version of MySQL is registered as a service under Windows, or the

Experiment DescriptionThis experiment requires four hosts to install MySQL, a deployment amoeba, a primary database server, two from the database server, also need a host to do client access testing, the end of this experiment can realize the

Typically, we run Web applications with Linux distributions from CentOS, Ubuntu, Debian, and more. At this time, constitute the service architecture must be nginx, PHP and MySQL, and other applications of the rights control is very important, each

1, Mysqlrplsync tools.A tool used to check the data consistency of master-slave replication.Mysqlrplsync --Master=Check:pass@192.168.152.157:3310 --slaves=check:pass@192.168.152.159:3311,check:pass@192.168.152.160:3312 2,

ObjectiveAs a background development, it is necessary to benchmark the database to master the performance of the database. This article describes the basic concepts of MySQL benchmarking and the detailed methods for benchmarking MySQL using Sysbench.

As follows:SELECT * fromProduct--Querying all ColumnsSELECTPro_id,pro_name fromProduct--querying a specified columnSELECTPro_name as 'Product Name', Price fromProduct--Add constant column change pro_id to "Product name" (Add constant column just

MySQL storage engine MyISAM and InnoDB storage engine Data in MySQL has a variety of different technologies for storing files or in memory. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels,

MMM introductionMMM (Master-master Replication Manager for MySQL) is a set of scripting programs that support dual-master failover and dual-master daily management. MMM is developed using the Perl language and is primarily used to monitor and manage

Completely uninstall MySQL under UbuntuMake a note:1. Delete MySQL1sudo apt-Get Autoremove--Purge MySQL-server-5.0 2 sudo apt-get remove mysql-server 3 sudo apt -get autoremove mysql -server 4 sudo apt-get remove  mysql-common (very important)

ObjectiveIn this section, we mainly describe how to use Python to manipulate the MySQL database.Get readyThe MySQL database uses the Docker container "Test-mysql" in the previous section.Python Operation MySQLThe IDE we use is the "Magic" Pycharm:1.

Set up a MySQL server to answer ports and bind IP addresses The MySQL server listens to port 3306 By default and determines the firewall to open this port. Edit/ETC/MY.CNF Add the binding IP address.bind-address=192.168.42.

MySQL full backup and recovery skill targets Master the method of backup using Nysqldump How to master MySQL data recovery MySQL full backup 1, the importance of database backup (1) Improve the system's high availability and

MySQL Multi-instanceMySQL multi-instance, simple to understand is on a server, the MySQL service to open a number of different ports (such as 3306, 3307), running multiple service processes. These MySQL service processes use different sockets to

There are several declarative forms of error handling:§ If any error (not FOUND), set L_error to 1 to continue execution:DECLARE CONTINUE HANDLER for SQLEXCEPTIONSET l_error=1;§ If any errors occur (not FOUND), execute rollback and produce an error

BackgroundNavicat is the best of the MySQL visualizer, but in terms of the import and export of the view, it is handled in alphabetical order by the view name, and when the view is dependent, it will be an error during the import process. The

MySQL boot error starting mysql ... error! The server quit without updating PID file (/opt/mysql/data/mysql.pid)Viewing the MySQL error log is also not written.Finally found is SELinux open, Khan ...ReferenceMySQL startup times wrong: starting MySQL