MySQL

[Email protected] ~]# ll/usr/local/|grep mysqllrwxrwxrwx. 1 root root June 01:52 MySQL--/alidata/server/mysql# This is a script-free installation environment (more complex)[Email protected]/]# tree/data//data/├──3307│└──data└──3308 └──data4

1, the normal situation.SELECT from Nt_mainnum2. Using the Group_concat functionSelect from Nt_mainnum3. Use Substring_index and Cross join to split the numbers inside the column.Method One (online Query method):Configuration table: CREATE

1. mysql master-slave principle and application scenario MySQL's replication principle is very simple, summed up:Only one master can be set from each.After the master executes the SQL, log the binary log file (Bin-log).From the connection master,

reprinted from Http://blog.csdn.net/ghsau. MySQL upgrade from 5.5 to 5.6,timestamp changesThe behavior of timestamp in MySQL5.5 The first timestamp non-null character De Yin default value is not set by default:Current_timestamp on UPDATE

If your server environment allows Yum, installing the Mysql-python module is straightforward.If direct installation is not possible, firstNormal operation after installing Mysql-develYum Install mysql-develYum Install mysql-python-y 1

Recommended Brands//Start Here is the first productmysql_select_db ("member");mysql_query ("Set character set UTF8");mysql_query ("Set name UTF8");$result =mysql_query ("select * from ' purchasemessages ' where pur_tuijian=1 order by pur_id desc

when using in Mysql's master-slave replication architecture, there are two more headache issues: 1. how to deal with master-slave data after different steps2. How to solve the problem of master-slave synchronization delayThis article will be based

installation MySQL Dependency PackagesYum install-y ncurses-devel Libaio-develConfigure a different my.cnfports and file paths, and Server-id[Client]port=3306Socket=/data/3306/mysql.sock[Mysqld]port=3306Socket=/data/3306/mysql.sockBasedir=/usr/local/

Use Java to make a backup of MySQL:public class Mysqlbackup {/** * Java code Implementation MySQL database export * * @author Gaohuanjie * @param hostip MySQL database service Address IP * @param userName the username required to enter the database *

Binlog mode can be divided into the following three types (row,statement,mixed)1.RowThe log is recorded as each row of data is modified form, and then on the slave end of the same data modified, only the data to be modified, only the value, there is

1. Development environment: 1) CLion-2016.1.3 Mixed programming IDE for C/C + + and Python, first install the following 2) 3) compiler re-association 2) Tdm-gcc-4.8.1-3 C + + Compiler 3) winpython-64bit-3.5.1.3

Before the installation of MySQL did not summarize, new computers, repair the installation record, installation, found some users of the installation records, found a lot of pits1, Mysql-5.7.12-winx64.zip downloadOfficial:

Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the backup to overwrite the existing database

SqlDDL: Data definition language CREATE DROP ALTERDML: Data Manipulation language SELECT INSERT UPDATE DELETEDCL: Data Control Language GRANT REVOKE COMMIT ROLLBACKThe most basic (build a library, build a table)SHOW DATABASES;Use database

First, the preparatory work1. Close the MySQL process# Pkill# Service Mysqld Stop2. Remove Mysqld from System services# chkconfig--del mysqld3. Delete Mysqld# Rm-rf/etc/init.d/mysqld4. Create a directory for each instance# Mkdir/data/{3306/data,3307/

1. Error2. When you are sure that you have forgotten your MySQL password, you can reset the root user password by using the following scenario. Double-click Open C:\Program files\mysql\mysql Server 5.1\my.ini file, such as:3. Click "Edit" at the top

Installation and configuration of MySQLMySQL Port number 3306Basedir= "C:/Program files/mysql/mysql Server 5.5/" Base installation directoryDatadir= "C:/programdata/mysql/mysql Server 5.5/data/" After data file storage directoryModify the

How much is the proper mysql tmp_table_size optimization and tmptablesize optimization? You can set the tmp_table_size option to increase the size of a temporary table, for example, a temporary table generated BY the advanced group by operation. If

The third day of MySQL learning, Windows 64-bit operating system, MySQL verification, the third day of mysql 1. Check whether the MySQL service exists in the computer service list. (1) Right-click the computer icon on the desktop and select "manage".

MySQL learns basic MySQL database operations on the fifth day. This article studies the basic operations of MySQL databases. Do not miss this article. The following command lines are used in Windows 64-bit operating systems. Before learning, Let's