MySQL

The following articles mainly describe how to create a stored procedure instance in MySQL5. The application frequency of MySQL5 to create a stored procedure is very high. The following describes the instance of MySQL5 to create a stored procedure, I

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;

In linux, it is often the case that VBB is used in a forum system such as slow, mysql is suspended, and there are too many sleep processes. As a result, the system was completed for dozens of users.In fact, this is the problem of mysql configuration,

For example, if there is a post reply table, posts (id, tid, subject, message, dateline ),Id is the auto-increment field, tid is the id (foreign key Association) of the reply topic post, subject is the reply title, message is the reply content,

When querying data, we usually need to specify the rows of data to be returned. For example, if there is a B/S architecture application, each page may display only 30 records. To improve the display efficiency, the database is generally required to

When installing wordpress on MacBookPro today, the installer always reports an error saying that it cannot connect to the database. The mysql client can be used normally and it can be determined that it is not a server problem. I wrote a php script

Instance Host:Dbasky = 192.168.1.120Dbaskyback = 192.168.1.121 Objective: To synchronize data in the test database of the dbasky host on the dbaskyback host Install mysql[Root @ dbasky] # wget ftp://ftp.cronyx.ru/pub/FreeBSD/ports/distfiles/mysql-5.0

The previous article explains how to install and test MySQL. After the environment is set up, we can continue our learning. This article is familiar with Common commands. 1. Start the MySQL server. In fact, the previous article describes how to

After learning some basic operation commands, let's learn how to create a database and a database table. 1. Use the SHOW statement to find out the current database on the server: mysql> show databases; + ---------- + | Database | + ---------- + |

Extract data from MySQL today. After using ROLLUP statistics, add the project name to the left column of the data and use SQLSQL codeSELECT (case when isnull (PLAYERNO) then playerno = total else playerno end) as playerno, SUM (AMOUNT) FROM

1. Configure the master database my. iniPort = 3306Datadir = "C:/Program Files/MySQL Server 5.0/Data /"Server-id = 1Log-bin = mysql-bin.log 2. Configure slave database my2.iniPort = 3307Datadir = "C:/Program Files/MySQL Server 5.0/Data2 /"Server-id =

1. Copy the table structure and data, but do not copy the index and foreign key:Create table a select * from B;2. Copy the table structure, index, and foreign key without copying data:Create table a like B;3. Copy data only:Insert into a select *

  1.1 backup Mysqldump adopts an SQL-level backup mechanism. It imports data tables into SQL script files and is suitable for upgrading between different MySQL versions. This is also the most common backup method. Here are some main parameters of

GRANT ALL PRIVILEGES1. Change the table method. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the

Static table fields have fixed length, automatic filling, fast read/write speeds, and are easy to cache and repair. However, dynamic table fields are not fixed in length, saving hard disks but making them more complex, fragments are easy to generate,

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

I. Common commandsCreate database nameSelect Database: use databasenameDirectly Delete the database. Don't remind me: drop database nameDisplay table: show tablesTable Description: describe tablenameRemove duplicate fields: Add distinct to

Master host: www IP: 192.168.9.124From host: www1 IP: 192.168.9.123 # Download mysqlWget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.58-linux-i686-glibc23.tar.gz/from/ftp://mirror.anl.gov/pub/mysql/ # Install mysqlTar xzf

If the MySQL data file is too large, can it be compressed? The answer is yes. The following describes how to compress MySQL data files.After using MySQL for a period of time, the MySQL Data File ibdata will grow significantly (mainly for innodb

Create a mysql masterServer‑mysql: 192.168.1.108Server2_mysql: 192.168.1.110Topology:Serverslave MySQL ------- server2_mysql1. Create and authorize a userServer1:Mysql> grant replication slave on *. * TO 'server2' @ '192. 168.1.110'Identified by