SQL between and Range Operations
You can define between keywords in various forms of predicates. If the column value in a row belongs to this range, the predicate is true, which is described in the result table. The test range is between two
If this record exists in a mysql tutorial, it is updated. If this record does not exist, the SQL statement of the record is inserted.
INSERT table (auto_id, auto_name) values (1, 'yourname') on duplicate key update auto_name = 'yourname'
ON
Mysql tutorial php tutorial Add a column alter table to the TABLE dynamically The mysql statement for adding columns is Alter table tableName add column columnName varchar (20) not null */ // Database tutorial connection method$ Db = '111cnnet ';$
MySQL query cache query_cache_size
MySQL server has an important feature since MySQL 4.0.1: Query Cache. In use, the query cache stores the text of a SELECT query and the results sent to the client. If the same query is received later, the server
SQL distinct
SQL distinct usage
You can use the DISTINCT keyword to remove rows with duplicate query results. Different queries are very useful. You just want to know whether a value table exists and you are not interested in how many times.
Mysql Optimization Configuration
Tmp_table_size: 500 mb
Key_buffer_size = 384 m // key_buffer_size specifies the buffer size used for the index. increase it to get more
Good Index processing performance. This parameter can be set to 384 M or M for
Mysql fuzzy query
Variables in double quotation marks are automatically parsed.$ SQL = "SELECT * FROM oneself WHERE name like '% {$ colname_Recordset1}' LIMIT {$ startRow_Recordset1}, {$ maxRows_Recordset1 }";$ Recordset1 = mysql_qu
Variables in
Create an indexIndexes are especially important for applications where queries account for the majority. In many cases, the performance problem is very simple because we forget to add an index, or we have not added a more effective index. If you do
DELETE statementThe DELETE statement is used to DELETE rows in a table.
SyntaxDelete from table name WHERE column name = value Person:LastName FirstName Address CityGates Bill Xuanwumen 10 BeijingWilson Fred Zhongshan 23 NanjingDelete a row"Fred
The following list shows the order of operator priorities from low to high. Operators in the same row have the same priority.
Operator priorityThe following list shows the order of operator priority from low to high. Operators in the same row have
Differences between mysql table types MyISAM and InnoDB
Differences between mysql table types MyISAM and InnoDB
MyISAM: This is the default type. It is based on the traditional ISAM type, and ISAM is the abbreviation of Indexed Sequential Access
Mysql database program optimization method1. select the most suitable field attribute
MySQL can support access to large data volumes, but generally, the smaller the table in the database, the faster the query will be executed on it. Therefore, when
SQL LEN () function example tutorial
In the LEN () functionThe length value returned by the LEN () function is in the text field.Database LEN () syntax
SELECT LEN(column_name) FROM table_name
Here is an example.
Id
LastName
SQL getting started Tutorial: SQL ROUND () instance tutorial
Round () functionThe round () function is used to specify Decimals in a numerical field.Database round () syntax
SELECT ROUND(column_name,decimals) FROM table_name
Let's take a look at the
SQL MID () Example tutorial
Mid () functionThe mid () function is used to extract text fields of characters.Database mid () syntax
SELECT MID(column_name,start[,length]) FROM table_name
Parameter
Description
column_name
The MySQL database does not have its own. On the contrary, MySQL databases are a group of tables that are organized. If you create many different tables and share a common topic, you will combine them into a database to make the management process
I have never noticed how to use mysql full-text search to query instance data. I wrote a search function for a friend today, starting with %? After half a day, the full-text search of fulltext is not ideal. Let's look at a simple example.
I have
WHERE clause of MySQL in PHP
The WHERE clause is used to filter records.WHERE clauseThe WHERE clause is used to extract only those records and complete the specified criteria.Syntax
SELECT column_name (s) FROM table_nameWHERE column_name operator
As the company's website traffic grows, MySQL naturally becomes a bottleneck. Therefore, I have been studying MySQL optimization recently. The first step is to naturally think of MySQL system parameter optimization, as a database system for a
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