MySQL

The parameters passed through queryMap of valuelist are of the string type by default. In hql of the valuelist configuration file, an error is returned if this value is directly assigned to an integer field. We generally use transformation functions

When using mysql, you sometimes need to query records with unique fields. Although mysql provides the keyword distinct to filter out redundant duplicate records, only one record is retained, but it is often used to return the number of records that

About 0.2 million of data insertion operations were encountered during work. After the program was compiled, it was found that the Operation timed out. The maximum PHP Execution time was modified to 600, or timed out. Check the number of data

DAYOFWEEK (date) Returns the index of the week of the date (1 = Sunday, 2 = Monday ,...... 7 = Saturday ). These index values correspond to the ODBC standard.Mysql> select DAYOFWEEK ('2017-02-03 ');-> 3 WEEKDAY (date)Returns the week index of date (0

When using mysql (show tables), you sometimes need to view the table and field information (whether the table and a field exist .)~~ PHP provides such related functions, such as mysql_list_dbs () and mysql_list_fields (), but the mysql_list_fields ()

An index is a structure created on a table that sorts values of one or more columns in a database table. The main function is to increase the query speed and reduce the performance overhead of the database system. Through the index, the query data

The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query results.The results of queries without indexes are as follows.

This article mainly describes the analysis and summary of time functions in SQLite and provides use cases. The examples given in this article are all tested.SQLite time/date function types:1. datetime (): Date and time of Generation2. date (): date

Identity () indicates that the value of this field increases by 1 every time a statement is inserted,SyntaxIDENTITY [(seed, increment)]ParametersSeedThe value (indicating the seed) used by the first row loaded to the table ).IncrementIncrement value,

MySQL has many storage engines. for different applications, you can select an appropriate storage engine for each table, which helps improve MySQL performance.Create a news table:Copy codeThe Code is as follows:Create table 'sandbox'. 'News'('Id'

The system information function is used to query the system information of the mysql database.VERSION () returns the database VERSION number.Copy codeThe Code is as follows:Mysql> select version ();+ ------------------------- +| VERSION () |+ -------

Create a triggerCreate a trigger with only one execution statementCopy codeThe Code is as follows:Create trigger name BEFORE | after trigger eventON Table name for each row execution statementThe trigger name parameter indicates the name of the

Join query connects two or more tables according to a certain condition and selects the required data. When different tables have fields of the same meaning, you can use these fields to connect these tables. Reference Table: employee Reference

To replace part of a field, use the update statement:UPDATE table name SET field name = REPLACE (REPLACE the previous field value, 'replace the previous keyword ', 'replace the previous keyword') WHERE field name REGEXP "REPLACE the previous field

Note: in mysql, ROW_COUNT () can return the number of rows affected by the previous SQL UPDATE, DELETE, and INSERT operations. MySQL test (database version: 5.1.22 ): 1. Create a database table:Copy codeThe Code is as follows:Create table t (Id

1. How to solve the problem of slow import of large batches of disordered data into InnoDB?Because of the primary key clustered index relationship, InnoDB is slower and slower to import without a primary key or non-sequence primary key. How can we

1. It may be that the/usr/local/mysql/data/rekfan. pid file has no write permission.Solution: grant permissions, execute "chown-R mysql: mysql/var/data" "chmod-R 755/usr/local/mysql/data", and then restart mysqld! 2. the mysql process may already

Previously thought from top to bottom unified use of UTF-8 on the rest of the peace of mind, which knows today in the capture of Sina Weibo data or encounter character exceptions.An exception is thrown when the data captured from Sina Weibo is

Create test tableCopy codeThe Code is as follows:Create table t(V VARCHAR (100) NOT NULL) Engine innodb default charset = utf8;Create a stored procedure for timer callsDELIMITER $Drop procedure if exists e_test $Create procedure e_test ()BEGINInsert

Mysql stored procedures are supported from version 5. Therefore, stored procedures are generally used. Today, I will share my understanding about the Mysql stored procedure.Some simple calls and syntax rules are not described here. There are many