MySQL databaseSome errors often occur during installation or uninstallation. This is a headache for us. This article describes solutions to several common errors during MySQL database installation.
Solution to apply security setting error during
This article introduces the problem caused by an illegal hardware shutdown.MySQL databaseOfData Table Corruption, An instance where the database cannot run normally. The next step is the author's troubleshooting process. Let's take a look at it.
The
Why?MySQL databaseOfMaster/Slave serversIs there a gap between data? The reason is that the master server is busy and the hardware difference between the master server and the slave server is large, which may lead to a large data gap between the
MySQL databaseHow to delete some keyRepeated Fields? In this article, we use an example to introduce this deletion method. Let's talk about this example first.
First, let's take a look at the Statistic table structure:
Processing sample:
Main
Last time we introduced: suitableBeginnersMySQL management experience of the MySQL study notes. Here we will introduceMySQL QueryOperations, including function queries and subqueries. Let's take a look at this part.
Function Query
The so-called
Last time we introduced:For MySQL 5.5Partitions: partitions in non-integer columns. This section describes partitions in MySQL 5.5.Truncate PartitionNext, let's take a look at this part.
Enhanced availability: truncate partitions
One of the most
Installation environment: Windows Server 2003 [32bit NTFS]
Version: MySQL 5.5.15 [: http://dev.mysql.com/downloads/]
References: http://dev.mysql.com/doc/refman/5.1/zh/installing.html
Step 1: select the installation type
There are three types
What is MDL?
MDL, Meta Data lock, and metadata lock are generally called dictionary locks. The dictionary lock corresponds to the data lock. The dictionary lock is used to protect data objects from changes. Generally, some DDL statements change the
The MySQL Forge project aims to provide a community wiki library for MySQL developers to share information. However, Oracle found that in the past few years, the MySQL Community has fewer and fewer Forge users, but more are being visited by spam.
Use TIMESTAMPDIFF to calculate the time difference between two dates in MySql:Syntax:TIMESTAMPDIFF (interval, datetime_expr1, datetime_expr2)Note:Returns the integer difference between datetime_expr1 and datetime_expr2the. The resultThe unit is
The day before yesterday, I needed to randomly extract several records from a database with 5 million records because of my work. Here I directly use the mysql rand by function. It doesn't matter if there are thousands of records, however, if tens
In the script, you can set the list of database tables to be backed up and compress the backup files through gzip. Note that this script is only applicable to environments with low data consistency requirements.Copy codeThe Code is as follows:#!
1. order by rand ()The data is too slow and the randomness is very good. It is suitable for situations with very small data volumes.Copy codeThe Code is as follows:SELECT * FROM table_name AS r1 JOIN (SELECT (ROUND (RAND () * (select abs (MAX
LinuxAll operations in the console.Import database:Prerequisites: the database and data table must exist (already created)
(1) import the data table test_user. SQL TO THE test_user table of the test database.[Root @ test ~] # Mysql-uroot-p test
(2
Debian6 system:
First install mysql:
Open the terminal (root) User Login
Apt-get purge mysql-server-5.5
After installation:
By default, Mysql only allows local login, so you need to modify the configuration file to bind the address to comment
I suddenly couldn't open MySQL and reported a 10061 error because I didn't know why. I checked the cause and said it was because the database was connected to a conflict, so I had to reinstall it, in the last step, the start service stopped, the
I tried several methods that Google had not solved. Then I suddenly remembered the iis port usage when I started apache (because apache also used port 80 ), so open the command line
Netstat-aon | findstr" 3306"
Result Display
Silently scolded "
Copy codeThe Code is as follows:-- Create test tables and dataCreate table webuser (username varchar (10 ));Insert into webuser values ('a1'), ('a2 '), ('a3'), ('b1'), ('b2'), ('b3 ');Commit;-- Create a stored procedureDrop procedure if exists
OverviewMDL means that once the DDL is blocked, all queries for the table will be suspended, including Select, but 5.6 has been improved, and 5.5 can be controlled by parameters.
If no MDL
Session 1: mysql> select version (); + ------------ + |
A module in a recent project needs to implement the pinyin initial character query function. I checked the information online and modified the information to meet the project requirements.
The implementation process is as follows:
1. Create a
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