|
Question |
Answer |
|
start learning
|
|
WHERE GROUP BY HAVING ORDER BY [ASC][DESC] LIMIT OFFSET
|
|
|
|
start learning
|
|
SELECT col1 FROM table1 UNION SELECT col1 FROM table2
|
|
|
złączenie tabel część wspólna start learning
|
|
SELECT * FROM tab1 NATURAL JOIN tab2 SELECT * FROM tab1 t1 JOIN tab2 t2 ON t1. kol1 = t2. kol2
|
|
|
złączenie tabel suma tablie lewej z częścią wspólną obu tabel start learning
|
|
SELECT * FROM tab1 NATURAL LEFT JOIN tab2 SELECT * FROM tab1 t1 LEFT JOIN tab2 t2 ON t1. kol1 = t2. kol3
|
|
|
Ilość wartości – zlicza NULL Ilość unikatowych wartości wyrażenia start learning
|
|
count(*) count(distinct wyrażenie)
|
|
|
|
start learning
|
|
CREATE [OR REPLACE] VIEW view_name AS SELECT
|
|
|
|
start learning
|
|
ALTER VIEW nazwa_widoku as SELECT
|
|
|
|
start learning
|
|
|
|
|
inicjalizacja zmiennej oraz odwołanie start learning
|
|
SET @zmienna = 10 SELECT @zmienna
|
|
|
|
start learning
|
|
grant all privileges ON DBname.* TO 'username' @ 'localhost'
|
|
|
|
start learning
|
|
SELECT user, host FROM mysql. user
|
|
|
|
start learning
|
|
create user 'username'@'localhost' identified by 'password'
|
|
|
nadaj wszystkie uprawnienia start learning
|
|
grant ALL PRIWILEGES on name_db.* to 'username'@'localhost'
|
|
|
nadaj uprawnienia do kolumny name start learning
|
|
grant SELECT (name) on name_db.* to 'username'@'localhost'
|
|
|
|
start learning
|
|
grant SELECT, UPDATE, DELETE, INSERT on name_db.* to 'username'@'localhost'
|
|
|
|
start learning
|
|
show grants for 'username'@'localhost'
|
|
|
|
start learning
|
|
|
|
|
zamknięcie połączenia z bazą danych start learning
|
|
|
|
|
