امیرحسین کاظمنژاد - دانشگاه علم و صنعت ایران
دیتابیس | فایل | |
---|---|---|
ساختارهای پیچیده | ||
دادههای مرتبط | ||
تعداد بالا | ||
استفادههای همزمان |
(Server-based)
(No server-client Architecture)
DBMS
RDBMS
DataBase
Table
Schema
Database Management System
Relational Database Management System
$ sudo apt-get install lamp-server^
$ sudo apt-get install phpmyadmin
Linux
Windows
download & install XAMPP at http://wampserver.com/
OS X
http://goo.gl/VH5Vyz
SQL
Structured Query Language
Primary Key
Auto increment
A primary key is a field in a table which uniquely identifies each row/record in a database table. Primary keys must contain unique values. A primary key column cannot have NULL values.
Auto-increment allows a unique number to be generated when a new record is inserted into a table.
INSERT INTO table_name (column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);
.1
INSERT INTO table_name
VALUES (value1, value2, value3,...valueN);
.2
SELECT column_name,column_name
FROM table_name;
.1
SELECT * FROM table_name;
.2
SELECT column1, column2, columnN
FROM table_name
WHERE [condition]
.1
SELECT column1, column2, columnN
FROM table_name
WHERE coulmn_name operator value
UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];
DELETE FROM table_name
WHERE [condition];
SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];
SELECT column1, column2
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2
ORDER BY column1, column2
Foreign Key:
The relationship between 2 tables matches the Primary Key in one of the tables with a Foreign Key in the second table.
One to one
One to many
Many to many
SELECT table1.column1, table1.column1,.., table2.column1, table2.column1,...table2.columnN
FROM table2
INNER JOIN table1
ON [condition];