PHP

Float and decimal type bitsCN.com in MySQL Float and decimal types in MySQL Float and double are prone to errors. when the precision requirements are relatively high, decimal is recommended for storage. decimal is stored in mysql memory as a

Set mysql to allow Internet access to bitsCN.com Set mysql to allow Internet access The root account of mysql. I usually use localhost or 127.0.0.1 during connection, Mysql on the company's test server is also localhost, so The solution is as

MySQL deadlock causes query resolution bitsCN.com MySQL deadlock causes query resolution failure During database maintenance recently, data cannot be stored into the database during data parsing. The reason is that MySQL transactions have

MySQLutf8mb4 character set: supports emoji emojis bitsCN.com MySQL utf8mb4 character set: supports emoji (I) Preface In order to cope with opportunities and challenges of the wireless Internet, and to avoid problems caused by emoji, We recommend

Mysql format example bitsCN.com Mysql format example I wrote a mysql formatting example. DELIMITER $ Drop procedure if exists 'testdb'. 'test _ p_getTimeRange '$ Create definer = 'ipd' @ '%' PROCEDURE 'test _ p_getTimeRange '(OUT

Mysql modification code LinuxMacUnix general bitsCN.com Mysql: Linux/Mac/Unix/General The myslq configuration file is required to modify the mysql encoding. the file is in/etc/my. cnf, mac users do not have this file by default. you can find

Some work records on Java and databases in Ubuntu (1) Ubuntu BitsCN.com I want to use a program to generate some test data and test which of the open source databases is suitable for our data warehouse project. In fact, test data can be generated

MySQL database table garbled solution bitsCN.com MySQL database table garbled solution It is very important to specify the encoding when creating a mysql database. many developers use the default encoding, but from my experience, coding databases

MySQL data file description bitsCN.com MySQL data file description 1. MySQL data file description First look at the file under MySQL DataDirectory: Here dave and mysql are our database names. we can view them in the mysql database: In

A simple script for detecting whether the mysql master/slave is normal or not bitsCN.com Script for simple mysql master/slave check I want to use a simple script to test whether the master and slave databases are normal. 01 #!

MySql installation (rpm) and startup configuration bitsCN.com MySql installation (rpm) and startup configuration Installation steps: 1. unzip the MySql installation package [Root @ bakdbserver mysql] # tar-xf MySQL-5.5.24-1.rhel5.x86_64.tar [root

MysqlCluster overview and deployment of bitsCN.com Mysql Cluster overview and deployment The most significant advantage of MySql Cluster is high availability, high real-time performance, high redundancy, and high scalability. It allows you to

High-Performance MySql evolution (I): Data type optimization _ bitsCN.com High-Performance MySql evolution (1): Data type optimization The database performance tuning process involves a lot of knowledge, including whether the attribute settings of

[Slow query optimization] When creating an index, pay attention to the field selectivity. for range query, pay attention to the field order of the combined index. bitsCN.com Preface: I have previously said that "everyone is not required to

The hard disk space occupied by MYSQL to query database table indexes is bitsCN.com. Query Database usage Select concat (ROUND (SUM (index_length)/(1024*1024), 2), 'mb ')AS 'total Index size', CONCAT (ROUND (SUM (data_length)/(1024*1024), 2), 'mb')

FlashbackTable flashback to drop table (recycle bin flashback) bitsCN.com Flashback Table flash back to drop Table (recycle bin flash back) The recycle bin function of oracle is determined by the recyclebin parameter. the default value is on;

In linux, the correct method of restarting MySQL is bitsCN.com, which modifies my. cnf. you need to restart the MySQL service. for the correct method of restarting MYSQL, see the following article. Because Mysql is installed from the source code

Some methods for optimizing the query speed when mysql processes massive data bitsCN.com Recently, due to work needs, I began to pay attention to the optimization methods of select query statements for Mysql databases. In actual projects, it is

Comparison between mysql and postgresql (for reference) bitsCN.com To understand the difference between PostgreSQL and MySQL, I searched for the keyword MySQL vs PostgreSQL and read several articles on the first page. The following is a

Mysql viewing statement execution efficiency bitsCN.com EXPLAIN I. purpose: 1. When must I add an index to the table to obtain a faster select statement that can be remembered using the index? 2. check whether the optimizer joins the table in an