Database MySQL презентация

What is database ?

Files (txt, excel and etc.)

Table

MySQL
MySQL Community Server
http://dev.mysql.com/downloads/mysql/
MySQL Workbench
http://dev.mysql.com/downloads/workbench/

MySQL Create Database Command
Example:

Create table syntax

User table example

INSERT INTO Statement
OR

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
Author
Id
Name
Country_id
Country
Id
Name
one to many relationship
many to one relationship

Create Table Country

Add countries

Create Table Authors

Add authors

Inner join

Show all authors and their countries

Bu ha ha ha …

Table books
Book
Id
Name
ISBN
Release_date
But Book can have many authors

Add books

Many to many

Solving many to many relationship

Final Query