Shulou(Shulou.com)06/03 Report--

This article mainly gives you a brief talk about MySQL indexed view transactions, storage engine MyLSAM and InnoDB related knowledge, related professional terms you can check the Internet or find some related books to supplement, here we do not dabble in, let's go straight to the topic, hope that MySQL indexed view transactions, storage engine MyLSAM and InnoDB related knowledge this article can bring you some practical help.

After the function of the index has set up the appropriate index, the database uses a variety of fast positioning techniques, which can greatly speed up the query rate, especially when the table is very large, or when the query involves multiple tables, using the index can speed up the query thousands of times; it can reduce the IO cost of the database, and the index can also reduce the sorting cost of the database; by creating a unique index to ensure the uniqueness of the data in the data table. It can speed up the connection between tables; when using grouping and sorting, the grouping and sorting time can be greatly reduced; 1, enter the database, create the database, create the table [root@master2] # mysql-uroot-p # # enter the database Enter password: # # enter the password Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > create database school; # # create database schoolQuery OK, 1 row affected (0.00 sec) mysql > use school # # use database Database changedmysql > create table info (# # create table-> id int (4) not null primary key auto_increment, # # set primary key, automatically add-> name varchar (10) not null, # # name type varchar is not empty-> address varchar (50) default 'nanjing', # # default Nanjing-> age int (3) not null) Query OK, 0 rows affected (0.02 sec) 2, insert data into the table

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.