MySQL

First we create a comma-delimited string. CREATE TABLE Test (id int (6) NOT NULL auto_increment,primary KEY (ID), pname varchar (a) not null,pnum varchar (a) NOT null) ; Then insert the test data with a comma-delimited INSERT into Test (pname,pnum)

This article is based on CentOS 64-bit 1. Download MySQL first (mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz) Download http://dev.mysql.com/downloads/from official website Select the appropriate Linux version 2. Copy the

Five statistical functions (used alone, with little meaning, often used in combination with grouped group by)Max Max select Max (shop_price) from goods;Min min Select min (shop_price) from goods;Sum sum select SUM (shop_price) from goods;AVG

Left and right connectionsFull multiplication method (very low efficiency)Mysql> select * from Test10;+------+-------+| ID | sname |+------+-------+| 1 | Cloud || 2 | Moon || 3 | Star |+------+-------+3 Rows in Set (0.00 sec)Mysql> select * from

Reference http://www.cnblogs.com/kingteach/archive/2011/07/05/2098046.htmlCreate procedurePro_getunderorg (inchUseridvarchar( -))beginDeclareLevint;SetLev=1;Drop Table if existsTMP1; CREATE TABLETMP1 (' ID 'BIGINT, LoginIDVARCHAR( -),

First, install the keepalived# Install keepalived Source Installation Dependency PackageYum-y install OpenSSL openssl-develyum-y install Popt-devel# Source Compilation installation keepalivedTar XF keepalived-1.2.7.tar.gz cd

To create a user:' username '@'host'password';Description: username– You will create the user name, host– specifies which host on which the user can log on, if localhost is available to local users, you can use the wildcard% if you want the user to

One, MySQL cache:1. The cache includes:(1), cache query plan to avoid two lexical parsing, optimization, execution.(2), the cached MySQL query statement returns the full result, when hit, MySQL will understand the return results, eliminating the

The 1.mysqlbinlog tools use the following methods:Use Show First binary Logs ViewWhen you use the Export commandMysqlbinlog-r-uroot-pxxxx-hxxx.xxx.xxx.xxx-d db_name--base64-output=decode-rows--start-datetime= ' 2015-08-13 13:1 1:21

The learning of SET statements:practice of defining User variables using Selectchange the following statement to the form of select:Set @VAR = (select sum (amount) from penalties);My Changes:Select @VAR: = (select sum (amount) from penalties);I can

http://www.cnblogs.com/zhuyp1015/p/3561470.html install MySQL on Ubuntu is very simple and requires just a few commands to complete. 1. sudo apt-get install mysql-server 2. Apt-get Isntall mysql-client 3. sudo apt-get install Libmysqlclient-dev the

MysqlIncremental BackupBinlog is an incremental backup, confirming that the next binlog is turned on:#grep "Log-bin"/etc/my.cnfmethod of incremental recoverymost basic sub-recovery#mysqlbinlog mysql-bin.000001 >bin.sql#mysql-uroot-p ' abc-123 '

See which libraries > show databases are available;View the table > use DB for a library; Show tables;View table fields > Desc TB;View Build Statement > Show CREATE TABLE TB;Which user is currently > select User ();View current Library > select

Indexing is the key to fast searching. MySQL indexing is important for the efficient operation of MySQL. Here are a few common types of MySQL indexes.In a database table, indexing a field can greatly improve query speed. Suppose we create a mytable

about MySQLA database is a container for storing organized data.The database management system DBMS is the software that operates the database.A table is a structured file that can be used to store specific types of data. Table names in the same

Phenomenon: When the data inserted into the database is in Chinese, the following error is reportedThe reason is: the system default encoding of the computer is GBK, and the MySQL client provides encoding method is UTF8, two encoding inconsistency

There are several reasons for garbled problems, one of which is because MySQL uses the iso-8859-1 (or Latin1) character set by default, while Java internally uses Unicode encoding, so when inserting data into the MySQL database in Java, or when

MySQL new features-mysql_config_editor source code analysisMysql has launched the encryption tool mysql_config_editor since mysql5.6. Previously, we put the account and password in plain text into my. cnf, so that you can log on to the database

Data File suffix Today, we saw 99 tablespaces in the production system. We decided to add data files to the tablespaces. No problem. At night, you get cold sweat. Production system RAC. data files are stored in shared storage. The path is correct,

[Original] mysql Error Buffer Stack What is an error buffer stack? For example, execute the following statement: mysql>INSERTINTOt_datetimeVALUES(2,'4','5');ERROR1292(22007):Incorrectdatetimevalue:'4'forcolumn'log_time'atrow1 Where is the error