Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL PRIMARY KEY

MySQL PRIMARY KEY

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
12 cards
()
Section 1

Preview this deck

You specify the primary key...

Front

1 / 12

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (12)

Section 1

(12 cards)

You specify the primary key...

Front

during table creation. It may occur with the definition of a specific column or at the end of the CREATE TABLE statement

Back

UNIQUE KEY

Front

creates a constraint for a column whose values must be unique. MySQL allows null values in the UNIQUE index.

Back

In case the primary key consists of multiple columns...

Front

you must specify them at the end of the CREATE TABLE statement

Back

The data type of a PRIMARY KEY should be an ________.

Front

integer

Back

A PRIMARY KEY column often has the ________ attribute.

Front

AUTO_INCREMENT

Back

PRIMARY KEY

Front

a column or a set of columns that uniquely identifies each row in the table

Back

A primary key must contain ________ values. If the primary key consists of multiple columns, the combination of values in these columns must be ________.

Front

unique, unique.

Back

AUTO_INCREMENT

Front

an attribute that generates a unique sequence for the key automatically

Back

A table can have only one ________.

Front

PRIMARY KEY

Back

PRIMARY KEY constraints with ALTER TABLE syntax

Front

ALTER TABLE table_name ADD PRIMARY KEY(primaryKeyColumn);

Back

You have to declare the primary key column with the ________ attribute.

Front

not null

Back

A primary key column cannot contain ________ values.

Front

Null

Back