MySQL

For MySQL has been the second time to see, the main purpose is to summarize the MySQL system on one side, before learning MySQL is to write notes in the book, later do not want to always take the book, so take a moment to summarize the notes in the

MySQL User and Rights managementThe mysqld process loads the table,host,db,table_privs,clumn_privs,procs_privs,proxies_privs into memory when it is started.User account:User name + HostUser name: within 16 characters.Host:Host Name: MyTestIP Address:

The installation files are installed in the DMG format of the Mac under MySQL, but no files are uninstalled ... It's a very depressing thing.Search the Internet, found that the method originally had to be manually deleted.Many articles account for

Add 1 million data to the text document, with 8 fields per data, respectively:Id Int (one) NOT NULL primary key auto_incrementName varchar (40)Age Int (11)Sex Char (5)Salary Int (11)Phone varchar (13)Email varchar (+) NOT NULLAddress varchar (64)How

after the MySQL database is officially online, open the binlog log and discover that the disk is exploding 100G. Roots in my.cnf inside binlogMysql>show variables like '%log% ';check the relevant settings for this parameter:|expire_logs_days |0|This

If a business scenario, after testing, read-write ratio is listed 1:20, according to the ratio of reading and writing, reasonable set optimization scheme.Read-write ratio column:Write data/Read data ratio, Insert/update/delete/selectThe basic

Detailed compilation Installation lamp environmentInstall OS and software versionsOs:cent OS 6.5Apache:httpd-2.4.10.tar.gzphp:php-5.4.31.tar.bz2Mysql:mysql-5.6.19.tar.gzXcache:xcache-3.1.0.tar.gzFirst, pre-installation preparationModify Host

1.1.1. ERROR 1418"Environment description"mysql5.0.67"Problem description"Error 1418 error encountered while creating stored procedure.# SQL statement to create a functionCREATE FUNCTION ' xxx ' (num01 int) Returnsint (11)Begindeclare mm int default

1, with Begin,rollback,commit to achieveBegin a transactionROLLBACK TRANSACTION RollbackCommit TRANSACTION Acknowledgement2, directly with set to change the MySQL automatic submission modeMySQL is automatically submitted by default, that is, you

1. Examples of stored procedures: DELIMITER $$DROP PROCEDURE IF EXISTS helloworld$$CREATE PROCEDURE HelloWorld ()BEGINSelect "Hello world!";end$$DELIMITER; 2. Variable declaration Use declare to declare, default

First, create a stored procedureCreate a stored procedure (a)' Hello world '; END; // Execute stored procedure call Proc1 ();Basic form of creating stored procedures| Out | InOut] Param_name typecharacteristic parameter has multiple values: LANGUAGE

MySQL garbled problem:What happens: When you use the command line to view database data, the Chinese language is displayed as garbled.Error when inserting Chinese data with command line.Solution Ideas:1, enter at the command line: [Show variables

Group_concat () Main function: The same line can be combined togetherThe complete syntax is as follows:Group_concat ([DISTINCT] field to connect [order by Asc/desc sort field] [Separator ' delimiter '])Basic QuerySQL code SELECT * from AA;

Installation Steps->useradd MySQL->cd/tmp;tar-xzf mysql-version.tar.gz->chown-r root.root mysql-version->mkdir Mybuild->CD Mybuild->cmake-dbuild_config=mysql_release\-dcmake_install_prefix=/usr/local/mysql\          .. /mysql_version->make-j&& make

Problem Description: Do the master and slave of MySQL, have not the decision from separation, cause colleague in MySQL from server performed write operation, cause out of sync (show slave status\g;slave_sql_running:no)Workaround:1,Mysql > Slave stop;

$con =mysql_connect (' localhost ', ' root ', ' 1234 ');Echo ' 1.mysql_client_encoding ';Echo mysql_client_encoding ();//Returns the encoding of the current databaseMysql_data_seek (Result, row_number): Moves the data interior pointer to the

DELIMITER $CREATE PROCEDURE generate_equipment (District Int,warehouseno VARCHAR (10))BEGINDECLARE l_no VARCHAR (50);DECLARE l_address VARCHAR (20);DECLARE l_name VARCHAR (20);DECLARE l_city VARCHAR (DEFAULT "Tianjin");DECLARE L_longitude

1 Use status in the command line to view.mysql> status;--------------MySQL Ver 14.14 distrib 5.5.25a, for Linux (x86_64) using ReadLine 5.1Connection id:33348Current database:Current User: [email protected]Ssl:not in useCurrent Pager:stdoutUsing

How does the go language link to the mysql database? I found a lot of examples on the Internet, and finally simplified it. I will start from installing mysql and share with you how to use go to link mysql on the server. I use the ubuntu system. 1.