WHERE condition
Sometimes when you manipulate a database, you manipulate only conditionally restricted data, and you can add a WHERE clause to the SQL statement to specify the conditions for the operation of the data.
Grammar:
Copy Code
Using the whole library replication scheme, easy to manage MySQL 5.5 + rhel5.810.4.11.12 Master10.4.11.13 slave---master-side settings1, create the replication account, need to copy and slave permissionsMysql> GRANT REPLICATION SLAVE, REPLICATION
the difference between 1,utf8_bin and Utf8_general_ci
CI is case insensitive, that is, "case-insensitive", A and a will be treated as the same in character judgments;
The bin is binary, and a and a will be treated differently.
For example you run:
First, the origin of the problem
There is a clear explanation in the official MySQL documentation that nested transactions are not supported:
Copy Code code as follows:
Transactions cannot be nested. This is a consequence of the
Resolves can ' t connect to MySQL server ' localhost ' (10048), commonly seen in Windows 2003 servers using MySQL.
Why the error occurred:
Applications need to quickly release and create new connections, but because the connections that exist in
JDBC believe that everyone is not unfamiliar, as long as it is a Java, first contact with the EE is to learn such things, who called the program and the database to deal with it! And JDBC is a database dealing with a very basic knowledge, but also
Tracking SQL under SQL Server uses Profiler, and how do you track sql under MySQL?In fact, the method is very simple, open the MySQL log logs function, by viewing the trace log can be.Open the MySQL log logging method:Configuration methods in the
How to recover after MySQL mistakenly deletes ibdata1
If you mistakenly delete the MySQL innodb related data file ibdata1 and log file ib_logfile* in the online server,How should it be recovered?
It's supposed to be a cold sweat, right?============
Today to the MySQL import data, the use of software is SQLyog, I believe that direct guide everyone will also be selected to select a table to import-import use of local CSV data can be, single sometimes do not know what problems import is not
A, Mysql SQL mode Introduction
In general, the MySQL server works in different SQL modes and can apply these patterns in different ways for different clients. This allows applications to tailor server operations to suit their needs. This type of
In a database table, indexing a field can greatly improve the query speed. If we create a mytable table:
Copy Code code as follows:
CREATE TABLE mytable (ID INT NOT NULL, username VARCHAR is not null);
We randomly inserted 10,000
We know that inserts support multiple statements when inserting more than one piece of data:
Copy Code code as follows:
INSERT into T_member (ID, name, email) VALUES
(1, ' Nick ', ' nick@126.com '),
(4, ' Angel ', ' angel@163.com '
Note: This document has two MySQL instances, multiple instance methods and so on
Linux operating system: centOS6.3 64bit (Installation of the system default development package)Database one:MySQL version: mysql-5.0.56port:3306System
Implementation principle: According to the change of the province value, through jquery to sf_id to the backstage php file processing, PHP through the query MySQL database, get the corresponding name of the city, and return JSON data to the
The example in this article describes how PHP uses the specified encoding to export MySQL data to a CSV file. Share to everyone for your reference. The implementation method is as follows:
I hope this article will help you with your PHP
In this paper, we analyze the problem that PHP queries the MySQL large amount of data to cause memory shortage. Share to everyone for your reference. The specific analysis is as follows:
I. Problems
When using PHP to query for large amounts of
This article summarizes the PHP random fetch MySQL record method. Share to everyone for your reference. The specific analysis is as follows:
In PHP to randomly fetch MySQL records we can directly use Mysql_query to execute the Select Rand function
Today, when I debug a set of PHP programs, some of the functions used in the program are not available in the lower version, so I can only get a high version of PHP.
As a web developer, it is sometimes necessary to install different versions of Php,
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