MySQL

Here the mysql version is selected as the mysql-5.1.41-win32.msi, installed in the C: \ MySQL directory.The following is the configuration of MYSQLl:Open the c: \ windows \ php. ini file;Search; extension = php_mysql.dll, remove ';Search; extension =

Copy codeThe Code is as follows:Select CONCAT ('drop table', table_name ,';')FROM information_schema.tablesWhere table_name LIKE 'dede _ % '; "Dede" is the prefix of the table to be deleted. After this SQL statement is executed, a series of SQL

The mysql official website began releasing various versions of the 5.6 series starting in May,. the mysql series versions have been comprehensively refined, the following is a sharing record of the mysql5.6.10 source code installation process

1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid using it in the where clause! = Or <> operator. Otherwise, the engine will discard the index for

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

# Path to installation directory. All paths are usually resolved relative to this.Basedir = "D: \ MySQL Server 5.1 /"# Path to the database rootDatadir = "D: \ MySQL Server 5.1/Data /" However, services are not generated because of no installation.

View the current connection system parameters: show variables like '% char % ';Mysql> show variables like 'Char % ';+ -------------------------- + ----------------| Variable_name | Value+ -------------------------- + ----------------|

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

Generally, the table has a Create date Field, and other databases have default options. MySQL also has the default value timestamp. However, in MySQL, the value of timestamp is updated even if it is inserted or modified! In this way, it is not the

When creating a foreign key in MySQL, an ERROR is prompted, but only the simple information is prompted: ERROR 1005 (HY000): Can't create table 'db _ qxztc. qx_userssssnew' (errno: 150 ). It cannot solve the problem at all. To view the detailed

MySQL Official Website: http://www.mysql.com/downloads/ There are several versions available on this download page. 1. MySQL Community Server Community version, open source free, but does not provide official technical support.2. MySQL Enterprise

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

Environment:PC: ubuntu 10.10 192.168.1.112 (master) 192.168.10.245 (slave)MySQL: 5.1.49-1ubuntu8. 1-logThe database test already exists in the master.First modify the mysql configuration file:/etc/mysql/my. cnf[Master]# Author: zhxiaCopy codeThe

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 ()

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

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

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

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