MySQL

Run mysql on Mac. 1. Download the dmg installation package on the mysql official website. 2. After installation, the aliyun alias is www.2cto.com alias mysql =/usr/local/mysql/bin/mysqlaliasmysqladmin =/usr/local/mysql/bin/mysqladmin to create a

In linux, start the MYSQL server and configure the self-starting command/usr/local/mysql/bin/mysqld_safe -- user = mysql & note that the MYSQL installation directory www.2cto.com is configured for self-starting through vi/etc/rc. common local

The Mysql formatting date function DATE_FORMAT (date, format) formats the date or date and Time Value date based on the format string and returns the result string. Www.2cto.com DATE_FORMAT () to format the DATE or DATETIME value to obtain the

Mysql SQL Performance Optimization-order mysql's order will be affected by the amount of data selected during sorting. The more data columns, the slower the sorting. To illustrate this problem, see several examples. Low performance: select id,

On CentOS 6.2, MYSQL is installed using YUM because XAMPP does not support 64-bit, so I still install MYSQL myself. Use the default yum. Www.2cto.com [plain] yes | yum install mysql-server and then run [plain] service mysqld start. There will be the

MySql USER permission control this article describes how to CREATE and delete accounts in MySql, and how to set and introduce permissions of various accounts to create user accounts: www.2cto.com [SQL] CREATE USER user_name IDENTIFIED BY 'your _

Mysql merges the content of a certain field in the same table. mysql> create table t (id int, name varchar (20); Query OK, 0 rows affected (0.09 sec) www.2cto.com mysql> insert into t values (1, 'A'), (1, 'bb'), (2, 'cc'), (2, 'dd '); query OK, 4

MySQL Master/Slave separation master database configuration 1,/etc/my. cnf master database configuration # generally, www.2cto.com server-id = 1 # Database binlog-do-db = search # Database replicate-ignore-db = that does not need to be copied

Example of a MySql stored procedure: SQL code www.2cto.com CREATE DEFINER = 'root' @ '% 'Procedure 'proc _ calculate_combo_price' (IN 'comboid' VARCHAR (36), OUT 'price' DOUBLE, OUT 'reallyprice' DOUBLE) language SQL not deterministic contains SQL

How to import data to mysql is highly efficient. To import data to mysql databases, You need to import data to an Excel data file. First, you must construct the excel data file according to the corresponding table fields, convert it to the SQL

Mysql query data for this week, last week, this month, and last month SELECT name, submittime FROM enterprise where yearweek (date_format (submittime, '% Y-% m-% D') = YEARWEEK (now (); query the SELECT name, submittime FROM enterprise where

MYSQL obtains the auto-increment ID in four ways. select max (id) from tablename 2. the SELECT LAST_INSERT_ID () function LAST_INSERT_ID is irrelevant to table. If data is inserted to table a and then to table B, LAST_INSERT_ID changes. Max (id) is

Mysql string truncation function 1. Extract string left (str, length) from left. Description: left (truncated field, truncated length) Example: select left (content, 200) as abstract from my_content_t 2. Extract the right (str, length) string from

To monitor slow execution of Mysql statements, you must first enable the log_slow_queries authority for slow query output. You can set it in the MySQL configuration file (my. ini/my. cnf) or through the MySQL client. The advantage of the second

In redhat, MySQL master-slave backup is used as a Java programmer in a small company. In addition to coding, the backup is also very complicated. This time, I have the opportunity to access the master-slave backup of MySQL Data, in the past, the

The first n records of MySql query SQL Server use top to query the first n rows of data. The syntax rule is: SELECT TOP number | percent column_name (s) FROM table_name [SQL] select top number | percent column_name (s) FROM table_name while Mysql

Personalized settings MySQL prompt Interview 4 methods (I) modify the MYSQL_PS1 variable at the Bash layer [plain] [root @ localhost ~] # Export MYSQL_PS1 = "(\ u @ \ h) [\ d]>" [root @ localhost ~] # Mysql-u root-p Enter password: Welcome to the

Three major installation methods for MySQL 5.5: [binary, source code compilation, and RPM package] installation steps and advantages and disadvantages (I) source code compilation ① install cmake [plain] # wget http://www.cmake.org/files/v2.8/cmake-2.

MySQL: Basic Order by & Limit sub-clause 1. using basic 'order by 'java Code # order stu by stu_score as the Order of descendant select * from stu order by stu_score desc; 2. using 'ORDER BY' to order multiple columnsJava Code # order table 'std' by

MySql transaction trigger (Instance)1. Connection QueryUnion connects multiple select statements.Join query:When the expected results are no longer the same table, we need to use join queries.Syntax:A field in table1 join table2 on table1 = a field