MySQL

For example:There is an article table with a Type field, which stores the article type, there are 1 headlines, 2 recommendations, 3 hotspots, 4 graphics ... 1,12,13 and so on.Now there is an article he is a headline, but also hot, or graphic,The

Apache:If using RPM package installation, the installation path should be in the /etc/httpd directoryApache configuration file:/etc/httpd/conf/httpd.confApache module path:/usr/sbin/apachectlWeb directory:/var/www/htmlIf the source code is installed,

Get a test sheet to illustrate the difference.CREATE TABLE ' test ' ( ' id ' int (8) NOT NULL auto_increment, ' name ' varchar (255) is not NULL, ' list ' varchar (255) N OT NULL, PRIMARY KEY (' id ')) INSERT INTO ' Test ' VALUES (1, ' name ', '

Recently I have been doing the Order class project, using the transaction. Our database chooses MySQL, the storage engine chooses the INNODB,INNODB to have the good support to the transaction. In this article, we're going to pick up a piece of

1. Integral type MySQL data type Meaning (Signed) tinyint (m) 1 byte range ( -128~127) smallint (m) 2 byte range ( -32768~32767) Mediumint (M) 3 byte range ( -8388608~83

SummaryWhen I installed MySQL, I encountered some problems and listed the problems.Yum List Mysql-serverThe problem encountered when installing MySQL with the command yum list mysql-server.Probably the meaning Yum was locked by an application.At

Recently encountered in the work of the database server generated a lot of read and write queue problems, and asked everyone to start optimizing our SQL statements.The following is the SQL statement that queries the Code field in the

The 5.7 version of MySQL has a slightly different installation than the previous version, which recordsClick here to download to MySQL and unzip it to a folderand modify the My-default.ini file, as follows:Then create an empty data folder under the

First, the decompression version1, download the decompression MySQL file http://www.mysql.com/official website provides, own find2, unzip to the corresponding directory D:\mysql3. Append D:\mysql\bin address after setting path directory in system

#!/bin/bashDpath= "/mysql_backup" mydays= "7" username= "root" mysql_pwd= "Redhat" xmysql= "/application/mysql/bin/mysql-u$ USERNAME-P${MYSQL_PWD} "xmysqldump="/application/mysql/bin/mysqldump-u$username-p${mysql_pwd} "today= ' Date +%Y%m% d '

In MySQL, varchar and char types must specify the length, and the int type does not need to be specified.For exampleSET NAMES UTF8;DROP TABLE IF EXISTS ' Content_Type ';CREATE TABLE ' Content_Type ' (' ID ' BIGINT not NULL auto_increment,' Name '

Demand1) A project can be handled by multiple employees2) A worker can take charge of multiple projects3) Employee's salary shall be determined by job---------------------------------------------------------------------------Working hour table for

Environment: HE3 Main Library, HE1 from the libraryhe1:192.168.1.248he3:192.168.1.250from the library my.cnf Add the following parameters and restart the database:Read_only=1Log_slave_updates=1 (it is recommended to open, from the library record

1. What is a view?A view is a virtual table formed by the results of a query.2. When should I use the view?If a query result occurs very frequently, that is, you should always take this query result to make subqueries3. Creation syntax for

MySQL's varchar fields are sorted by numberToday, I encountered a question about sorting, when a table was built, and the wide fields in the table were stored with varchar, because the unit might be stored so it was not stored in Int. But later

MySQL Query record if there is a timestamp field, the view results inconvenient, can not immediately see the meaning of the timestamp represents, now provides the MySQL format change time function, you can easily see the time after the format.1. The

How to install MySQL database, do not say here, just say its master-slave copy, the steps are as follows:1, the master-slave server for the following actions：1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3,

How to install MySQL database, do not say here, just say its master-slave copy, the steps are as follows:1, the master-slave server for the following actions:1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3,

For analysis of group by two or more conditions, groupbyAnalysis of group by two or more conditions     Address: http://uule.iteye.com/blog/1569262 Blog type:  Database   First, a simple description of group: Group by is

SQL --- Chapter01 database and SQL, SQL --- chapter01sqlDatabase Type: Hierarchical Database (HDB) Data is displayed in a hierarchical structure (tree structure. Relational Database (RDB) Use a special Structured Query Language (Structured