Boolean Education Yan Shiba MySQL introductory video tutorial resources (source code courseware) recommended

"Boolean Education Yan Shiba MySQL Introductory Video Tutorial" is a basic introductory course for MySQL. With the continuous development of MySQL, using MySQL+php to build websites has become a mainstream web development technology. If you want to learn dynamic web design, then it is recommended You choose php+mysql. This course is designed to help beginners of mysql database get started quickly. If you have needs in this area, then start the journey of learning mysql with us! ! !

Course playback address: http://www.php.cn/course/195.html

This video was created by Yan Shiba. The teacher’s teaching style is:

The teacher’s lectures are vivid, witty, witty, and touching. A vivid metaphor is like the finishing touch, opening the door to wisdom for students; an appropriate humor brings a knowing smile to students, like drinking a glass of mellow wine, giving people aftertaste and nostalgia; a philosopher's aphorisms, cultural references Proverbs are interspersed from time to time in the narration, giving people thinking and warning.

The more difficult point in this video is the concept of storage engine:

The data in MySQL is stored in files (or memory) using various technologies. middle. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels and ultimately provides a wide range of different functionality and capabilities. By choosing different technologies, you can gain additional speed or functionality that improves the overall functionality of your app.

How to determine which storage engines are available?

You can use the display engine command in MySQL (assuming it is MySQL server 4.1.2 or above) to get a list of available engines.

mysql> show engines;   
+------------+---------+----------------------------------------------------+   
| Engine | Support | Comment |   
+------------+---------+-----------------------------------------------------+   
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |   
| HEAP | YES | Alias for MEMORY |   
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |   
| MERGE | YES | Collection of identical MyISAM tables |   
| MRG_MYISAM | YES | Alias for MERGE |   
| ISAM | NO | Obsolete storage engine, now replaced by MyISAM |   
| MRG_ISAM | NO | Obsolete storage engine, now replaced by MERGE |   
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |   
| INNOBASE | YES | Alias for INNODB |   
| BDB | NO | Supports transactions and page-level locking |   
| BERKELEYDB | NO | Alias for BDB |   
| NDBCLUSTER | NO | Clustered, fault-tolerant, memory-based tables |   
| NDB | NO | Alias for NDBCLUSTER |   
| EXAMPLE | NO | Example storage engine |   
| ARCHIVE | NO | Archive storage engine |   
| CSV | NO | CSV storage engine |   
+------------+---------+-------------------------------------------------------+

16 rows in set (0.01 sec) This table shows the full list of available database engines and whether they are supported in the current database server.

Here we also recommend downloading source code resources: http://www.php.cn/xiazai/learn/1858

This video is shared with everyone Courseware:

1. join.html

2. Boolean Education-mysql.ppt

3. Boolean Education -mysql notes.doc

4. Commonly used functions.txt

5. Review cheats.html

6. Exercise Prepare.sql

The above is the detailed content of Boolean Education Yan Shiba MySQL introductory video tutorial resources (source code courseware) recommended. For more information, please follow other related articles on the PHP Chinese website!