MySQL

Turn off Bin-log Log When the Bin-log log is turned on, many mysql-bin.0000*-like files are generated and may take up a lot of hard disk space. For their own test machine or hard disk more nervous VPS, and do not need to do master,slave

The PSC file is a backup file generated with the Navicat tool and can only be recovered using the Navicat tool. (i) Error occurrence steps 1 Connect MySQL with Navicat 2 Create a new database, name arbitrarily take, such as MYDB1, character set

The following query selects the records for all date_col values within the last 30 days. Mysql> SELECT something from Tbl_name WHERE To_days (now ())-To_days (Date_col) DayOfWeek (date) Returns the week index of date (1 = Sunday, 2 = Monday, ...). 7

This is not a fixed number. This article briefly describes the restriction rules. Strlen calculates string length, one Chinese when 2 characters Mb_strlen according to its character encoding mode, the statistic character quot Count the number of

Apache|mysql|apache|mysql 1, install PHP: will download the PHP compressed file decompression, folder renamed to PHP copied to the C-packing directory. 2, open just unzip the PHP directory, you will find a file called "Php.ini-dist", this is the

52, set the change root password, connect MySQL, mysql common commandFirst, set the change root passwordThe root user is the MySQL Super Admin user, the root and system root is not a user, need to partition, you can also create a normal user to

ERROR 2059 (HY000): Authentication plugin ' Caching_sha2_password ' cannot be loadedMay 07, 2018 15:56:32 read: 2997 more Personal Category: DockermysqlCopyright NOTICE: This article for Bo Master original article, without Bo Master permission not

Ecshop default is the normal connection method, from the error shows that you are using the pconnet way, this way when the concurrency ratio is large, there are the following shielding end:Apache Module Mode:The difference is that when PHP is

System Maintenance engineer Li ChaoWe have introduced the Distributed Monitoring System zabbix-automatic discovery-add MySQL multi-instance monitoring, but did not provide the key that can be used directly, too shabby, the monitoring effect is poor.

CentOS6.7 using a non-root user (normal user) compile and install the MySQL database and implement the MySQL database service random auto-start using the Shell Script timed task mode1. About MySQL?MySQL is a relational database management system

MySQL Query SQL statements today, yesterday, nearly 7 days, nearly 30 days, this month, and last JanuaryThis article mainly introduces the MySQL query today, yesterday, nearly 7 days, nearly 30 days, this month, the January of SQL statements,

Concept:A primary key (primary key) uniquely identifies a property or group of properties for a row in a table. A table can have only one primary key, but there may be multiple candidate indexes. Primary keys often form referential integrity

Overview of the database management system (DBMS)1. What is a DBMS: a repository of data> Convenient Search> Large amount of data can be stored> Ensure the integrity and consistency of the data> Safe and Reliable2. Development of DBMS: Today's

Many times we need to develop their own programs in the local testing, this time the PHP operating environment is essential, this article is based on the author on the Internet to find some information and their own practice to write out, so that

We know that data is at the heart of an enterprise IT architecture, and in order to prevent data loss or some other special purpose for some accidental reasons, it is especially important to make backups of the data at the usual times.First, why to

Original http://www.cnblogs.com/xuejie/archive/2013/01/11/2856911.html We will certainly encounter the backup database in the course of running the project, restore the database situation, we generally use two ways to deal with: 1. Import and export

The difference between timestamp,datetime,int types in MySQL and their pros and cons  int1. Occupies 4 bytes of 2. After indexing, the query is 3 faster. Conditional range searches can be used using BETWEEN4. You cannot use the time function

Mysql obtains the date of yesterday, today, tomorrow, and the time of the previous hour and the next hour. 1. Current date select DATE_SUB(curdate(),INTERVAL 0 DAY) ; 2. Tomorrow's date select DATE_SUB(curdate(),INTERVAL -1 DAY) ; 3. Date of

Configure the MySQL 64-bit installation-free version in Windows Windows 7 64-bit MySQL 64-bit installation-freeDocument category: Database1. Download http://pan.baidu.com/s/1jGf5nUI2. decompress the package to the D: \ MySQL folder (specified by the

Mha (Master High Availability) is currently a mature solution for MySQL multi-server (more than two) High Availability.I. What is mha and what are its features?1. Automatic monitoring and failover of the master serverMHA monitors the master server