Tutorials to .com

Tutorials to .com » Database » MySQL Tutorial

MySQL Tutorial Articles


1: On MySQL Replication (copying) the basic principles of
1, MySQL Replication to copy the process of MySQL replication (replication) is an asynchronous replication from a MySQL instace (called Master) copy to another MySQL instance (known as Slave). Copy the entire operation process by the completion of ...

2: Memcache testing on
Simply put, under the memcache. Prior to this, suggest that you read this article very interesting. As for the parameters of the principle, as well as I do not start more than described, memcached-h will have a look or a lot of GOOGLE. I explain ...

3: MySQL database directory under Linux more what is the use of paper?
Blog reproduce again today, though very busy, or you want to write a Blog, laugh, first of all, is still the same I would like to thank first Sery Today I found a Mysql database directory under Linux a lot of multi-Mysql-bin.0000X these documents, ...

4: asp.net upload image (bytes) to the mysql database
This is the page button click event protected void Button1_Click(object sender, EventArgs e) { string tid = Utils.getRandom(32); Stream mystream = this.FileUpload1.PostedFile.InputStream; int length = this.FileUpload1.PostedFile.ContentLength; byte[...

5: Uninstall and reinstall mysql configuration services
MYSQL install fails, usually because the server may be installed and not completely uninstall MYSQL. MYSQL can start in case of the following: whether the use of double-click or command-line mysqld.exe, not reflected. Show My Computer -> manage ...

6: paging mysql stored procedure that can spread the total number of records
Recently used to write mysql + asp.net web site, as has support for mysql stored procedure, then so common as paging things, of course, you use stored procedures But to find a number of online and found a feature of all - is not the total number of...

7: mysql input of Chinese characters and Chinese characters jsp page display problem
When I connect mysql display problem encountered by the characters is the beginning of the database simply can not input Chinese data, I built a table, insert data, prompted the error: Date too long for column ... After a multi-search, to find a so...

8: MySQL support so that the method InnoDB Storage Engine
InnoDb description: InnoDb storage engine, support services, line lock, foreign key. InnoDb designed to handle large amount of data to provide the best . InnoDb to provide their own cache (buffer pool) is also cache data and indexes. Innodb storag...

9: mysql detailed instructions in the use of show
This paper mainly introduces the mysql database under the command of the main show Usage: a. show tables or show tables from database_name; - shows the current database of all the name of the table. b. show databases; - show all mysql database nam...

10: MySQL database using the whole process of the environment
In the use of MySQL is required before the establishment of a database environment to create a data table, first of all, we need to install the database environment, namely MySQL. 1, download MySQL MySQL is the official website of http://www.mysql...

11: Comparison of three methods MYSQL Insert: insert a single, LOAD DATA, stored procedure
Today, for bulk data insert MYSQL tested, focusing on learning. Is common to each insert, LOAD DATA commands, this stored procedure call in three ways, as compared with Use of time, to tell you different ways to insert, efficiency also have been di...

12: MySQL query to a field of all records of non-repetition
N is now assumed that the following records show that the book is called id author title 1 aaa AAA 2 bbb BBB 3 ccc CCC 4 ddd DDD 5 eee AAA Would now like to record from the five inquiries will not repeat all the title records select distinct ...

13: MySQL database to increase the specified location in the field
MySQL itself is the basic syntax, I give one example here. view plaincopy to clipboardprint? mysql> - test database in the specified location to increase the field mysql> drop table if exists t; Query OK, 0 rows affected (0.06 sec) mysql&...

14: Nested on the use of MySQL cursor
Group a few days ago someone asked MySQL nested cursor can use, that can not be taken for granted, then the next test, but still can be, Ah, ah can not take it for granted. Examples are as follows: CREATE PROCEDURE curdemo() NOT DETERMINISTIC CONTAI...

15: MySQL Architecture - Transaction Processing
Transaction Processing Before the transaction, you can not know the database system has so many advanced features. A thing is a set of SQL queries. Be seen as this group of atoms. That is a separate unit of work. If the database engine can be appli...

16: MySQL structure - multi-version concurrency control
Multi-version concurrency control Multiversion Concurrency Control Most of the MySQL storage engine, such as InnoDB, Falcon, and is not PBXT the use of simple line-lock mechanism. They are used combined with a line lock to raise complicated techno...

17: MySQL structure - MySQL storage engine-MyISAM
MyISAM MyISAM is the default MySQL storage engine. MyISAM features in terms of performance and provides a good compromise solution. Characteristics, full-text indexing, compression, GIS function. MyISAM does not support the things and the line lock...

18: MySQL structure - MySQL storage engine-InnoDB
InnoDB Things to deal with InnoDB support, it deals with a number of short-term things, these things are often not the successful implementation of the rollback. InnoDB is a MySQL storage engine of the most popular. Common needs of non-matter engin...

19: MySQL structure - MySQL storage engine
This part briefly MySQL storage engine, will not talk about depth, because throughout the course runs through the MySQL storage engine details. This course is not entirely the guidance manual, detail can refer to the official MySQL documentation. My...

20: MySQL structure - MySQL logical framework
MySQL logical structure (MySQL's Logical Architecture) A good picture would be easier to understand your various components of MySQL work. Pictures Most of the services covered by a layer of MySQL is not unique to technology. They are serving ...


Page 1 of 35
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]