27 lines
430 B
Markdown
27 lines
430 B
Markdown
|
# SQL baze podataka
|
||
|
|
|
||
|
|
# Tabele
|
||
|
|
|
||
|
|
Tabela
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
# Baza
|
||
|
|
|
||
|
|
- vise tabela u jednoj bazi
|
||
|
|
- pristup preko mreze
|
||
|
|
- SQL jezik
|
||
|
|
- pozivanje upita iz drugih jezika
|
||
|
|
|
||
|
|
# SQL
|
||
|
|
|
||
|
|
- SELECT username,password FROM userstable
|
||
|
|
- SELECT * FROM userstable
|
||
|
|
- SELECT password FROM userstable WHERE username='korisnik1'
|
||
|
|
- INSERT INTO userstable (username, password) VALUES (newuser3, pass1)
|
||
|
|
|
||
|
|
# Bezbednost
|
||
|
|
|
||
|
|
- SQL injection
|
||
|
|
- PDO
|