Sql Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Столбец, КОЛОННА

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Строка

A

Row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Запись

A

Record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Первичный ключ

A

Primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Внешний ключ

A

Foreign key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Создать таблицу

A

CREATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Изменить таблицу/др

A

ALTER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Удалить таблицу/др

A

DROP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Извлечь данные

A

SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Создать, вставлять запись

A

INSERT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Изменить, обновить запись

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Удалить запись

A

DELETE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Установить

A

SET

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Добавить

A

ADD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Авто приращение

A

AUTO_INCREMENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Поле

A

Field

17
Q

Данные не будут повторяться

A

DISTINCT

18
Q

Лимит записей

A

LIMIT

19
Q

Сортировка (возрастание)

A

ORDER BY

20
Q

Сортировка по убыванию

A

ORDER BY имя таблицы DESC

21
Q

В диапазоне от и до

A

BETWEEN _ AND_

22
Q

Равно

A

IN (1,1,1,1)

23
Q

Показать такое

A

LIKE ‘%1%’

24
Q

Значение по умолчанию
Время добавления

A

DEFAULT
CURRENT_TIMESTAMP