MySQL

To install the related package:cd/home/oldboy/tools/Rz-yTar XF cmake-2.8.8.tar.gzCD cmaake-2.8.8./configureGmakeGmake InstallCd..Dependent Packages:Yum Install Ncurses-devel-yStart installing MySQLCreate users and GroupsGroupadd MySQLUseradd mysql-s/

User ManagementPractical application:MySQL database is a very important part of the information system, the default is a root user, but this user rights are too large, usually only in the management of the database. Therefore, the administrator

Recently learned about the use of MySQL data implementation of the principle of the active structure, in the previous concurrent access to a low scene, generally a high performance of the server as a MySQL data, can meet the business of add and

Database naming rules:Create Select cannot use numbers up to 128 bits maximum # Basically, it's like a python or JS naming convention.the SQL language is primarily used to access data, query data, update data, and manage relational database systems,

The operation of the database user is done in the MySQL library, so you need to go to the MySQL library to see the users and addresses in the database.Here are two ways to create a user's password at the same time, the difference is the second we

Description:Database, there must be no more statements. In the database, the data is stored in a uniform format as a "record". Mainly has the following characteristics:1, can be structured to store a large amount of data information, convenient for

Date_format: Time function for formatting MySQL date,datetime,timestamp, Times, YearFrom_unixtime: You can use this function to convert if the field type that holds the timestamp is int or another type, such as: From_unixtime (Create_time, '%y-%m-

Description:In a production environment, the security of data is critical, and any loss of data can have serious consequences. Therefore, it is important to back up data and restore data. Here are some things to do with backup and restore of data. ..

The following is the most basic MySQL additions and deletions to the statement, create an index, delete the index, view the index. The Association of tables in the database. Many IT workers have to command, but also the IT industry interview the

1 Basic Introduction to DML language 1.1 DML language DML language, data manipulation language. Classification of 1.2 DML languages Inserting: Insert Updated: Update Remove: Delete 2 INSERT statement 2.1 syntax

The concept of a databaseDatabase ( DATABASE,DB) is an organized, shared, and centrally managed collection of data that is stored in a computer for a long time. She is a computer software system that stores and manages data in accordance with the

1. Connect to MySQL. Command format: mysql-h host address-u user name-P user password. For examplemysql -h 10.110.15.120 -u root -p 123***2. Change the password. Command format: Mysqladmin-u username-P old password-password new password.

There are times when data collation needs to be specified for its own rules, such as 1>3>2>0, so you need to specify the collation when fetching data, as follows:SELECT ' user ' from the user WHERE ' User_status ' in (0,1,2,3) ORDER by FIELD (' User_

INT (m), M is the tube of what use?As an extension to the Ansi/iso SQL92 standard, MySQL also supports the integer types TINYINT, Mediumint, and BIGINT listed in the table above. Another extension is that MySQL supports arbitrarily specifying a

1. Numeric type1. Integral type1, int large integer (4 bytes)Value range: 0 ~ (2**32-1 (more than 4.2 billion))2, tinyint micro-integer (1 bytes)1, signed (signed default):-128 ~ 1272, unsigned (unsigned): 0 ~ 255Example: Age tinyint unsigned,3,

an index base1. Definition:In MySQL, the index is also called "Key", which is a data structure used by the storage engine to quickly find records, which can improve query efficiency.The most effective means of optimizing query performance is index

MySQL indexing is important to the efficient operation of MySQL, the index can greatly improve the retrieval speed of MySQL, database index is like a book full directory. Index divided into 5 categories Normal index, which is the most basic

Database additions and deletions changeCreate a databaseCreate Database School;Create a tableCREATE table info (ID int not NULL PRIMARY key Auto_increment,name char (TEN) notNull,score Decimal (5,2), hobby int (2));#primary Key PRIMARY key

First, Linux1, Linux to a file in bulk add a contentFirst vim into the file, then press CTRL + V and then select the number of lines you want, write what you're adding in Shift+i and then press ESCTwo, MySQL1, linux into the MySQL command line

1. Cartesian productselect * from emp,dep; select * from emp,dep where emp.dep_id = dep.id;select * from emp,dep where emp.dep_id = dep.id and dep.name = "技术";2, within the connection: only two tables have a corresponding record of the