01. Search MySQL Linux02. Upload the downloaded MySQL using xftp to the software folder in Linux03. Remove the package after switching to the specified directory!04. Installing the client and serverIssues that may be conflicting with previous
First, configure the environment:Os:win10mysql:5.7.19Second, my MySQL configuration file (My.ini) is as follows:[Client]port=3306default-character-set=utf8[mysqld] #Path to install software directory Basedir=e:\mysql-5.7.19#path To the database
The. msi version of the MySQL installation package died in the third or fourth part of the installation when it was last executed.Mainly because the previously installed version is not uninstalled cleanly, there are several steps to uninstalling the
MySQL's dual-machine hot standbyDual-Machine hot standby, is to maintain the status of two databases automatically synchronized. Operations on any one database are automatically applied to another database, keeping two of the database data
Usage Notes: Ifnull (EXPR1,EXPR2)If EXPR1 is not Null,ifnull () returns EXPR1, it returns EXPR2.Ifnull () returns a numeric or string value, depending on the context in which it is used.Let us first cite some examples:Mysql> SELECT ifnull (1,0); +---
Import and export between Navicat databases1. Double-click the database you want to export, right-click the dump SQL file ..., select the folder you want to save. 2. Click Start to start exporting. Database Import1. Create a new database, the
MySQL user name and password is rootSo login-u Access user name,-p connection password, because there is no password so direct return[Email protected] mysql]# mysql-uroot-pSo MySQL is not secure, need to add password.MySQL set the password in two
1 FOREIGN key
FOREIGN key: Foreign key, outside the key (the key is not in its own table), if a table has a field (non-primary key) to the other table's primary key, then the field is called a foreign key.
1.1 Adding foreign keys
Bulk delete a specific prefix tableFirst step: Assemble SQL statementsSelect CONCAT (' drop table ', table_name, '; ') From Information_schema.tables Where table_name like ' ca_% ';650) this.width=650; "src="
After the initial installation of MySQL, you can skip the password directly to MySQL.[Email protected] ~]#/usr/local/mysql/bin/mysql-urootwelcome to the MySQL monitor. Commands End With; or \g.your MySQL connection ID is 1Server version:5.6.35 mysql
1. What is a storage engine?The storage engine refers to the type of the table. The storage type of the database determines how the table is stored on the computer. Users can do this by notTo select the appropriate storage engine with the same
General steps for MySQL optimization:1. Understanding the execution efficiency of various SQL through the show status commandSHOW Status provides state information for the MSYQL serverIn general, we just need to know the instructions that start with
1. Integral type
MySQL data type
Meaning (Signed)
tinyint (m)
1 byte range ( -128~127)
smallint (m)
2 byte range ( -32768~32767)
Mediumint (M)
3 byte range ( -8388608~83
mysql5.1.6 adds an event scheduler (Scheduler) that can do timed tasks (time-lapse records, timed data statistics) instead of the previous system's scheduled tasks. The MySQL event Scheduler can perform a task exactly one second.The difference
Restoration of master-slave replication failure in mysqlPreface:Because the Host Name of the linux server is modified, mysql master-slave replication becomes invalid. Now you need to restore master-slave replication. This is a bit different from
MySQL (8), mysql1 transaction
Requirement: there is A bank account table where user A transfers money to user B. Account A decreases first and Account B increases, but A loses power after operation.
Solution: A reduces the money, but does not
MySQL (9), mysql1. Code Execution Structure
There are three types of code execution structures: sequential structure, branch structure, and cyclic structure.
1.1 Branch Structure
Branch Structure: Prepare multiple code blocks and execute a
MySql successfully inserted data but reported [Err] 1055, err1055
1. Problem:
In the past two days, the insert operation is performed. mysql version is 5.7. After the insert operation is successful, an error of [Err] 1055 is reported. The details
Simple examples of storage functions and stored procedures in MySQL, mysql stored proceduresStorage Function Definition
Create function 'fn _ Sum' ('A' int, 'B' int) RETURNS int (11)BEGINRETURN a + B;END
Call the call in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service