PHP

Mysql character set and verification rules (Mysql collation) bitsCN.com Brief description Character set and verification rules Character set is a set of symbols and encoding. A collation is a set of rules used to compare characters in a character

MySQL: readinginitialcommunicationpacket one of the solutions to the problem bitsCN.com One solution:If an error occurs during Website access, check my. cnf: it is found that innodb_buffer_pool_size = 2048 M is too large and can be adjusted to

Example of MySql stored procedure exception handling code sharing bitsCN.com below is the sample code. When an exception occurs, it will save the exception information to the log table and continue to run the following statement. If you have better

Mytop uses the mysql real-time monitoring tool bitsCN. commytop, similar to the linux top tool, to monitor the performance information of the mysql server in real time. Installation method 1. install dependencies # Cpan # Cpan> install DBI #

BitsCN.com One: Declare @ s varchar (20) Declare @ I varchar (20) Set @ I ='' Set @ s = 'new members must purchase 350 yuan product' While PATINDEX ('% [0-9] %', @ s)> 0 Begin Set @ I = @ I + substring (@ s, PATINDEX ('% [0-9] %', @ s), 1) Set @ s =

ReplaceMYSQL character replacement function SQL statement sharing (regular expression judgment) bitsCN.com Update dede_addonsoft SET dxylink = REPLACE (dxylink, '.zip ', '.rar') where aid> 45553; Update 'Table _ name' set field =

Sharing bitsCN.com locks for fast insertion of large data volumes in MySQL and statement optimization will also reduce the overall time for multi-connection testing, although the maximum wait time for them to wait for locking will increase. For

Linux perl mysql database operations (need to install DBI) bitsCN. comDBI installation: DBI detailed information reference: http://dbi.perl.org/ 1. download the DBI package:Wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.620.tar.gz 2.

Description of the differences between utf8_unicode_ci and utf8_general_ci in Mysql: Currently, utf8_unicode_ci rules only support Unicode rules. Some characters are not supported. In addition, the combination of tags cannot be fully supported.

The method for rapidly inserting millions of test data in mysql is bitsCN.com. The first is to use the mysql stored procedure: Mysql> delimiter $ Mysql> set autocommit = 0 $ Mysql> create procedure test () Begin Declare I decimal (10) default

IP address processing functions inet_aton () and inet_ntoa () use instructions bitsCN. comMYSql IP address to int conversion functions Select inet_aton (ip) from table_name; Network address: 192.168.33.123 Each value does not exceed 255, that is,

Use the MySQL encryption function to protect sensitive data on the Web site. share bitsCN.com. if you are running a Web application that uses MySQL, it can store passwords or other sensitive information in applications. Protecting this data from

What is blob and how to configure the mysqlblob size is bitsCN. comBLOB is a large file. a typical BLOB is an image or sound file. due to their size, it must be processed in a special way (for example: upload, download, or store data in a database ).

Notes for installing and using MySQL on linux or unix servers BitsCN.com 1. how do I obtain the latest MySQL version? To install MySQL, you must first obtain the latest version of MySQL. although we all know that MySQL can be found in FreeBSD

The optimization of the MySQL joint index and Where clause improves the database operation efficiency. the bitsCN.com website system has been online so far, and the data volume reaches 500 mb, which is nearly records. Database operations are

If you want to test bitsCN.com locally using the SQL injection vulnerability, you can download it without points: Use the SQL injection vulnerability to drag the database Like the previous article, we need to create a data table and enter several

After you restore mysql to another machine, the following error occurs in mysql encoding: bitsCN.com: Warning at/admin/assets/add/ Incorrect string value: '/xE5/x93/x88/xD5/x92/x88...' for column 'name' at row 1 Request Method: POST Request URL:

Mysqlmysqldump: How to export only the table structure or data BitsCN. commysql mysqldump only exports the table structure and does not export data Mysqldump -- opt-d database name-u root-p> xxx. SQL Back up Database # Mysqldump database

Mysql string length calculation implementation code (gb2312 + utf8) bitsCN. comPHP's processing of Chinese strings has been plagued by new programmers who have just started PHP development. The following briefly analyzes how PHP processes the length

Mysql full-text search matchagainst usage bitsCN.com for large databases, load data to a TABLE without FULLTEXT indexes, and then use alter table (or create index) to CREATE an INDEX, this will be very fast. Loading data to a table with FULLTEXT