MySQL

Mysql Master-slave replication configurationFirst, the test environment1. Software EnvironmentA) operating system:CentOS 6.5 X64b) mysql-server:Mysql-server-5.1.73-3.el6_5.x86_642. network EnvironmentEach host has two network card, one of the

Some small knowledge of using MySQL today1. Log in to MySQLNative: Command interfaceMysql-u username-p PasswordLogin to the specified machine: Port not modifiedMysql-u username-h IP address-p asswordLog on to the specified machine: Port

The fields in the text file are separated by "," such as:3144242807,wed Oct 22:44:28 CST 2013,30.536041,114.3680192443892271,mon APR 09:21:39 CST 2014,30.545344,114.365762122771615,fri Sep 14:00:32 CST 2013,30.538091,114.3706052495361967,wed APR 07:2

Information_schema is the DB under MySQL, which stores the data dictionary of the database, but on the OS system, there is no data and structure file information_schema the following table.So, when MySQL queries the table under INFORMATION_SCHEMA,

To establish a database:mysql> CREATE DATABASE test; Create a database named "Test"To create a database table:Mysql> CREATE TABLE Test(name char (+) NOT NULL,-passwd char (16)); Create a table named "Test" with two fields, a field named "Name", type

1, when your self-increment ID primary key is large, you want to let the ID back to 1 starting from the increment please enter: truncatetable name;2, when your database corruption, you don't panic first try this command can help you please enter:

(1), Pt-table-checksum tool name (2), installation Pt-table-checksum#:wget www.percona.com/downloads/percona-toolkit/2.2.2/ PERCONA-TOOLKIT-2.2.2.TAR.GZ#:TAR-XVF percona-toolkit-2.2.2.tar.gz#:p erl makefile.pl # make && make install (3 ), authorized

Reprinted from: http://www.cnblogs.com/hanxirensheng/archive/2012/07/13/2589939.html Today with Spring+hibernate+struts2 wrote a simple example program, using spring to manage hibernate processing data, integration of STRUTS2, with a long time

The following error occurs in the MYSQL database of the website:Copy codeThe Code is as follows: Table '. \ de_archives' is marked as crashed and last (automatic ?)This problem occurs when the related table is damaged. You can use phpmyadmin to fix

Therefore, correct atomic operations are actually executed. Is physical execution. You can see the inserted records in the current transaction. Finally, it is deleted. However, AUTO_INCREMENT does not need to be deleted and the value is changed. 1.

Some common MYSQL operation functions are closely related to MYSQL operations. I believe they will be of great help to beginners of PHP development. 1. mysql_connect -- open a link to the MySQL server Note: The link is closed after the page is

Copy codeThe Code is as follows:Call PROCEDURE_split ('share, code, fragment ',',');Select * from splittable; Copy codeThe Code is as follows:Drop PROCEDURE if exists procedure_split;Create procedure 'Procedure _ split '(Inputstring varchar (1000

It is important for MYSQL database users to back up and restore MySQL. This article describes how to use the mysqldump and source commands to back up and restore MYSQL in Windows and Linux. I. Restoration of MySQL backup in Win32 System Backup: In

Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions. View column: desc table name; Alter table t_book rename to bbb; Add column: alter table name add column name varchar (30 ); Delete column: alter table Name

For mysql using rpm in Linux, we can remove these rpm packages and delete the project directories to uninstall them. This article demonstrates how to download MySQL 5.5.37 in SUSE Linux 10. See the following for details. 1. Environment Welcome to

Usually, data storage needs to specify the case sensitivity of string fields. MySQL Default queries are not case sensitive. However, as user information, once the user name is repeated, it will waste a lot of resources. In addition, it is difficult

I recently used the MySql database for project development. After reading some articles about MySql, I quickly started using it. Some problems still occur in the process of use, because the green installation-free version of MySql is used, so some

After installing mysql, we can perform SQL statement operations: Run the following command to connect to the MySQL service: Mysql-h localhost-u root-p -H parameter specifies the address of the MySQL server to be connected -U parameter specifies

1. Introduction to mysqlcheck The mysqlcheck client can check and repair the MyISAM table. It can also be optimized and analyzed. The function of mysqlcheck is similar to that of myisamchk, but it works differently. The main difference is that

Download the mysql yum source from the website at the following address:Http://repo.mysql.com/Check the system version number on linux and download it based on the version number.More/etc/redhat-release Rpm-Uvh