MySQL

Introduction The efficiency of PHP is obvious, this is one of the reasons I like it, and it is called a wonderful partner MySQL and Apache want to merge, cannot but marvel at its efficiency. PHP updates are also very quick, here is the latest

Five ways to change MySQL database name: The code is as follows Copy Code 1. RENAME DATABASE db_name to New_db_name This one.. This syntax is added to the MySQL 5.1.7, 5.1.23 and removed.It is said that it is

Apache|mysql used to microsft things, people also become more and more lazy:-) but still want Microsoft not to fall ~ ~, what new software package to get the first is can't wait to the CD-ROM drive inside a plug, if it can automatically run (Hey,

Original: https://my.oschina.net/waknow/blog/205654Summary: When using the Go link database, too many connections errors occur after a period of time due to improper connection release. Therefore, appropriate selection functions and timely release

1. Online DDLIn MySQL 5.1 (with InnoDB Plugin) and 5.5, a new feature called Fast Index Creation (FIC), is to add or remove the two-level index , you can not copy the original table. For the previous version of the addition of the index to remove

One: Field modifier1:null and NOT NULL modifiersLet's take a look at this example.Mysql> CREATE TABLE worker (ID int not null,name varchar (8) Not null,pass varchar (a) not null);Mysql> INSERT into worker values (1, ' HA ', ' 123456 ');Mysql> INSERT

First, MySQL gets the current date time function1.1 Get the current date + time (date + times) function: Now ()Mysql> Select Now ();+---------------------+| Now () |+---------------------+| 2008-08-08 22:20:46 |+---------------------+In addition to

The 14th chapter of Scalable Design data segmentationPrefaceThe extension implemented by MySQL Replication functionality is always limited by the size of the database, and once the database is too large, especially if it is too frequent to be

Click here for the originalDirectory Install Introduction Contributors Sponsors Community Establishing connections Connection Options SSL Options Terminating connections Pooling connections Pool Options Pool Events

Original address: HTTP://WWW.TUICOOL.COM/ARTICLES/RZRNQ2Xtrabackup 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

Read-Write separation (Read/write splitting).1. Principle:Allows the primary database (master) to handle transactional increment, change, delete operations (INSERT, UPDATE, delete), and select query operations from the database (slave).2. Advantages:

One, the MySQL bin directory has a MySQLInstanceConfig.exe, run can create a DB instance, create an instance can also generate Windows service, set the service to start automaticallysecond, installed in the D-disk discuzz! opened after the above

The most general way to satisfy the GROUP BY clause is to scan the entire table and create a new temporary table, all rows of each group in the table should be contiguous, and then use the temporary table to locate the group and apply the cumulative

Here is an example of using a date function. The following query selects records for all Date_col values within the last 30 days.Mysql> SELECT something from Tbl_nameWHERE To_days (now ()) –to_days (date_col) DAYOFWEEK (date)Returns the week index

1. Update the system kernel to the latest version. [Root @ linuxfei ~] # Yum-y update After the system is updated, if an error message is prompted during Yum installation, run the following command to fix the problem. [Root @ linuxfei ~] #

The program code of the number of online users of the website, which is supported by the MySQL (the best combination with PHP) database in the background. You can directly count the number of online users of the website. First, create a MySQL

MySQLIs the most famous dynamic website developmentOpen SourceDatabase System. If you use MySQL on your website, you should regularly back up your data to prevent it from being lost. This article will introduce 10 tutorials on automatic or manual

Snort: Barnyard2 + MySQL + BASE based on Ubuntu 14.04 SNORT and snortbarnyard2 First, it is clear that the operating system platform is Ubuntu 14.04 LTS Now we need to deploy snort NIDS (Intrusion Detection System) on Ubuntu 14.04 ). These things

View mysql stored procedure details and view mysql Stored Procedure Stored ProcedureIn this way, we can encapsulate SQL statements that require special processing into functions. When necessary, we only need to call this function to implement the

MySQL row-level locks, table-level locks, page-level locks, mysql details Page Level: Engine BDB. Table-level: Engine MyISAM, which is interpreted as locking the entire table. It can be read at the same time but cannot be written at the row level.