MySQL

Written in front, the younger brother first use the blog to record a little bit of knowledge on the road, which may have a personal understanding of the error, or do not understand the place. Hope you Daniel correct guidance, younger brother

80% refer to the article Fedora 20 under MySQL installation, Linux commune http://www.linuxidc.com/Linux/2014-02/96392.htm The main commands are Root privileges download, install,sudo yum-y install Community-mysql-serverwill be asked to

"Environment and file version"Red hat linux v6.2MySQL linux version x86-x64 v5.6 "Prepare the required documents"first go to the official website to download MySQL of the Linux version, you can select the appropriate version for the installed

MyISAM is a non-transactional storage engine, and InnoDB is a storage engine that supports transactions. The InnoDB engine is more suitable for applications where insert and update operations are more useful, while MyISAM is suitable for

This configuration method applies to the version after 5.1, the individual is successfully configured on 5.5 (prior to 5.1, please refer to the additional configuration instructions)Environment

A where subquery is the result of an inner query as a comparison condition for the outer layer of SQL.Select goods_id, goods_name from goods where goods_id = (select Max (goods_id) from goods);The inner query is select MAX (goods_id) from goodsThe

MySQL Default has a root user, but this user rights are too large, generally only in the management of the database when used. If you are connecting to a MySQL database in your project, it is recommended that you create a new user with a smaller

The Format expression field description for the From_unixtime function in MySQL:%M month name (January ... December)%W week name (Sunday ... Saturday)%d The date of the month with English prefixes (1st, 2nd, 3rd, etc.). )%Y year, number, 4-digit%Y

Sometimes we want to see all the information of a database above some kind of element (such as table name), we can see it very conveniently on MySQL by introducing Information_schema way.Add stepEdit->preferences then select SQL Editor hook in Show

Uninstall for MySQL under Windows:Ways to completely uninstall MySQL:(1), first stop the MySQL service in the service (start-up---control panel-----services). Open Control Panel-Add Remove Programs, find MySQL, uninstall.(2) Uninstall the installed

1, query The database show databases;2, query the database table show TABLES; Show TABLES from db;3, query table Index Show index from table4, query table column show [full] COLUMNS from tb1 from Db_test; Show [Full] COLUMNS

1: Delete ColumnsALTER table "table name" DROP "column name"2: Add columnsALTER table "table name" ADD "column name" INT not NULL COMMENT ' comment description '3: Modify the column type informationALTER table "table name" Change "column Name" "New

Getting started with mysqlenterprisebackup **************************************** * ********************** -- 1. full backup *************************************** * ******************** # mysqlbackup -- defaults-file =/usr/local/mysql/my. cnf \ -

MySQL is case insensitive in Linux.MySQL in Linux Database Name, table name, column name, alias case-sensitive rules:1. The database name and table name are case sensitive.2. The table alias is case sensitive.3. The column name and column alias are

2015.4.2SQL simple statement, 2015.4.2sql statement 1. create a student table create table student_masen (sno char (4) not null primarykey sname nchar (10) not null sex char (1) null check ('M', 'F ') age smallint null check (age> 15 and age 2.

Mysql date and time processing functions ADDDATE (date, interval expr unit), ADDDATE (expr, days) --- add the time value (Time Zone) as the date value, which is the alias of DATE_ADD () DATA_ADD (date, INTERVAL expr unit), DATE_SUB (date,

Mysql comparison functions and operators, mysql function Operators Comparison functions and operators in MYSQL: 1. [NOT] BETWEEN... AND... Check whether a value is within a range of values Note: expr between min and maxIf expr is greater than or

Mysql creates a table based on the query results Assume that three tables exist. S (sno, sname. sex, age, dept) // sno indicates the student's student ID, sname indicates the student's name, sex indicates the gender, age indicates the age, and

MySQL enables slow Query Mysql slow query logs are very useful for querying problematic tracing. You can analyze the resource-consuming SQL statements in the current program. This is a useful log. It has little impact on performance (assuming that

Mysql installation-free version configuration (sorting), mysql installation-free version sorting 1. Download the mysql installation-free version (extract version ). : http://dev.mysql.com/downloads/mysql/5.0.html 2. decompress the package to the