MySQL Key 29 codes

1 A primary key on a column can be created by replacing PRIMARY KEY with UNIQUE in the table definition, provide

2 Add Foreign Key Rules

3 Add PRIMARY KEY or UNIQUE directly to the end of the column definition

4 Add the foreign key by using the following

5 Adding primary key for not null column

6 Alter table to Add an PRIMARY KEY

7 Another way to enforce uniqueness is to add a UNIQUE index rather than a PRIMARY KEY to a table

8 Cascade delete

9 Create a multiple-column primary key using UNIQUE, if the columns are declared NOT NULL

10 Create a primary key on the last_name and first_name columns using a PRIMARY KEY clause

11 Create a table t that contains an id column thats NOT NULL and declared as a primary key by means of a PRIMAR

12 Define and use primary key

13 Define foreign key

14 Defining Primary Keys

15 Drop primary key

16 If you were creating a primary key on more than one column, you would include both of those column names in th

17 On delete set null

18 Reference foreign key

19 RESTRICT update and delete

20 Setting a Primary Key 1

21 Setting a Primary Key 2

22 Setting a Primary Key 3

23 To drop an index that is not a PRIMARY KEY, you must specify the index name

24 Two foreign keys

25 Two ways to declare primary key when creating the table

26 Use a FOREIGN KEY constraint to define the foreign key

27 Use a PRIMARY KEY constraint

28 Using KEY modifier

29 Using three column as the primary key