MySQL

1 Download a RPM package for updating the Yum MySQL data source http://dev.mysql.com/downloads/repo/yum/ RPM-UVH MYSQL-COMMUNITY-RELEASE-EL6-N.NOARCH.RPM//install this RPM package to update Yum's MySQL data sourceYum Repolist enabled | grep MySQL/

There is a very interesting application with ROLLUP in MySQL's extended SQL, which is based on the statistical data of the group and then the same statistic (Sum,avg,count ... ), very similar to the functionality of statistical functions in Oracle,

Binlog and redo Log differences1, the first 2 are recorded data changes, the difference is that Binlog is to record all the data change information, and InnoDB redo log only records all InnoDB table data changes.2. Binlog is a DML and DDL SQL

Alter Table' User_movement_log 'ADD columnGatewayidint not NULL default 0After ' RegionID ' (which field is added later)Alter TableX_connectionAdd' FEX-N752 'varchar(Ten)default NULL;//PRIMARY KeyAlter TableTabelnameAddnew_field_idint(5)

One: part of the log1.1 error Log1.2 General Query Log1.3 Slow Query Log1.4 Binary Log1.5 Relay Log1.6 transaction LogTwo: Storage Engine introduction2.1 MyISAM2.2 InnoDB2.3 Mrg_myisam2.4 CSV2.5 ARCHIVE2.6 MEMORY2.7 Blackhole1.1 error log:Mainly

Mysqldump-h ' 114.212.111.123 '-urose-pxxxooo--opt--compress ITSM--skip-lock-tables | Mysql-h Localhost-uroot-proot ITSMCExplanation:114.212.111.123 Remote server nameROSE Remote Database login namexxxooo Remote Database login passwordITSM remote

The driver is a JDBC driver.The URL is the address of the database.Usrname and password are database user names and passwords, respectively.The connection class is used to connect to MySQL. The resultset is used to store the result, which is

Environment: CentOS 6.5[[email protected] software]# yum -y install gcc gcc-c++[[email  protected] software]# tar -zxvf cmake-2.8.5.tar.gz[[email protected] software]#  cd cmake-2.8.5[[email protected] cmake-2.8.5]# ./configure --prefix=/usr/local/

Implementation features: Upload Excel files and import them into the database according to the formatFind Phpecel on the internet but Phpexcel is too big, its own limited ability is not very good to streamline, finally found phpexcelreader this

Note that the current Apache and PHP and MySQL to use 32-bit, the machine is 64-bit is also installed 32 bits. I have installed the 64-bit version before, and there is always a problem. Back to the point:Required Software:1.apache: Go to the

Paging technology is very common in the development, I just went to the company to do two projects are used in the paging technology, so think about the paging technology in-depth exploration.There are several common paging methods:

Can withstand tens of thousands of data, fast, and use the transaction, no data errors will result in some data insertion (if all successful if one is unsuccessful, the test process did not fail), the need for friends can refer to the

SameShowThe timestamp column is displayed in the same format as the datetime column. In other words, the display width is fixed at 19 characters, and the format is Yyyy-mm-dd HH:MM:SS.DifferentRangedatetime Retrieves and displays datetime values in

Method One, set php.ini:Vi./php.inifile_uploads onupload_max_filesize = 150mpost_max_size = 200m# If you have a larger SQL file, you need to set it up: Max_execution_time 30 0 #每个PHP页面运行的最大时间值 (seconds), default 30 seconds Max_input_time

MySQL has 3 seed queries, including, where type, from and exists types.where sub-queryWhere followed by a conditional expression, the condition is true when the row is fetched, where the subquery refers to the inner layer of the query result set of

The common rules for indexing are as follows:1, the table's primary key, the foreign key must have the index;2, the data volume of more than 300 of the table should be indexed;3. Tables that are often connected to other tables should be indexed on

Written in the previous words:It is always after the disaster that the importance of disaster tolerance is remembered;Always after the loss, just remember that there was a reminder.(i) Core military(1) Do not operate the databaseCPU computing must

Turn from the insect masterHttp://www.cnblogs.com/fnng/p/3565912.htmlOne, install MySQLIf you are a Windows user, MySQL installation is very simple, download the installation files directly, double-click the installation file step by steps.Linux

A cornerstone of good logic design and high performance for physics designersFirst, select the optimized data typeSmaller is usually betterConsumes less CPU cycles required for disk, memory, CPU caching, and processingIt's simple.Operations require

20 + best experiences in MySQL performance optimization (1) Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not