introduction to mysql

This blog post aims to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion. First of all, let's introduce the source

The creation and merging of mysql tables is similar to that of partition tables. It is a feature of mysql that combines multiple myisam tables with the same structure into a virtual table. The surviving engine must be merge, the query from a merged

To check whether the event scheduler is currently enabled Show variables like 'event _ schedount '; Enable Event ViewerSet global event_scheduler = 1; Create eventSyntax:Create event [if not exists] event_nameOn schedule schedule[On completion [NOT]

The MySQL installation file has been widely used but is constantly updated. Here we will introduce how to set and use the MySQL Installation File to help you install and update the MySQL Installation File System. Configure MySQL under Fedora5 (MySQL

Author/Translator: ye Jinrong (Email:), Source: http://imysql.cnFor reprinting, please indicate the author/translator and the source, and cannot be used for commercial purposes. violators must investigate. 译者：叶金荣（Email:），来源：MySQL手册版本

Below, we write an introduction to the MySQL tutorial SQL injection and anti-injection example based on my programming experience. Introduction to SQL anti-injection: SQL query is a text language used to interact with the user, SQL uses the

Go out security considerations, the default MySQL is to allow only native links, and not allow other hosts to connect through the client tools. To resolve this problem at this point, there are three ways to resolve it. A, authorized logins to other

Advantages and disadvantages of MySQL log backups Benefits: is to revert to a point in time, or an operation SQL statement Disadvantage: A large log file is generated MySQL log recovery method in Windows 1. Open MySQL LogFind [mysqld] in the

MySQL logical architecture: Concurrency control: implemented by locks Read Lock: Also called shared lock, read lock does not block each other. A a,b,c,d can read the table after the lock table but cannot write the table. Write Lock: Also called

set,enum data types are object of string type, where the set can contain up to 64 elements and can be arbitrarily taken to the elements in the collection. An enum is an element that can only be taken to a wood in a collection, containing up to 65,536

InnoDB is a transaction-safe storage engine designed to draw on many Oracle architecture ideas, and in general, in OLTP applications, InnoDB should be the first storage engine for the core application table. InnoDB was developed by a third party

MySQL is a real multi-user, multi-threaded SQL database server. SQL (Structured Query language) is the most popular and standardized database language in the world. MySQL is implemented as a client/server architecture, consisting of a server daemon

Translation statement: This article is from Sams teach yourself MySQL in the book part of the content, by Mark Maslakowski English original version ownership of the original author, the Chinese part of the translation has a slight additions and

Reference: https://my.oschina.net/u/255939/blog/505598MySQL replication is a MySQL server (slave) that replicates logs from another MySQL server (master) and then parses the logs and applies them to itself, similar to data Guard in Oracle.MySQL

MySQL's replication capability is the basis for large-scale, high-performance applications. Share the read load. Horizontal expansionis copied through the binary log and is asynchronous.Only the modified events that were successfully executed are

1. Creating a database means dividing a space in the database system to store the corresponding data 1. Create database name 2. Display database: Show databases;2. Delete Database 1. Syntax: drop database name; 3. Database Storage engine (table type)

Simple introduction to MySQL's index typefirst, introduce the type of indexMySQL Common indexes are: Primary key index, unique index, normal index, full-text index, composite indexPRIMARY key (primary key index) ALTER TABLE ' table_name ' Add

Binlog basic definition: A binary log, also a binary log, that records SQL statements that occur to or potentially change data, and is stored in a binary form on disk;Role: MySQL functions similarly to Oracle's archive logs, which can be used to

There are two main ways to backup MySQL: Text Format backup: Command: mysqldumpDump Files: Dump fileMain content: Database structure and data (create Talbe/insert) Binary backup: This type of backup is done by copying files directly.

I checked it online. There are two methods: the first is the most earthy method: Use the like statement, and the second is the full-text index. I will search it online: how to get better full-text search results in MySQLMany Internet applications