Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
14 Cards in this Set
- Front
- Back
|
Dodawanie wierszy do tabeli |
INSERT INTO table_name VALUES (value1,value2,value3,...); INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...); |
|
|
Zmiana danych w tabeli |
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value; |
|
|
Usuwanie danych z tabeli |
DELETE FROM table_name WHERE some_column=some_value; |
|
|
Dodawanie wiersza z innego zapytania (SELECT) |
SELECT column_name(s) INTO newtable [IN externaldb] FROM table1; |
|
|
Dodawanie wiersza z innego zapytania (INSERT) |
INSERT INTO table2(column_name(s)) SELECT column_name(s)FROM table1; |
|
|
Tworzenie tabeli |
CREATE TABLE table_name( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size),....); |
|
|
Usuwanie tabeli |
DROP TABLE table_name |
|
|
Wildcard - dowolny ciąg znaków lub brak znaków |
% |
|
|
Wildcard - jeden znak |
_ (podkreślenie) |
|
|
Wildcard - znaki z listy |
[charlist] |
|
|
Wildcard - znaki spoza listy |
[^charlist] or [!charlist] |
|
|
Tworzenie indeksu |
CREATE INDEX index_name ON table_name (column_name) |
|
|
Tworzenie unikatowego indeksu |
CREATE UNIQUE INDEX index_name ON table_name (column_name) |
|
|
Tworzenie widoku |
CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition |
