MySQL

1. Macro-tuning can be considered three parts, respectively, hardware, network, software, the main consideration here is software tuning(1) Software tuning includes: table Design (Paradigm, field type, data storage engine), SQL statement Index,

how MySQL database remote access permissions open (two methods)Download GPL version installationMySQL Community Edition (GPL)Community (GPL) DownloadsWhen we use the MySQL database, sometimes our program is not on the same machine as the database,

Read the operation:1.select2.show3.explainExplain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.4.desc4.useWrite the

For an understanding of the index refer to this post:Http://www.cnblogs.com/newpanderking/p/3781043.htmlTypes of indexes and creating posts:http://blog.csdn.net/xluren/article/details/32746183Advantages and disadvantages of the index:MySQL Tutorial:

MySQL user consists of user and host name, using ' user ' @ ' hosst ' to indicate that MySQL user and permission information is stored in MySQL libraryMySQL database table:User #用户账号, global permissionsDB #库级别权限Host #主机Tables_priv #表级别权限Colums_priv #

1. Establish and close the connection to the MySQL server1) Connect the specified MySQL server[Email Protected]_connect ($host, $user, $password, $database, $port);2) Tips for connecting errorsint Mysqli_connect_errno ();//Returns the error code of

This article is about MySQL database InnoDB storage engine redo log roaming00–undo LogThe Undo Log is to implement the atomicity of the transaction in the MySQL database InnoDB storage engine. Also use undo log to implement multiple version

Under Ubuntu, has been a binary package decompression installation, the details of the reference:Http://www.cnblogs.com/phpgo/p/5680906.htmlNow replace the source code to compile the installation:#!/bin/bash# Install dependent libraries sudo apt-get-

In the corresponding Sqlbuckcopy class in MSSQLServer, bulk data is inserted.In MySQL, the official provided the Mysqlbulkloader parallel tool;But there is a pit inside, and the concrete pit is null by inserting a null column.For-input, if the

For MySQL to replicate the same table structure method, there are create table as and create table like two kinds, what is the difference?CREATE TABLE t2 as SELECT * from T1 where 1=2;or limit 0;The T2 table (the new table) created by as is missing

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Parse an SQL statement first to see what

I. Overview of the MySQL engineThe 1.MyISAM Storage Engine MyISAM table is independent of the operating system, which means that it can be easily ported from a Windows Server to a Linux server, and whenever we build a table for a MyISAM engine, we

MyISAM: This is the default type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. Compared to other

1. mysql Common commandsCreate database name; Create a databaseUse DatabaseName; Select DatabaseDrop database name deletes databases directly and does not alertShow tables; Show TableDescribe TableName; Detailed description of the tableSELECT * FROM

Mysql> SELECT * FROM books;+-----+---------------------------------+---------+-------------+-------+----------- -+--------+-------------+| BId | bname | Btypeid | Publishing | Price | PubDate | Author | ISBN |+-----+---------------------------------+

MySQL function library, this library is an external function library! This function provides common functions for working with MySQL databases, such as connecting to a MySQL server, opening a database, executing SQL statements, and so on. So the

Note: http://www.cnblogs.com/Javame/p/3685512.htmlFirst step : download and install mysql-connector-3.5x Spotlight on MySQL connection MySQL must use mysql-connector-3.5x,5.3.2 version I tried it, and I was interested to try. 1. DownloadWebsitehttp:

?Mydumper is a lightweight third-party open source tool for MySQL database backup. The backup method is a logical backup. It supports multithreading. The backup speed is much higher than the mysqldump of the original ecology and many excellent

Mysql complex SQL statements (query and delete duplicate rows), mysqlsql 1. Find duplicate rows SELECT * FROM blog_user_relation a WHERE (a.account_instance_id,a.follow_account_instance_id) IN (SELECT account_instance_id,follow_account_instance_id

101 MySQL debugging and optimization skills and MySQL debugging skills are shared. MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for