Database
What is database ?
Files (txt, excel and etc.)
Table
MySQL
MySQL Create Database Command
Create table syntax
User table example
INSERT INTO Statement
Insert example
UPDATE Statement
Update example 1
Update example 2
DELETE Syntax
Delete example
Is your brain still with you ?
SELECT Statement
And now ?
Library database
Authors - Countries
Create Table Country
Add countries
Create Table Authors
Add authors
Inner join
Show all authors and their countries
Bu ha ha ha …
Table books
Add books
Many to many
Solving many to many relationship
Final Query
Result
1.68M
Категория: Базы данныхБазы данных

Database MySQL

1. Database

MySQL
Hayk Avdalyan

2. What is database ?

3. Files (txt, excel and etc.)

4.

5. Table

6. MySQL

1. MySQL Community Server
http://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

OR

12. 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

Author
1. 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

Book
1. Id
2. Name
3. ISBN
4. Release_date
But Book can have many authors

32. Add books

33. Many to many

34. Solving many to many relationship

35. Final Query

36. Result

English     Русский Правила