MySQL

Brief introduction to the underlying statement:1. Description: Create DATABASECREATE DATABASE Database-name2. Description: Delete DatabaseDrop Database dbname3. Description: Back up SQL Server---to create a device that backs up dataUse masterEXEC sp_

Recursive querying of tables stored in a tree structure, using navicat for MySQL to create stored procedures Pro_show_knowledge, Parameters-in ' rootid ' int, querying all child node data through a knowledge point and inserting it into a temporary

The data types in the MySQL Create statement include the time type, with a few categories:| DATE | time[( fsp )] | timestamp[( fsp )] | datetime[( fsp )] | YearOf these types, what is particularly noteworthy is what is the difference between

#表 ( jc_shop_product ) has a status value-whether the shelves (On_sale) to shelves (0) into the shelf (1) and set the shelf time (on_sale_time) Drop trigger if exists update_on_sale_time_of_product;delimiter//CREATE trigger

MySQL binary log is often said to be the Bin-log, is the MySQL implementation of the changes produced by the binary logging file, its main role is two:* Data Recovery* Master-slave database. For the slave side to perform additions and deletions to

Stored routines (procedures and functions) can be particularly useful in certain situations: When multiple client applications is written in different languages or work on different platforms, but need to perform t He same database operations.

MySQL installation files are divided into two types, one in MSI format and one in ZIP format. If the MSI format can be directly clicked on the installation, according to the installation prompts it to install (I believe you can read English tips),

MySQL Apache php rpm installation procedure under Linux1. Install the CD-ROM with the httpd-2.2.3-5.i386.rpm This package, is Apache, if prompted to install the process of what other packages, look at the hint loaded on.2. Then install the CD-ROM

1. Introduction to Basic Environment 1.1 software environmentOperating system: Redhat Linux 6.3MySQL version: MySQL 5.6.241.2 Disk directory Planning Serial number Directory Use 1 /opt/mysql/mysql-5.6.24

1, after installing MySQL on Linux, there are a lot of MySQL related files.2,/etc/rc.d/init.d/mysql is the MySQL service startup script, is the Mysqld_safe package, Mysqld_safe is a script, is the executable file mysqld encapsulation3,/usr/bin/mysql

I. Index optimizationRange matching using B-tree indexEquivalence match using hash index, hash all unique memory engine2. Index Samsung System,1. Related Records put together2. The data in the index and the sort order in the lookup have been3. The

MySQL date type and millisecond value conversion Sometimes the date type value needs to be converted to the millisecond value, and sometimes the millisecond value needs to be converted to the date, for more convenience, meet the Query Needs.

Use codeblocks to debug mysqlCodeblocks debugging mysql environment setup 1.decompress mysql-5.6.23.zip to the user root directory ~ /2. In the user root directory ~ /, Create a Folder build and mysql3. open codeblocks, create an empty project,

Mysql Data Type Data Type 1. The calculation principle of signed numbers is as follows: tinyint occupies 1 byte, that is, 8 bits:-2 to the power of 7 =-128 ~ Power 7 of 2-1 = 127 tinyint occupies 1 byte unsigned value range: 0 ~ 255, with the value

MySQL obtains all the date points of a month.1. Problems As the title says, use MySQL to get all the days of a month in a certain year. For example, obtain all dates of January 1, February 2014. 2. handling process 2.1 create a digital auxiliary

MySQL database Triggers 1. Trigger with only one row of statements executed Trigger triggers are events that trigger certain operations, such as insert, delete, and update.   For example: create trigger t_user_trig before inserton t_user for each

Mysql carpet-based learning (1)-Brief introduction to the overall Mysql Architecture Recently, I feel that my skills have been learned along with my work, and I feel that I have never mastered some knowledge, I plan to systematically study the notes

Mysql sets the default database EncodingIf the encoding method is not selected during mysql installation, the system selects latin1 encoding by default, in the mysql Console window, enter show variables like 'Char % 'to view the default sequence set

Atitit. process standardization-Summary of the troubleshooting process attilax when mysql cannot be started Atitit. process standardization-Summary of the troubleshooting process attilax when mysql cannot be started 1. mysql startup Log File 1 2.

Mysql architecture Arrangement MySQL is composed of data files and database instances. It is a single-process, multi-thread architecture.Database Files: a collection of physical operating system files or other files. In mysql, database files can