databaseSimilar presentations:
Database MySQL
1. Database
MySQLHayk Avdalyan
2. What is database ?
3. Files (txt, excel and etc.)
4.
5. Table
6. MySQL
1. MySQL Community Serverhttp://dev.mysql.com/downloads/mysql/
2. MySQL Workbench
http://dev.mysql.com/downloads/workbench/
7. MySQL Create Database Command
Example:8.
9. Create table syntax
10. User table example
11. INSERT INTO Statement
OR12. Insert example
13. UPDATE Statement
14. Update example 1
15. Update example 2
16. DELETE Syntax
17. Delete example
18. Is your brain still with you ?
19. SELECT Statement
20.
21. And now ?
22. Library database
23. Authors - Countries
Author1. Id
many to one relationship
Country
2. Name
1. Id
3. Country_id
2. Name
one to many relationship
24. Create Table Country
25. Add countries
26. Create Table Authors
27. Add authors
28. Inner join
29. Show all authors and their countries
30. Bu ha ha ha …
31. Table books
Book1. Id
2. Name
3. ISBN
4. Release_date
But Book can have many authors