PHP

When using the ThinkPHP framework, view its source code to use the functions _ autoload and apl_autoload_register. These two functions are used for automatic loading. The main function is to trigger these two functions to load the file that has not

Summary of mysqldescesc basic commands bitsCN.com SQL codeAsc in ascending orderDesc in descending orderThe following statements are Mssql statements and cannot be used in access.SQL classification:DDL-Data Definition Language (CREATE, ALTER, DROP,

Mysql allows users to remotely connect to bitsCN.com 1. install MySQLThis should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. let's talk about the configuration below.2. configure

Compile and install mysql5.5 FreeBSD on FreeBSD BitsCN.com Mysql5.5 uses the new configuration tool cmake. Therefore, during compilation and installation, make sure that cmake has been installed in your system, the redhat system can be viewed

Problems caused by duplicate server-id synchronization between multiple mysql databases bitsCN.com Today, after setting up a new SLAVE database server, we found that there were a large number of TIME_WAIT database connections between the MASTER and

Oracle-log recovery-015 bitsCN.com The tablespace is not backed up and deleted. logs need to be restored, but logs cannot have breakpoints.Check whether logs are in archive mode under sys userSQL> archive log listIf you are in non-archive mode, you

Lite version mysql adds the log feature bitsCN.com Perform two-layer development and use mysql for database.Based on your experience and the methods provided by colleagues on the network, you can remove unnecessary files and create a mysql mini

Solve mysql-can bitsCN.com When importing mysql data today, the following error occurs:Mysql> load data infile '/root/aaa' into table test fields terminated by', 'lines terminated by '/N ';Mysql> ERROR 13 (HY000): Can't get stat of '/root/aaa'

MySQL master-slave synchronization acceleration scheme bitsCN.com I. problem originThe master-slave synchronization of MySQL has always encountered the problem of slave database latency. There are many background information on the internet. The

Root remote connection to bitsCN.com in MySQL Create USER 'itpro' @ '%' identified by '201312 '; 1. d:/mysql/bin/> mysql-h localhost-u root// You can access the MySQL server.Mysql> update user set host = '%' where user = 'root ';Mysql> select host,

Mysql character set and verification rules bitsCN.com The concept of character set is clear to everyone. many people do not understand the proofreading rules. this concept is not used in general database development. mysql seems very advanced in

BitsCN.com Recently, the mac osx lion system was installed, and the mysql 5.5.16 database was installed for development. However, we all know that the default mysql encoding is latin1. if you store Chinese characters, garbled characters may occur,

Mysql optimization (2) index optimization configuration optimization bitsCN.com 2 Index and query optimization Index type Ø normal index: this is the most basic index type and has no restrictions such as uniqueness. Ø unique index: it is basically

MYSQLJDBC quick query and response method and quick return mechanism implementation bitsCN.com Oracle's fast return mechanism has been very tangled. although there are many result sets, it can quickly display the first result. although it can be

Selectfrom in MySql: a link target to be updated bitsCN.com In MySql, how to select from a link target to be updated: Problem description: In the fifth edition of Database System Concepts ( Fifth Edition), Chapter 3, 3.10.3 about SQL updates.

Improve MySQL's table_cache bitsCN.com The following are my broken ideas at work, and the records are messy ...... ........................................ ................................ In mysql, there is a table_cache parameter. when the value

Mysql source code learning-bitsCN.com After learning the lexical analysis and syntax analysis, I started my formal learning tour of Mysql source code. How many modules can we start ?! Fortunately, I found a module division from the internet. I

MySQLInnodb database performance practices-VARCHARvsCHAR bitsCN.com Readers who have studied database theory should still remember the performance comparison between CHAR and VARCHAR: CHAR is faster than VARCHAR because CHAR is of a fixed length

Check whether logs are enabled for bitsCN.com in mysql logs. Mysql> show variables like 'log _ bin '; How to know the current log Mysql> show master status; Use mysqlbinlog to view binary log files Shell> mysqlbinlog mail-bin.000001 (to write

Mysql horizontal table sharding bitsCN. comMysql encounters horizontal table sharding when the data volume is large. 1. split tables based on business attributes This table sharding algorithm is roughly modulo, hash, md5, and so on. If you