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

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

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

Select t.student_id, T4.name, T5.name, Ifnull (T6.name, "")From Student_info tLeft join Student_type t1 in t.student_id=t1.student_id and T1.level=0 left joins student_type_info T4 on T1.type_id=t4.idLeft join Student_type T2 in

The first time so close to contact the source code, a little excited, and a little overwhelmed, a lot of the source files are thousands of lines, you say how to see, there are some countless data structures, functions, classes and other messy things.

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

Because an object is returned.var selectsql1= "select * from Spc_word_mst where word_id=? Limit 0,1 "var selectsql2= "select * from Spc_baitai_mst where baitai_id=? Limit 0,1 "Spc_result_jhvar insertsql= "insert into";var key1= ' 001 ';var key2= ' 00

A beginner of PHP's accompanying notes, record their growth!I. Databases (database DB)1. Database: Warehouse where data is stored2. Database classification:(1) Relational database: two-dimensional table storage data (MYSQL,SQLSERVER,ORCALE,DB2, etc.)

performed under Ubuntu sudo apt-get instlll mysql-serversudoinstall mysql-clientThere will be a text interface setting password during installation.Remember the passwordMySQL graphical tool Green Edition recommendedMysql

Reprint: http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.htmlMySQL installation directory (Ubuntu system)Database directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/

MySQL Slow query1, slow query role?It records all SQL statements that execute more than long_query_time time, helping you to find SQL that executes slowly, so we can optimize these SQL statements.2, how to open the slow query?First we check if the

Mysql5.6window Ultra-detailed installation tutorials 2015-06-23 0 Comments Source: Lin Bingwen Evankaka's Column collection I want to contribute First, the installation package preparation 1

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.