To view the compilation parameters of the Nginx service/application/nginx/sbin/nginx-v[Email protected] ~]#/application/nginx/sbin/nginx-vNginx version:nginx/1.2.1Built by GCC 4.1.2 20080704 (Red Hat 4.1.2-52)Configure
Set character sets when creating databases and tables to avoid garbled Chinese methods:Create a databaseCREATE DATABASE test CHARACTER SET UTF8 COLLATE utf8_general_ci;--Note that there is an underscore between the following three wordsThe value
I almost did not write a blog, feel the knowledge to learn and to do too many things, no time. But found that the blog record their learning experience is very good, take time to write points for their future reference also share to some people, I
Original: MySQL Partitioning technologyThere are two main types of optimizations for massive data:the way of large table splitting table; optimization of SQL statements Partitioning Technology:similar to horizontal segmentation, but it is a
There are two main types of optimizations for massive data:the way of large table splitting table; optimization of SQL statements Partitioning Technology:similar to horizontal segmentation, but it is a horizontal table at the logical level, which is
How to improve the performance of replication:Delay:For MySQL replication, in the absence of a failure, the master and slave data are out of sync, and the delay is divided into the following two scenarios:Recurrent delay: The data gap between
1. Installing Cmake:sudo apt-get Install CMake2. Installing MySQL5.5A) Download: sudo wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.40.tar.gzb) Unzip and enter the directory: sudo tar zxvf mysql-5.5.40.tar.gz && CD mysql-5.5.40c) Compile
SELECT * from ' DD ' ORDER by ELT (INTERVAL (CONV (HEX () (Num USING gbk), 1), 16,10),0xb0a1,0xb0c5,0xb2c1,0xb4ee,0xb6ea,0xb7a2,0xb8c1,0xb9fe,0xbbf7,0xbfa6,0xc0ac,0xc2e8,0xc4c3,0xc5b6,0xc5be,0xc6da,0xc8bb,0xc8f6,0XCBFA,0XCDDA,0XCEF4,0XD1B9,0XD4D1),'
Use the following function to make a fuzzy query, if the occurrence of the position >0, indicates that the string is contained.Query efficiency is higher than like.Such as:Table.field like '%aaa% ' can be changed to locate (' AAA ', Table.field) > 0
Data query one, single-table query 1, inSelectstatement, use the*"indicates that all fields are queriedFirst of all:Create a table because the testCREATE TABLE student (ID int primary KEY not null,name varchar (), sex varchar (4), class varchar (10))
Work with statistics December call records, statistics number dialed number, but the problem in a number can be dialed multiple times, each may or may not be connected, if the call Number Caller field group by group COUNT (*) after the number of
Recently encountered a problem with EF for MySQL in your project1 Publicordermanage getorders (ordersearchcriteria criteria)2 {3 using(vardb =Newdbentities ())4 {5 varItems =db.order.AsQueryable ();6 if(!string.
Mysql stored procedures dynamically Execute SQL statements, mysqlsql
Previously, we often concatenate SQL statements in the program. In fact, we can also splice SQL statements in the storage process for dynamic execution ~~
The Code is as
How to Set pseudo-static rules through web. config in IIS 7.5
In is7.5, common programs use web. config to create a pseudo-static file named after web. config.
Remember to enable the pseudo-static feature in the background.
The following is an
MySQL function GROUP_CONCAT, mysqlgroup_concat
This function returns a string with a non-NULL value from a group of connections. This function is an enhanced basic LIST () function supported by Sybase SQL Anywhere.
Syntax
MySQL (10)-date functionsDate and Time Functions (1) functions for obtaining the current date and time
CURDATE () and CURRENT_DATE () functions to obtain the current date
Select current_date (), curdate (), curdate () + 0;
Curdate () + 0 indicates
Introduction to mysqlnd Extension
MySQL Native Driver (mysqlnd) is introduced as a substitute for libmysqlclient in PHP5.3.0. Previously, MySQL database extensions mysql, mysqli, and pdo mysql All communicate with MySQL Server through
Solution to 1366 errors in mysql
Recently, I made a project for the school. oracle is used for the database. If oracle is installed in windows, it is relatively simple, but unfortunately, before I took over the project, I just switched to Mac, so
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service