MySQL

I. OverviewMysql-ha currently has a lot of implementations, today with the MySQL double master+keepalived to achieve mysql-ha. in the In the Mysql-ha environment,MySQL is the main slave relationship, which guarantees the consistency of the two MySQL

1.nullMysql> CREATE TABLE worker (ID int not null,name varchar (8) Not null,pass varchar (a) not null);Mysql> INSERT into worker values (1, ' HA ', ' 123456 ');Mysql> INSERT into worker values (1, ' LB ', null);ERROR 1048 (23000): Column ' pass '

MySQL Installation problem Solving methodproblem Recurrence (The following discussion is limited to Windows environment):C:\appserv\mysql> Mysql-uroot-prootERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using

MySQL daily operation Commands:1 showdatabases; View Database2 CreateDatabase test_db; Create a database named test_db3 usetest_db; Enter the test_db database. 4 showtables; See how many tables are in the database. 5 createtable test01 (ID varchar ()

"_": matches any single character"%": matches any number of characters (including 0 characters)"[ABC]": Matches "a", "B" or "C". To name a range of characters, use a "-"."[A-z]": matches any letter"[0-9]": matches any number"*": Match 0 or more

First, isolation Level(1) MySQL isolation level1, read-uncommitted2, read-committed3, Repeatable-read4, Serializable(2) View isolation LEVEL1, show variables like '%iso% ';2, select @ @tx_isolation;(3) Setting the isolation levelSet tx_isolation= '

1.1,the definition of "key" and "index" in MySQL is the same, so the foreign key and the primary key are also one of the indexes. The difference is that MySQL automatically indexes the primary keys for all tables, but the foreign key fields must be

Advanced query:1. Connection QuerySELECT * from info,nation #这是两个表名, separated by commasTo form a Cartesian productSELECT * FROM Info,nation where Info.nation=nation.codeSelect Info.code,info.name,info.sex,nation.name as ' Nation ', info.birthday

Let's introduce a simple mutual transformation between a servlet, JSP, and MySQL (that is, using a page to access a database), taking the table table in the database as an example.1, set up a servlet, named check, the data in the database dropped

Building PreparationScenario One: Deploy all to a single serverScenario Two:A server (CENTOS7): apache+php+php's websiteb Server (centos5): MySQLWe're using scenario two.Install the required software for each server.A server: #yum install httpd-y//

Transferred from: http://blog.csdn.net/cuidiwhere/article/details/8452997Question 1:mysql What is the difference between index type normal,unique,full text?Normal: Indicates normal indexUnique: Represents a unique, not allowed duplicate index, if

Don't want to compile, heart tired, centos default MySQL or 5.1 version, try to mysql5.7 itwget http://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpmRPM-IVH mysql57-community-release-el6-9.noarch.rpmYum Install Mysql-server=============

Delimiter $Create Event My_long_running_trx_monitorOn schedule every 1 minuteStarts ' 2015-09-15 11:00:00 'On completion preserve enable doBeginDECLARE v_sql varchar (500);Declare No_more_long_running_trx integer default 0;DECLARE C_tid cursor

Scene: MySQL before the time is still available, but today suddenly can not open, I suspect that the use of certain anti-virus software, the MySQL part of the startup files deleted, but I do not want to reinstall, how to do?When you have tried a lot

Create a tableCREATE TABLE CeShi1 (Uid varchar (primary) key,pwd varchar (), Name varchar (+), Nation varchar (+), foreign key (Nation) References Nation (Code))Primary KEY Primary KeyNot NULL non-nullForeign KEY (Nation) references Nation (Code)

Advanced query:1. Connection QuerySELECT * from info,nation #这是两个表名, separated by commasTo form a Cartesian productSELECT * FROM Info,nation where Info.nation=nation.codeSelect Info.code,info.name,info.sex,nation.name as ' Nation ', info.birthday

Database common commands;View database: show databases;Creating a database: Create databases database_name;Delete database: drop databases database_name;MySQL-supported engine; show engines \g;Shows the storage engine supported by the database; Show

MySQL string truncation and splitting function usage example This example describes how to use the string functions of MySQL to intercept and split. We will share this with you for your reference. The details are as follows: FirstString truncation

Centos Mysql installation graphic tutorial, centosmysql Mysql is a commonly used database, which is also used in daily development. To do this, you must first sharpen the tool. This article specifically explains how to install Mysql in centos

Mysql: mysql 5.6.13 installation-free configuration, mysql5.6.13 Mysql is actually used in the company's second project, specific in the previous blog article (http://www.cnblogs.com/zhengzeze/p/5623440.html) also mentioned, which involves, without