Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

7 cards

()

Section 1

Preview this deck

Insert into a table

Front

1 / 7

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (7)

Section 1

(7 cards)

Insert into a table

Front

Insert into table_name values(value1, value2);

Back

Relational algebra

Front

Defines operations on a table (select, project, union, cross product

Back

Creating a View

Front

Create view view_name as select columns from table;

Back

Delete from table

Front

Delete from table_name where something;

Back

What is a table

Front

A set of data elements using a model of columns and rows

Back

Candidate key

Front

is a minimal superkey - that is, a superkey without any unnecessary attributes.

Back

Creating a trigger

Front

Create trigger trigger_name before insert on table

Back