MySQL

This is my personal use of web-based articles to learn MySQL process notes, I hope to be helpful to everyone.1. Defualt Key WordsCREATE TABLE emp(id INT DEFAULT 12)2. Set the self-growth column (auto_increment)create table temp2( id INT primary

MySQL View database objects (SQL command Summary)Data objects include tables, views, triggers, and so on (view statistics must go into the INFORMATION_SCHEMA database)For an example of viewing table-related information, proceed as follows1. Using

First, the RPM installation required mysql-rpm package FLASHFXP upload to/usr/local/below: Link: http://pan.baidu.com/s/1i3rb2Gt Password: 5pk81:#file/sbin/init//View system is a 32-bit or64 bit my is 32-bit download 32-bit MYSQL-RPM pack2:# rpm-i

Move directly past is, encounter problems and then modify according to the prompts.You typically need to remove the MySQL service that is already installed before you move the command:Mysqld.exe--removeTo reinstall the service after the move, the

DDL: Database Definition languagePrimarily used to define databases, tables, views, indexes, triggers, and moreCreate: Primarily for creating databases, creating tables, and creating viewsAlter: Primarily used to modify the definition of a table,

Get MARIADB's installation package pass xftp to the root directory on the website 2. Expand the Mariadb file   tar xf mariadb-5.5.42-linux-x86_64.tar.gz -C /usr/local3. Help document Location/usr/local/mariadb-5.5.42-linux-x86_64/install-binary4

SELECT * from Information_schema.plugins\gThe InnoDB version of MySQL 5.6.3-M6 is 1.2.3View the version method, you can see the large versionSELECT * from Information_schema.plugins;SELECT @ @innodb_version;MySQL 5.5:MySQL Plugin Status Date5.5.18 1.

Many times we want to get a continuous set of data from a row in the middle, for example, starting from line 10th to query 10 rows of data, which is used more in the forum database, because the Forum's reply is often hundreds of, need pagination

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to

MySQL commonly used storage engine is myisam, InnoDB, memory, MERGE , Where InnoDB provides a transaction security table, the other storage engines are non-transactional security tables. &NBSP myisam is the default storage engine for MySQL.

1, stop MySQL service, uninstall MySQL2, delete the installation directory and data storage directoryNote:Default installation path: C:\Program Files\mysql (not necessarily in the C drive to see which disk you are installing)Database File storage

1. The configuration my.cnf is invalid and the MySQL process cannot be startedStarting with version 5.1.7, the MY.CNF direct configuration master-host and other master-slave configuration options (still supported replicate-do-db) are no longer

Original address: http://www.cnblogs.com/RicCC/archive/2009/09/25/mysql.htmlStorage Engine Attribute MyISAM Heap BDB InnoDB Transactions No No Yes Yes Lock

In the case of large capacity data, especially CLOB data, an exception may occur: "Packets larger than Max_allowed_packet is not allowed".This is because the MySQL database has a system parameter Max_allowed_packet, and its default value is 1048576 (

Today re-installed MySQL, to the last step of the times wrong, is the third small step that hit the fork. At that time, I felt the trouble, I remember the original problem, but also deleted things, but also restarted.Later inadvertently found that

1 definitionsThe Bin-log log records all of the DDL and DML statements, but does not include the query statement, which is saved as an event and describes the process of changing the data, which plays an important role in recovering data from a

Resolving MySQL data case sensitive issues with binary:Binary is not a function, it is a type conversion operator, and it is used to force the string following it to be a binary string, which can be understood to be case-sensitive when comparing

Another methodWindows:1. Admin login system, stop MySQL service or end mysqld-nt process2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:/mysql/, CMD enters the command line3. Run

Performance of mysqlcharvarcharblobtext Char Fixed Length, up to 255 bytes. If the storage space is not full, a space will be filled on the right side of the data. Varchar The maximum length is 65536 bytes. When the varchar length is smaller

How to solve the problem caused by modifying datadir in Mysql? mysqldatadir Centos6.2, stop mysqld, modify the location of/etc/my. cnf datadir, start mysqld and prompt FAILED to view logsCopy codeThe Code is as follows:120609 11:31:31 mysqld_safe