1. 生物資訊程式語言應用 Part 4 MySQL

2. Outline • Introduction. • Installation. • Management in MySQL of phpmyadmin interface. • Login. • Create new database and table. • Database management. • Add, delete and update. • SQL in MySQL database. • Structured Query Language.

3. Introduction • Characteristics • MySQL is one of database. • To collect data, like phone number, experiment data et al. • MySQL is a digital database and can be created and maintained by users (DBMS). • Advantages. • Free (http://mysql.com). • Link with other program languages, like PHP, C/C++, Java, Perl et al. • Easy to backup your data.

4. Installation • Download AppServ package data. • http://sourceforge.net/projects/appserv/ • AppServ就是由好心人將Apache、PHP、MySQL和phpMyAdmin包起來的懶人軟體 • phpMyAdmin是一套很好用的工具，透過網頁介面可以讓我們輕鬆的存取、新增、修改MySQL資料庫的內容

5. Management in MySQL • login.

6. Management in MySQL cont. • Create new database.

7. Management in MySQL cont. • Create new table.

8. Management in MySQL cont. • Create fields in table.

9. Management in MySQL cont. • Practice. • Create your own database and table. • Create fields in your table.

10. Management in MySQL cont. • Database management – add new data.

11. Management in MySQL cont. • Database management – add new data.

12. Management in MySQL cont. • Database management – update data.

13. Management in MySQL cont. • Database management – update data.

14. Management in MySQL cont. • Database management – delete data.

15. Management in MySQL cont. • Database management – delete table.

16. Management in MySQL cont. • Practice. • Add data in your table. • Delete data in your table. • Update data in your table.

17. Management in MySQL cont. • SQL in MySQL database.

18. Management in MySQL cont. • SQL in MySQL database. • SELECT * FROM table • SELECT * FROM table WHERE conditions. • Practice.