MySQL

First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x

MySQL is a relational database (relational databases Management System), this so-called "relational" can be understood as the concept of "table", a relational database consists of one or more tables, a table: header (header): The name of

PHP's mysqli extension provides all the features of its antecedent version, in addition, since MySQL is already aA database server with full features, which adds some new features to PHP. And Mysqli is supporting theThese new features.A Establish

MySQL database migration (data file Direct migration)There are three scenarios before the migration:1. Directly export the database, copy the file to the new server and import it on the new server.2. Use the Mysqlmigrationtool in MySQL GUI Tools.3.

Data Sheet A data table (or table) is one of the most important components of a database and is the foundation of other objects.First to solve the problem of entering database validation at the end of the last blog post:Verify which MySQL command is

MySQL's simple syntax, often used, is not easy to remember. Of course, these SQL syntaxes are basically common in each database. Listed below: 1. Add a field ALTER TABLE user add COLUMN new1 VARCHAR DEFAULT NULL; Add a field that defaults to null

Inserting data into a tableThe INSERT statement can be used to insert one or more rows of data into a database table, using the following general form:Insert [into] table name [(column name 1, column name 2, column name 3, ...)] VALUES (value 1,

MySQL storage engine (ii) MySQL Storage Engine II MEMORY MERGE BerkeleyDB Storage Engine MEMORY The memory storage engine creates a

Environment:Windows 2003/2007/2008/2010 X86method/Step:1. Download Mysql-5.6.17-win32; official website: http://dev.mysql.com/downloads/2. Extract to the custom directory, the demo address is D:\tools\mysql\3. Copy the My-default.ini under the root

Then on the previous blog, this time we initially learned about some of the constraints in MySQL database. Six auto-numbering auto_incrementFields that are automatically numbered must be combined with the primary key. By default, the starting value

#!/bin/shhost=192.168.5.30user=abccdefpw=123456msg= ' MYSQL-H$HOST-U$USER-P$PW This script is changed to a script to safely delete the MySQL two process log , MySQL master-slave synchronous database binary log is often very large, manually delete

when you insert a table a data, insert B table of data need to add corresponding to the corresponding field in a table of the self-increment, how will you get to the a table of self-increment? You may not know the self-increment in MySQL. four ways

Modifying a data table includes adding columns, deleting columns, adding constraints, deleting constraints, modifying column definitions, and modifying data table names, and the following two when we useBe cautious and try not to use it.Here is a

The previous article simply described the requirements for foreign key constraints, and did not tell you about the referential actions of foreign key constraints. This time I'll take a look at the update operation under the FOREIGN KEY constraint.

Way one: already obsolete1. Making a connection (establishing a channel)$db = mysql_connect ("localhost", "root", "123");2. Select which database to manipulatemysql_select_db ("MyDB", $db);3. Write SQL statements$sql = "SELECT * from Info";4.

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

Stitching FieldsThe data stored in a database table is generally not the format required by the application. We need data directly from 检索出转换、计算或格式化过 the database, rather than retrieving the data, and then reformatting it in the client application

Backups are the last line of defense for data security, and for any scenario where data is lost, backups may not necessarily restore a single amount of data (depending on the backup cycle), but at least minimize the loss. There are two important

MySql determines the specific functions of Chinese characters, dates, and numbers, and mysql Chinese Characters Several mysql functions are commonly used. The specific functions for MySql to judge Chinese characters, dates, and numbers are as

Mysql statement optimization and Mysql statement Optimization Index optimization, query optimization, query cache, server setting optimization, operating system and hardware optimization, application-level optimization (web server, cache), and so on.