MySQL

We install through YumI. Installation Prerequisites1, yum update check System Update 2, yum-y installgcc gcc gcc-c Install the build Environment 3, yum erasehttpd Uninstall system comes with httpdTwo. Installing Apache[email protected] ~]# Yum

First build the target library and assign permissions.Mysqladmin Create NemoproFrom Nemob2b to NemoproReplication commands for different databases with host :1. Small amount of data (within 1M)Mysqldump nemob2b-u Root-ppassword--add-drop-table |

Method OneCMD to the MySQL Bin directory with the following command mysqldump--opt-h192.168.0.156-uusername-ppassword--skip-lock-tables databasename> Database.sqlYou can change the IP to localhost.It's even easier if you have navicate. Connect to

Work with some special strings, such as ' 50-1-1-2-3 ', when you need to get ' 50-1-1-2 ' you can use the following custom functionsDELIMITER $ $USE ' mydb ' $ $DROP FUNCTION IF EXISTS ' get_content_before_last_separator ' $ $CREATE definer= ' root '

Application system is CentOS 6.x MySQL version 5.1The SELinux and iptables can be closed in advance.[Email protected] ~]# chkconfig iptables off[Email protected] ~]# chkconfig ip6tables off[[email protected] ~]# /etc/init.d/iptables Stop[[email

MySQL's simple syntax, often used, is not easy to remember. Of course, these SQL syntaxes are basically common in each database. Listed below: 1. Add a field ALTER TABLE user add COLUMN new1 VARCHAR DEFAULT NULL; Add a field that defaults to null

Inserting data into a tableThe INSERT statement can be used to insert one or more rows of data into a database table, using the following general form:Insert [into] table name [(column name 1, column name 2, column name 3, ...)] VALUES (value 1,

How to compare the parameters of two MySQL instances, the production often have such a requirement, recently wrote a Python script, can basically achieve this requirement.Script#!/usr/bin/pythonImportMysqldb,sysdefFetch_variables

Xtrabackup is a physical backup tool that supports the INNODB and XTRADB storage engines, and it has the following features:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the transaction being performed;(3) can

The MySQL database provides two types of indexes, and if not set correctly, the efficiency of the index will be greatly compromised.CREATE TABLE Test (ID INT not NULL, last_name char (+) NOT NULL, first_name char (+) NOT NULL, P Rimary KEY (ID),

Https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-debian-7https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-nginx-on-ubuntu-14-041) Update Apt-getThe apt-get Update

Optimize your goals1. Reduce the number of IOIo is always the most vulnerable to the database, which is determined by the responsibility of the database, most of the database operations more than 90% of the time is occupied by IO operations, reduce

The error message of MySQL error 1005:can ' t create TABLE (ERRNO:150) When establishing referential constraints in MySQL results in the inability to establish referential constraints.A rough picture of what's wrong1, foreign key reference type is

After exposure to virtualenv, you want to install a separate development environment in this virtual environment. Error encountered while installing MYSQLDBPC 09:09:30File

Format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to lose the password.

The first time so close to contact the source code, a little excited, and a little overwhelmed, a lot of the source files are thousands of lines, you say how to see, there are some countless data structures, functions, classes and other messy things.

I. Table structure modification (DDL)1. Add a field to the table structureA.alter Table NameADD field name data type [Field Properties | constraints][first| After field name]; B. Adding multiple fieldsALTER Table Table NameADD field name data type

Both MySQL and Lucene can index data and query data by index, one is a relational database, and the other is the core class library for building search engines (SOLR, ElasticSearch). What is the difference between the indexes? Previously wrote a

MySQL Slow query1, slow query role?It records all SQL statements that execute more than long_query_time time, helping you to find SQL that executes slowly, so we can optimize these SQL statements.2, how to open the slow query?First we check if the

How to configure the world's smallest MySQL Server Configure the world's smallest MySQL Server-how to install a MySQL server on an Intel Edison control panel. Introduction In my recent blog post on IOT, messaging, and MySQL, I showed if the Particle