MySQL

1. Install dependent packages[email protected] mysql-5.1.50]# yum-y install gcc gcc-c++ ncurses ncurses-devel OpenSSL openssl-devel libtool*2. Create User[[email protected] mysql-5.1.50]# Groupadd MySQL[Email protected] mysql-5.1.50]# useradd

MySQL compiles the installation from the 5.5 release CMake, not the previous make, so install the CMake and install all of the development pack groups properly:1. Prepare the installation environment first:#cmake:

1. Download Mysql5.6.10ga decompression version, this is not much to say also no, under or under the good after not know how to decompress the next article is not much to see.2. After the decompression into the root directory is such a situation (I

1, first download the MySQL database, I installed the mysql5.1 version, directly installed on the line, but if you want to display in the database in Chinese, you want to set the character set to gb23122. Configure Data source ODBC.

Because MySQL does not support working on a table at the same time, the subquery and the action to be performed cannot be the same table, so you need to pass the temporary table below.1. Repetition of single-word fieldsGenerates a temporary table

1. Obtained by the self-increment key auto_increment.[SQL]View Plaincopy Select max (ID) from tablename This approach requires consideration of concurrency and the need to "X-lock" the primary table in a transaction, and then unlock

Errors encountered while making configuration from the server.mysql> Change Master to master_host= ' 192.168.136.129 ', master_user= ' repl ', master_password= ' 123456 ', Master_log_ File= ' mysql-bin.000003 ', master_log_pos=2610;ERROR 1201 (HY000)

MySQL There are several common reasons for starting an error:1 , the data area is full2 , PID directory MySQL user does not have write permission3 , the storage engine is the InnoDB engine, and this time it will need to restore all operations

Basically, there are 3 ways to represent an inheritance relationship in SQL.respectively, 1 table Inheritance (TPH), 2 table Inheritance (TPC), 3 table Inheritance (TPT)1 table:PersonID Type name Classroom office1 student Keat 1 b NULL2 teacher

Learning Purpose: Understanding MySQL the difference between the three different installation methodsLearning content: There are three types of MySQL installations: source installation, binary installation,rpm installation, respectively.

1-1 settings//dataannotation 1-1 | 1-0 table//Sqltable:member, Columns:memberid, name//SQL Basic Logic:1 table PK is another table PK and FK, which is the relationship between 1-1 and 1-0[Table ("member")] Public classMember {[Key] PublicInt32

Environment: mysql5.5, Engine Innodb,sqlyogrow lock, table lock difference: In fact, is to see where the conditions are indexed, when there is an index is a row of locks, no index when it is a form of cable. Create the table structure first:CREATE

To create a data table: Code:Create Table table name (Field 1 [ column-level constraint ] [ default ], field 2 [ column-level constraints ] [ default ], ... [ table-level constraints ] );Attention:1. Table names are case

Database Migration DocumentationFirst, the demandEnsure that the database is running stably, providing developers with a convenient test database and production database environment.Second, the overall structure of the database (Master/slave)Third,

Installation: RPM Packagewget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-server-5.5.27-1.linux2.6.i386.rpmwget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-client-5.5.27-1.linux2.6.i386.rpmRPM–IVH mysql-server-5.5.27-1.linux2.6.i386.rpmRPM–IVH

First, define a stored procedure in MySQL: Delimiter//create procedure proc () begin SELECT * from users;end//then, in PHP,//declares a storage space used to store procedure execution return data , the space size 131072 is 128Kdefine

Preface: In the creation of the database, there will be an option, such as collation, usually in the creation of the database and did not pay attention to, but chose the default, and did not feel any problems, today to see this sudden curiosity, so

In Linux, the default installation path of Apache PHP Mysql is apachemysql. ApacheIf the RPM package is used for installation, the installation path should be in the/etc/httpd directory.Apache configuration file:/etc/httpd/conf/httpd. confApache

Tinyint data type in mysql The mysql database defines the data type as "data type (m: Here, the number m represents different meanings in different data types. The integer system has limited the value range. For example, tinyint occupies one byte

Mysqlsql Statement Review 1 Search the list without the same value and add the DISTINCT keyword. Select distinct vend_id FROM products; You can use the LIMIT clause to LIMIT the number of returned results. SELECT prod_name FROM products LIMIT 5; The