MySQL

1, open My.ini file, locate default-Storage-engine=InnoDB This line, change it to default-storage-engine=MyISAM.* * * My.ini must be in ANSI format.2.delete the data directory in the MySQL installation directoryIb_logfile0Ib_logfile13. Locate the

The MySQL extension library operates the MySQL database in the following steps:1: Get the connection.2: Choose the Library.3: Set the action encoding.4: Send SQL instructions (MySQL database can be divided into four kinds of instructions:1:DDL: Data

With the soft connection changed the location of the/var/lib/mysql, and set the Mysql.mysql permissions, but found still cannot start.Discover/var/log/mysqld.log150308 16:16:02 [Warning] Can ' t ' Create test File/var/lib/mysql/gadget.lower-test15030

For two nights, start with MySQL Basic installation and installation directory structure.MySQL General 3 mode installs: RPM, binary, sourceThe simplest is the RPM installation mode, the default automatic configuration is OK. The simplest way to

Recently using Python to do the project with MySQL, some python crawl some of the data into MySQL, but there is a problem, because the data crawled from the outside with ' other irregular data, if you directly call the method of inserting data will

Classification notes and descriptions data type description binary data types store non-sub-characters and text data BLOBs available to store image text data type character data including any combination of letters, symbols,

What is information_schema in MySQLWhen you install or use MySQL, you will find a INFORMATION_SCHEMA database in addition to the database you have installed. Information_schema database is what to do with it, using WordPress blog friends may want to,

One, Zoning Concepts  partitioning allows multiple parts of a single table to be allocated across the file system according to the specified rules. Different parts of the table are stored as separate tables in different locations. MySQL supports

1, Reason: because of MySQL to connect the client DNS reverse resolution 2, disable DNS resolution, add Skip-name-resolve 3 in/etc/my.cnf,reverse parsing instructions: The so-called inverse parsing is this:When MySQL receives the

Before the system background alarm too many, simple query the following reason, mainly is the data volume is large, the number of queries and database performance is low caused. At that time, a simple analysis of the database configuration and a few

1. DownloadFtp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.36.tar.gzftp://mirror.switch.ch/mirror/mysql /downloads/mysql-5.5/mysql-5.5.36.tar.gz.md52. Create MySQL database directory2.1. Create a partitionAdd a piece of hard

First go to add remove program, find MySQL select Uninstall.Then clear the relevant files, the main files to be purged are:First, the installation directory of MySQL, generally C:\Program files directory.Second, the MySQL data storage directory,

[MySQL] how to install and deploy the source code SourceCode of MySQL5.5Install CMAKE Wget http://www.cmake.org/files/v2.8/cmake-VERSION.tar.gz # Tar zxvf cmake-VERSION.tar.gz # Cd cmake-VERSION #./Bootstrap # Make # Make installInstall mysql

Mysql Case sensitivity 1. create table name (name VARCHAR (10 )); For this table, the results of the following two queries are the same by default:   The Code is as follows: SELECT * from table name where name = 'clip '; SELECT * from table name

How to restore the root user deleted by mistake in mysql The root account is accidentally deleted when some default accounts are cleared after the database is installed. The new root account after the flush privileges forgets to grant any

SQL optimization solution for querying duplicate data in mysql When querying non-case-insensitive data in mysql, subqueries are often used, and the upper function is used in subqueries to convert conditions into uppercase. For example:   The Code

Thoroughly Delete Mysql from Centos (rpm and yum installation) I used centos6 and mysql to solve various problems. I want to reinstall a brand new mysql. After yum removes mysql-server mysql and then installs it again, I cannot get a clean mysql,

Examples of mysql connection usage This article describes the usage of mysql connections between left and right. Share it with you for your reference. The details are as follows: Use an example to parse the left, right, and Inner Connections of

How to install Mysql5.5 in Centos5.5 Install mysql in centos these days. Record the installation process for future reference. Cmake is required for Mysql5.5.37 installation, and cmake is required for MySQL 5.6 and later versions. Install

Mysqldecimal and numeric data typesDECIMAL (M, D) Example: salary DECIMAL (5, 2)In this example, 5 (precision) represents the number of important decimal digits, and 2 (data range (scale) represents the number of digits after the decimal point. In