MySQL

InnoDB provides MySQL with a transaction security (ACID-compatible) storage engine with the capabilities of commit, rollback, and crash recovery. InnoDB locks row-level and also provides an Oracle-style non-locked read in the SELECT statement. These

Recently, I encountered the problem of "how to connect SQL to remote MySQL", and now the problem is finally solved. I posted the method: (my operating system is Win7, and the database is SQL2005 .) 1. Install the mysql odbc driver on the SQL SERVER;

// By redice 2010.07.26// Redice@163.com The MYSQL Learning Outline for the company intern summarizes the most useful knowledge points in project development and can be used as a MYSQL quick start tutorial. 1 MYSQL column (field) Data Type: (1)

Select *, if (sva = 1, "male", "female") as ssva from taname where sva <> "" 12.2. Control Flow FunctionsCASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result...] [ELSE result] end case when [condition] THEN result [WHEN

MySQL adds, modifies, and deletes columns. alter table: adds, modifies, and deletes TABLE columns, constraints, and other TABLE definitions. View column: desc table name;Alter table old _ name rename to new_name;Add column: alter table name add

I have studied the high availability of databases and need to use Database Synchronization and backup. Below are some of my studies on MySQL HA.     According to the HA solution provided in MySQL 5.0 Reference Manual, it mainly consists of the

I. Summary:1. Run the following command to start MySQL in Linux:/Ect/init. d/mysql start (the installation path of mysql is earlier)2. Command for restarting mysql in linux:/Ect/init. d/mysql restart (the installation path of mysql is earlier)3. Run

# Useradd mysql-s/sbin/nologin# Wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.54.tar.gz# Tar zxvf mysql-5.1.54.tar.gz# Cd mysql-5.1.54#./Configure -- prefix =/usr/local/mysql-- With-mysqld-ldflags =-all-static // compile the server in

When importing mysql Data today, the following error occurs:Mysql> load data infile '/root/aaa' into table test fields terminated by', 'Lines terminated by '\ n ';Mysql> ERROR 13 (HY000): Can't get stat of '/root/aaa' (Errcode: 13)At first, I

Use mysqldumpslow and mysqlsla to analyze mysql slow query logsMySQL optimization is not a permanent task, but a constant battle. Among them, the analysis of slow query logs is an important method. I used to look at it manually. However, this is not

Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not just something that DBAs need to worry about, but it is

You can use show engines; or show plugins; To ViewMysql> show plugins;+ ------------ + -------- + ---------------- + --------- +| Name | Status | Type | Library | License |+ ------------ + -------- + ---------------- + --------- +| Binlog | ACTIVE |

Install and configure mysql cluster on centos6.0 I am using the rpm package of mysql cluster 7.1.15a. I used five VMS:One Management node, two SQL nodes, and two data nodes The installation and configuration steps are as follows: 1. Management node

1) Two mysql servers A and B1. edit/etc/my. cnf for server Parameters [Server A]Server-id = 1Binlog-do-db = testBinlog-ignore-db = mysqlReplicate-do-db = testReplicate-ignore-db = mysqlMaster-host = 192.168.20.195Master-user = replMaster-password =

I recently created a project with database garbled characters. I don't know how to set it in phpmyadmin. Let me go !! I thought it was definitely because the character set settings were inconsistent, php encoding was correct, and UTF-8 character set

1. Connect to MYSQLFormat: mysql-h host address-u user name-p User Password1. Connect to MYSQL on the local machine.First open the DOS window, then enter the directory mysql/bin, then type the command mysql-u root-p, and press enter to prompt you to

  It is estimated that there are more than a hundred yuan to see. I always have to explain the background first. A few days ago, the website suddenly failed to be accessed, and there was no content except the framework on the page. The following

Slides address: http://www.slideshare.net/mysqlops/mysql-9838563Comparison of column values of the same data typePrinciple: Number-to-number, character-to-CharacterComparison between value columns and Character Types• Conversion to precision at the

Whether logs are enabledMysql> show variables like 'Log _ bin '; How to know the current logMysql> show master status; Use mysqlbinlog to view binary log filesShell> mysqlbinlog mail-bin.000001 (to write absolute problem path d ://)Or shell>

In actual work, we often accidentally delete the database or table and regret it. Is there any regret to take? The delayed backup described today can be achieved. Delayed backup causes slave to lag behind the master for a period of time. When a