MySQL

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

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

Alter table syntax ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec...] Alter_specification:ADD [COLUMN] create_definition [FIRST | AFTER column_name]Or ADD [COLUMN] (create_definition, create_definition ,...)Or add index [index_name]

Mysql replace usage Yesterday, when I imported a piece of data, I thought about using update and replace in combination,Update tablename set fields = replace ('A', 'bb', str) where1. replaceReplace into table (id, name) values ('1', 'A'), ('2', 'bb

MySQL Stored Procedure ERROR Handler Exception Handling MySQL Stored Procedure ERROR Handler Exception HandlingExample: when insert fails, I want to record it in the log file, "" Here we need to create a primary key table and a foreign key table. We

MySQL Stored Procedure examples, including transactions, parameters, nested calls, cursors, loops, etc. MySQL Stored Procedure examples, including transactions, parameters, nested calls, cursors, loops, etc. Drop procedure if exists

SQL Group by and Having Before introducing the group by and HAVING clauses, we must first talk about a special function in SQL: aggregate function, such as SUM, COUNT, MAX, and AVG. The fundamental difference between these functions and other

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

/*** Output a table in the database to a CSV file.** @ Param string host of the Mysql database* @ Param string Database Name* @ Param string name of the table in the database* @ Param string connection username of the database* @ Param string

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

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

SQL JOIN keyword usage The JOIN keyword is used to query data from two or more tables. Some relations are listed in these tables.Database JOINKeyword connection uses SQL statements to query data from two or more tables, and some relationships are

SQL getting started Tutorial: SQL insert and update simple tutorial Let's talk about it first.SQL insertTutorial. The insert statement is used to insert a new record table.Insert a statementThe insert statement is used to insert a new column into a

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

Use the command line mode!Log on to the databaseMysql-h host name-u user name-p PasswordAfter that, do you know the encoding of the exported file? If it is GBKMysql> set names gbk;UTF8Mysql> set names utf8;If you do not know, try and the encoding is

We all know about insert into, but many may not know the specific usage of the Replace INTO statement, let me summarize their usage and differences. REPLACE runs like INSERT. There is only one exception. If an old record in the table has the same

Many of my friends may have encountered remote connection to mysql, or connection failure or slowness. Today I also met the following to share my solution to slow connection speed. I want to connect to the database on my colleague's machine. When

Replace () can directly replace and display data in mysql. If you check and update the replace data, we need to work with the update statement. Next I will introduce you to the operation method. Recently I changed the code highlighting plug-in of my

Importing and exporting data is a data backup for mysql. Next I will introduce how to use the mysql command to back up and restore the database when there is a large amount of data. I hope some methods will be helpful to you. In the face of large

In SQL grouping, we all use GROUP BY. For a single one, we can directly GROUP BY XXX. But how do we operate multiple fields, I will share with you some tips. In mysql statements, group by is easy to understand as group query.For example, select sum