MySQL

PHP Server Environment build installation software preparation 1. Apache224.tar.gz2. php-5.2.9.tar.gz3. mysql-5.1.54.tar.gzPHP and individual component packagesLibxml2-2.6.30.tar.gzXML C language version of the

Author: Crystal Compilation In the ASP era, if we want to build a database-driven Web site, then you can choose to ring a lot of money in the Microsoft SQL Server database or choose to spend a lot of time to find the performance and stability of

1. Event backgroundToday, when the lunch point approached, the development colleague sent a request to create two views in the MARIADB library, requiring the specified account to have read-only permissions.Very simple requirements, connected to the

Java Web project, the foreground page of the form data, inserted into the database, the results appear garbled "???" The problem of intermittent tossing for a day time, nonsense not to say, steps are as follows:One: Configuration in Web. XML:

Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all

8.10 Mysql Master-Slave synchronization8.10.1 Master-Slave principleThe principle of MySQL master-slave synchronization:1. Turn on the Bin-log log on master to record some records of changes deleted on master.2, the master and slave each open IO

MySQL yesterday a week ago a year ago the data here mainly used in the date_sub,Refer to the followingThe code is as follows:SELECT * from Yh_contentwhere Inputtime>date_sub (Curdate (), INTERVAL 1 day)where Inputtime>date_sub (Curdate (), INTERVAL 1

Idea: Uninstall Redhat with yum, then download the CentOS yum, install and modify the configuration file1 , first to Http://mirrors.163.com/centos Download Packagex86 Address: http://mirrors.163.com/centos/6/os/i386/Packages/x86_64 Address:

1.1 Get the current date + time (date + times) function: Now ()In addition to the now () function to get the current datetime, MySQL has the following function:Current_timestamp () Current_timestampLocalTime () localtimeLocaltimestamp ()

Use the following syntax:# Mysqlslap [Options]Common parameters [Options] Detailed description:--auto-generate-sql,-a automatically generates test tables and data, indicating that the concurrency pressure is tested using the SQL script generated by

Gearman create a MySQL persistence queue in the following ways:1. Log in to the MySQL command line and run:Create Database Gearman;2. Start Gearman with the following command:/usr/local/gearman/sbin/gearmand-p 4730-l 0.0.0.0--log-file=/tmp/gearmand-4

1. Description(1) For the MyISAM table, if you update the self-increment column with update, an error occurs if the column value repeats with the existing value, and if it is greater than the existing maximum, the auto_increment of the table is

Build MySQL database using PowerDesigner designI. Create a library script using PowerDesigner1. Design CDM (conceptual Data Model)2, choose Tools--Generate physical Data Model, select the corresponding DBMS for MySQL, generate PDM3, select database,

In the reconstruction of the site, the data structure is usually modified, so add, delete, add the MySQL table field is unavoidable, and sometimes for convenience, but also increase the modification of the table or field comments, the same field

MySQL as the golden Partner of PHP and the most widely used database on the Internet, inevitably deal with it every day, many friends in the familiar with the use of Swoole, also a lot of pits, ready to combat, and finally on-line, is a pleasant

If we are new to start learning and use the Linux vps/server to build the site and project environment, if due to time and effort Limited, we can choose one-click Package or Web panel easy to get started. If we want to optimize the system later, and

I. MySQL database usage in Unix/Linux C Linux MySQL database development Joint development of MySQL and C Development Library Installation MySQL C API Programming example1. Software Package requirements 1) MySQL Server Mysql-server-3.23.54a-11 Mysql-

Mysql performance optimization solution sharing and mysql performance optimization sharing There are many mysql performance optimization solutions on the Internet. However, mysql optimization is more troublesome than SQL server. In the same settings,

Mysql Character Set knowledge summary, mysql Character Set Summary Character Set & character encoding Character set is a collection of multiple characters. There are many types of Character sets. Each Character set contains different numbers of

In mysql, if I use common data sorting methods, we may not get the expected results, but mysql provides us with the CAST CONVERT function, which can CONVERT numbers accordingly, I used this function to sort Chinese characters in the past. Let's