MySQL

There are two major strides in opening MySQL's remote login account:1. Determine that the firewall on the server does not block port 3306.MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable

For MySQL InnoDB table Two-level index whether to join the primary key, summarized as follows: 1 for the MySQL InnoDB table two level index whether to join the primary key, the official also has the explicit explanation, recommends that the

Web Development If you encounter PHP query MySQL return a large amount of data caused by memory overflow, or memory is not enough to use the situation that need to look at the MySQL C API Association, then what is the result of PHP query MySQL

Recently encountered the problem of MySQL garbled, find some information, first save, the back slowly summed up their processing methods.Notes:Problem Environment Summary:1. The front desk PHP code has not changed2. The original database, all the

MySQL database server usually refers to the mysqld, and command line MySQL is the MySQL client program, these two concepts are usually easy to confuse. Normally starting the MySQL server is starting the mysqld process, and after Mysqld is started,

When using MySQL to create data tables, it is unavoidable to involve the concept of character set and collation, which is not well understood before.The two days are not very busy, and I tidied up a bit.Let's take a look at character set and

NT (M) let's first split, int is representing integer data so the middle of the M should represent how many bits, and later the MySQL handbook also learned that my understanding is correct, I would like to illustrate.The integer types in the MySQL

PowerDesigner MySQL PDM comment Note2012-11-01 15:38 4447 People read comments (0) report Classification:Database related (7) PowerDesigner MySQL PDM comment noteFirst, Generate commentsThe default PD does not generate comments and can be modified

Set the user to show database permission firstGrant Select,insert,update,delete on redmine1.* to [e-mail protected]"%" identified by "Jira";Add super permissions and allow remote access:GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 '

In MySQL, inserting (insert) A record is simple, but some special applications, before inserting a record, need to check whether the record already exists, only if the record does not exist to perform the insert operation, this article describes the

System:[Email protected] ~]# cat/etc/redhat-releaseCentOS Release 6.3 (Final)DB version:Mysql> SELECT @ @version;+------------+| @ @version |+------------+| 5.6.26-log |+------------+Data Center Department applies for on-line database SELECT

First, install the JDK1, first to the official web download jdk-7u79-linux-x64.tar.gz.2, copy the jdk-7u79-linux-x64.tar.gz to the/usr/lib/jdk/directory below, if there is no JDK folder, create the folder, command:1 cd/usr/lib2My JDK is a U-disk

1. MySQL adds a time interval for the date: Date_add ()Set @dt = Now ();Select Date_add (@dt, Interval 1 day); -Plus 1 daysSelect Date_add (@dt, interval 1 hour); -Plus 1 hoursSelect Date_add (@dt, interval 1 minute); -Plus 1 minutesSelect Date_add (

1. Create a MySQL playbook structure[Email protected] roles]# pwd/etc/ansible/roles[[email protected] roles]# mkdir-p Mysql_install/{files,handlers,meta , Tasks,templates,vars}[[email protected] roles]# tree

Password is used to modify the MySQL user password, if it is applied with the Web program recommend using the MD5 () function,Password function Legacy 16-bit, new version 41-bit, can be viewed with select length (Password (' 123456 ')).Password

In MySQL database, you often encounter the content of the day of statistics.For example, in the user table, the Date field is: Log_timeStatistics DayThe SQL statement is:Select * from User where = curdate (); Curdate () indicates the date of the

MySQL Database tool class--datatable batch join database (NET version), Mysqldbhelper General class want to be useful to everyone, the code is as

MySQL monitoring tool-Innotop, mysql tool-innotop Innotop is a powerful MySQL monitoring tool. It uses perl to show the running status of MysQL servers and Innodb in text mode.   Install innotop : Https://github.com/innotop/innotop Github provides

MySQL data recovery case after truncate misoperation, mysqltruncate The actual online scenario is complicated. At that time, the truncate and delete operations were involved. It was confirmed that more than 70 thousand rows of data were lost. when

MySQL query cache settings improve MySQL query performanceFirst, let's take a look at the MSYQL logical framework: The image comes from high-performance mysqlIf QueryCache is used, the server will retrieve the results from the query cache when the