Watch Xiao Fai teacher MySQL Video summary document

Chapter I. Orders and explanations  

show databases;	View Database
create table t (ID int,name varchar);	CREATE table
desc t;	view table structure
insert into t values (1, ' BBK ');	insert table
select * from T;	view table
delete from T;	Delete the contents of the table without deleting the table itself
view table
select * from T;	View the contents of a table

Chapter II version-related knowledge

Mysql The naming mechanism uses the 3 A number and a suffix

5.0.9 5 represents the major version number 0 represents the release level 9 represents the version number of the release line series

Stability level

Alpha indicates that the release contains a large number of new code that has not been thoroughly tested

Bata when Alpha version for at least one months no reported fatal loophole

Rc is the release representative. is a beta version that has been released for a period of time and looks like it should work, with only a small fix added.

without a suffix, this means that the version has been running in many places for some time, and there are no non-platform-specific bug reports ( GA ) version

650) this.width=650; "title=" msyqltu.jpg "alt=" wkiol1ugc6ia1uhvaabztzhfslc610.jpg "src=" Http://s3.51cto.com/wyfs02 /m02/5d/0e/wkiol1ugc6ia1uhvaabztzhfslc610.jpg "/>

Get MySQL

Www.oracle.com

http://dev/mysql.com/downloads/

MySQL Start

./bin/mysqld_safe--user=mysql &	mysql
vim/etc/init.d/mysqld  edit mysqld
mysql which path the database is installed under
Datadir=/application/mysql-5.5.32/data	Specify a MySQL where did you put the database ?

Mysql is a single-process, multi-threaded program.

Why threads are faster than processes: No replication of heap data

Chapter III Source Package File Description

SQL [[email protected] sql]# vim mysqld.cc	MSYQL Main program Directory
mysql main program that the server is running
mysql inserted source code
CC is chicken ribs h
storage engine directory, implemented handler Span style= "font-family: ' The song Body '; > abstract interface. Mainly includes the following files
archive    csv       federated  innobase  myisammrg  perfschema
federated	operation remote table
support things   general business is using this storage engine
myisam	default storage engine
mysql
/usr/src/mysql-5.5.32/libmysqld	Mysql link Library Source code

by finding Main function, you can see MySQL start-up process.

Mysql support for plug-in storage engines. (third-party companies can develop their own plug-ins, put into, can execute their own SQL engine.) )

If you want to develop your own storage cause to develop this chicken ribs.

This article from the "Clear Sky" blog, declined reprint!

Watch Xiao Fai teacher MySQL Video summary document