MySQL

Environment:Master: 172.16.115.161From: 172.16.115.1631. Install MySQL and mysql-server on master and slave machinesYum install-y MySQL Mysql-server2. The master-slave configuration file opens the binary file; The server ID is used to differentiate

RAND ()--Returns a random number between 0 and 1Floor (value)--Rounding downCeil (value)--Rounding upCOUNT (Field/*); --When the parameter is a field, the number of records in that field in each group is counted, but NULL is not counted; when the

Case: MySQL can only log on localhost, use #mysql-uroot-p-hip-p3306 cannot log inWorkaround:1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the

Familiar with or understand the database of friends are aware of the concept of lock, here do not do too much analysis! There are many kinds of locks, and different database lock management methods are different. Here is the main talk about the

First, new dataInsert into view name [(field list)] VALUES (list of values);Note:1. Multiple table views cannot add data.2. A single table view has a base table all fields that cannot be empty or have no default values can add data.Ii. deletion of

Tag: connection where SQL join Select also returns NULL for outer JOINSELECT * from test1 a,test2 b where a.no=b.no;; Internal connectionSELECT * FROM Test1 a ieft join test2 B on a.id=b.id; left outer connectionSELECT * from Test1 a right joins

Database update and Backup is one of the basic functions of operations, and here is the operation of the statement to do a tidy, not regularly updated.1) Database backup statementsMYSQLDUMP-H Database IP address-u user name-p password ABC XYZ >

Today, when programming, the Chinese stored in the MySQL Chinese garbled problem, the online search data finally resolved:The first thing you just opened is a question mark:Then I looked up the data, first I read my MySQL encoding formatSo according

Select* from where a.batch_no = ' ss20170123181418' ;This is the original data:This is what it looks like after a row-to-column:SelectA.debt_type,sum( Case whenDebt_type='0' ThenAMOUNTEND)'Initial Debt',sum( Case whenDebt_type='1'

MySQL executes the INSERT and other statements to report the following error:1205 Lock wait timeout exceeded try restarting transactionThe solution is as follows:Method One: View the current thread, if there is a statement that is executing you,

The storage engine, also known as the table type, refers to the way that MySQL uses different technology settings for various scenarios to store tables.Common ones are:

Since the operation of the database from the database link to write, including the building, building tables, add and remove the Check field and constraints, delete the library, delete the table of data, the following is mainly my previous interview

Stored ProceduresWhat is a stored procedure??In simple terms, a stored procedure is a collection of one or more SQL statements that are saved for later use .It's more like the concept of a function in our programming language.In a programming

Note:1, like only when the data is listed as a string, and like is not the beginning of the index will be effective2, greater than less than the index will only be effective when the data is listed as integral type3. If you want to use or, and you

This article is an improvement on Java using JDBC to connect MySQL database II.The previous section uses PreparedStatement to execute the database statement, but PreparedStatement needs to pass an SQL statement parameter before it can be created.

The test is conducted in three cases, namely:First case: In and or where the column is the primary key.The second case is where the in and or columns are created with an indexed case.The second case is where the in and or columns do not have an

InnoDB table. frm: Table structure. IBD: Table space (data and index)SHOW ENGINESSHOW TABLE STATUSHow the program language connects to the database:Dynamic SQL: Establishing a connection to a database service by function or methodEmbedded

Today, with people to discuss the PHP high concurrency under the last_insert_id of the correctness of the first people are more vague, and then through the common query information, the problem has a relatively clear understanding, special hair This

At the end of the year, do a routine inspection for MySQL.Preface: Routine inspection is a required item before the holidays. It performs a round of comprehensive health check on servers. On the one hand, it can ensure the stability of servers

MySQL increases or decreases the specified time interval for the current data table. The DATE_ADD () function adds a specified interval to a date. All data in the current table will be added one day later: UPDATE ACT_BlockNum SET CreateTime =