MySQL

command: show Processlist;if it is the root account, you can see the current connection for all users. If you are a normal account, you can only see the connection you are occupying. show Processlist; only the first 100 are listed, if you want to

MySQL grouping and aggregation functionsThere are 5 Mysql aggregation functions:1, COUNT () number of records (count (1), COUNT (*) Table rows, count (column name) statistics column non-null number)2, max () maximum value3, min () minimum value4,

MySQL alter summary (reprint)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

[Understanding Index]To understand an index, you first need to understand how the data is stored on your hard disk. Different storage engines may not take the same action, for example, the MySQL client defaults to MyISAM, which creates a separate

Heartbeat+drbd+mysql High-availability1. Planningvip:192.168.1.30Myhost1:Intranet ip:192.168.1.11Heartbeat Heartbeat ip:192.168.74.11DRBD Transport ip:192.168.223.11Myhost2:Intranet ip:192.168.1.12Heartbeat Heartbeat ip:192.168.74.12DRBD Transport

Think of a question:1/3+1/3+1/3=1.00.3+0.3+0.3 =0.9Think about what it means to be 1/3 in a decimal world! Its approach is to take a 1/3 very close to the decimal place, as in the example above the 0.3来 instead of 1/3, so the problem is to be stored

There are many such data in the table:TEST-123,TEST-III this data, which begins with TEST, in order to count the totalThe Substring_index () method can be used with MySQL's own methodThe first parameter is the contents of the column,The second

Login: Mysql-uroot-p-p3306-h----(-u means user name,-p for password, can not lose,-p for port number,-H for Host name)Show current server version: SELECT version ();Show current date time: Selectnow ();Show Current User: SELECT user ();Create a

1. View installed installation packagesRpm-qa | Grep-i MySQLMysql-server-5.0.67-1.sles11libqt4-sql-mysql-4.6.2-1.6.11libmysqlclient15-5.0.67-13.20.1php5-mysql-5.2.6-50.24.1Mysql-client-5.0.67-1.sles11libmysqlclient_r15-5.0.67-13.20.12. Delete

1. Design Principles1) standardization and normalization standardization of data helps eliminate data redundancy in the database. There are several forms of normalization, but the third normal form (3NF) is generally considered to be the best

When accessing the MySQL database, the project often appears communications link failure error, which seems to be an idle connection over the database settings "Wait_timeout", MySQL will be out of the connection, The MySQL connection pool also

To implement this dynamic SQL statement assembly, we can create a string in the host language and then individually determine whether each check box is selected to add the SQL statement fragment to the string. One problem here is that when a check

1. Now take the menu table as an example to create a table Test_menu in the database.2. Create some instance data in the tableNow the menu level for Cd_1 and Cd_2 for a first-level menu, Cd_1 is divided into cd_1_1 and cd_1_2 two level two menu, Cd_1

Tag:mysql   my.cnf    optimization     [client]port            = 3306socket           = /tmp/mysql.sock[mysqld]port             = 3306socket           = /tmp/mysql.sockskip-external-lockinglog-error=/usr/local/mysql/log/error.logkey _buffer_size = 5

For English, MySQL's Fulltext property is quite convenient and efficient to implement full-text retrieval, but there are some things to be aware of in the process of using.First, we add the Fulltext attribute to the field we need to retrieve

The SQL language includes statements from four main programming language categories: Data definition Language (DDL), Data Manipulation language (DML), Data Control Language (DCL), and transaction control language. The database schema definition

LOADDATA LOCAL INFILE'C:/xampp/htdocs/test/file/sample.csv' into TABLESample1fields TERMINATED by ','Enclosed by '\"'LINES TERMINATED by '\ r \ n'IGNORE1LINES (Presidency, President,@x,@x,@x, Party,@x,@x,@x)You can insert the specified line,

Solve the problem that mysql service cannot be started and Mysql is reinstalled in the last step. Mysql services are often the most troublesome and often need to be reinstalled. Many people cannot unload the residual files and cannot install them.

MySQL settings allow users to log on remotely The basic system was deployed on the server yesterday. Everything is normal. However, the developer needs to remotely Access the MySQL database on the server and finds that the root remote connection

Problems encountered during Mysql trigger usage [1054] Unknown column 'xxxxx' in 'where clause' Drop trigger if exists 'delete _ actdata '; create definer = 'xxxxxx' @ 'localhost' TRIGGER 'delete _ actdata' BEFORE delete ON 'actdata' for each