MySQL

Do MySQL master and slave will certainly encounter a lot of synchronization problems, most of them are due to machine downtime, restart, or the primary key conflict caused by the server to stop work, here specifically to collect similar problems and

MySQL has provided us with delete and TRUNCATE statements to delete data. Definition of DELETE statement: Children who often work with databases, delete the data most of the time with the DELETE statement. Now let's take a look at the definition

Find problems have been running well before, suddenly MySQL can not work. Request command post error: ERROR 1820 (HY000): You must SET PASSWORD before executing this statement You cannot log on using the phpMyAdmin administration tool, Error: #1862

The MySQL Drop database command is used to delete a database, and if you attempt to delete a nonexistent database using the drop DATABASE command, you receive this error: Error 1008 (HY000): Can ' t drop database ' Tutorial_database '; Database

Recently in the development of the project to use the MySQL database, after reading some articles about MySQL, quickly started to use. In the use of the process, there are still some problems, because the use of the green installation version of

Standard SQL pattern matching SQL pattern matching allows you to match any single character with "_", while "%" matches any number of characters (including 0 characters). In MySQL, the SQL schema defaults to ignoring the case. Some examples are

1. Introducein the MySQL circle, can personally feel everyone to the MySQL 5.7 expectations and enthusiasm, it seems that everyone can not wait to understand, learn and use MySQL 5.7. So, we can not help but ask, MySQL 5.7 in the end what has been

2.1 Login to MySQL console [username is root, password defaults to NULL] Switch to MySQL's Bin directory cd D:/wamp/mysql/bin Login to MySQL Console Syntax: mysql-h hostname-u username-p Connecting to another host Code: Mysql-h 192.168.1.1-u

Later in doing WordPress, the original did not know that WordPress used the InnoDB data engine, so in the original database built a database, the beginning did not find the problem, installation, import SQL, no problem, then did not think much.

Kill syntax KILL [CONNECTION | QUERY] thread_idEach connection to the mysqld runs in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a thread with the kill thread_id statement. Kill

1, connect the database Laravel The database configuration file is config/database.php, open the file, the default content is as follows: return [Default return result set to PHP object instance' Fetch ' => pdo::fetch_class,The default database

The segmented fields must be finite and small in number, and we cannot store infinitely many characters in a stringThe table that this field belongs to has a one-to-many relationship with the table associated with this field.For example, the

From the official documentation that Linux compiled installed on the MySQL default connection of 100, so the site is not enough for the needs. MySQL official told us that we need to modify the value of max_connections, so how do we modify it? There

Recently saw a number of online tests, the feeling is not very accurate, today personally tested some. It is concluded that the testing process on personal computers may not be comprehensive enough for reference only. Test process:Prepare a test

In order to install the MySQL environment test, installed after the discovery of MySQL after the launch of a large amount of virtual memory, up to more than 800 trillion. Online search for a while, get expert advice My.ini. Never see the details

For a long time, PostgreSQL was considered a replacement for MySQL. During that time, however, there was no way to get him to the level that MySQL could achieve. These problems have not been solved in recent years and have produced many interesting

One, what triggers 1, personal understandingTriggers, which are literally understood, a hair-trigger device, a trigger (haha, personal understanding), for example, like when it's dark, you turn on the light, you see something. You put the

Start from here My blog, what is the background database? Yes, it is MySQL, server-side use of the script is PHP, the entire framework using WordPress. PHP and MySQL are like couples, always working together. Now here, on the collection of PHP,

First, MySQL change Password method:1. Modify with Mysqladmin#mysqladmin-uroot-p password ' newpass ' Enter password: note: If it is the first time to change the password, prompt enter password: Direct carriage return if it is reset password, prompt

Shopping cart implementation is a necessary function during the development of e-commerce websites. This article introduces the implementation of php shopping cart code.Principle: cookie stores the shopping cart ID and data stores the shopping cart