MySQL

2015-07-13 15:10:32It is very convenient to install the software with homebrew under Mac.Brew Install MySQLWait a while after installation is complete to the installation directory:/usr/local/cellar/mysql/5.6.25/Execute the command inside the script

Background: The responsibility of the automated continuous delivery platform business gradually increased, safekeeping, need to build a backup system, after a number of considerations;Choose to take MySQL master-slave system for backup, mutual main

Some time ago because I want to set up a work environment at home, so the SQL Test library data into their own computer, but with Navicat import, set the ' Encounter error continue ', and then run the SQL statement after the end of query import

The morning just work about ten minutes, colleagues said in the use of Jira problems, as follows:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/88/wKiom1WfLDXD_ag0AAX0GXUN_xc840.jpg "title=" The number of database connections is too

Write the stored procedure for the first time, write well to suppress flexion.set @c_db := (select database());drop procedure if exists alter_tables_engine;delimiter //create procedure alter_tables_engine() begin declare db varchar(64);

After installing the MYSQL5, it is found that the startup error, sometimes starting normally, but the error is immediately added.Error code: 1067The solution is as follows:Delete%windows%/my.iniRemove My.ini from other placesCopy the My-small.ini to

1 , add groups, and users# Groupadd MySQL# useradd-g MySQL MySQL2 , creating the installation directory# mkdir MySQL3 , upload MySQL installation package (I usually use Securefx)4 , unzip to the/mysql directory# Cd/mysql# chmod +x

1 , change master and slave configuration filesMaster configuration file# CP/MYSQL/SUPPOTS-FILE/MY-DEFAULT-CNF[Client]port=socket=[Mysqld]Basedir=Datadir=port=Server-id=Socket=/data/mysql.sockLog-bin=/data/mysql_binBinlog_format=mixed/row/sqlbinlog-

Source: http://blog.csdn.net/dapeng0112/article/details/37053407The initial configuration is this:scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysqlCame up[[Email protected] mysql-5.6.14]# service MySQL

_MYSQL.C: In the function ' Dl_export ':_mysql.c:3058: Error: expected declaration specifiers before ' Init_mysql '_mysql.c:3166: Error: expected ' {' at end of inputError:command ' gcc ' failed with exit status 1-------------------------------------

1, the application of the databaseThe mainstream software development application database has: IBM's Db2,oracle,informix,sybase,sql Server,postgresql,mysql,access,foxpro and Teradata and so on. 2, the Structured query statement to the database

MySQL uses disk space:1, PS-EF | grep MySQL2, select @ @datadir;3, show create TABLE Mytab;Show CREATE table t;A MyISAM storage engine. A InnoDB storage engine4. INSERT INTO t select * from T;INSERT INTO Mytab select * from Mytab;Found the data file

One: Statistical functionsMySQL provides 5 statistical functions to count the data. It is to achieve the statistics of the records, calculate and calculate the average, calculate the maximum value and calculate the minimum value.1. Number of

Installs the 64-bit version of the RPM packagewget https://github.com/Qihoo360/Atlas/releases/download/sharding-1.0.1/Atlas-sharding_1.0.1-el6.x86_64.rpmrpm-                  IVH atlas-2.2.el6.x86_64_2.rpmpreparing ... ###############################

Most commonly used:Mysqldump-uroot-pmysql databasefoo table1 table2 > Foo.sqlThis allows the database Databasefoo table Table1,table2 to be imported as SQL Foo.sql, where the-uroot parameter indicates that the user name that accesses the database is

Defined:The first type:Case Case_value while When_value then statement_list [when When_value then Statement_list] ... [ELSE Statement_list] END caseThe second type:When the case is search_condition then statement_list [when

Because MySQL database additions and deletions suddenly burst, need to query is the operation of those tables is particularly frequent, wrote a tool to analyze Bin-log, find and add and change the table, and the number of operations in descending

Javaweb Learning Summary (37)--Get the MySQL database auto-generated primary keyThe test script is as follows:1 CREATE TABLE test12 (3 ID int primary KEY auto_increment,4 name varchar (20) 5);Test code:1 package Me.gacl.demo; 2 3 import

First, start Pycharm, create a Django project in a virtual environment1. Menu-file-new Project ...2. Select "Django" in the "Select Project Type" window3, click "Interpreter" the rightmost setting icon, select "Create

Sometimes the project needs to follow the pinyin of Chinese characters, such as contact list, mineral classification, etc., some of which need to be phonetic Alphabet from A to Z.　　if the stored Chinese character field encoding uses the GBK