Many-to-many

One-to-many

One-to-one binary

One-to-one

Restrict

Set-to-Null

Cascade

Matching

GRANT Patient TO ‘mary’@ ‘localhost’;

GRANT SELECT ON PATIENT TO ‘mary’@ ‘localhost’;

GRANT SELECT PATIENT TO ‘mary’@ ‘localhost’;

GRANT PATIENT ON SELECT TO ‘mary’@ ‘localhost’;

To prevent two users from viewing the same record during potential updates.

To ensure that users are logged in on a local machine.

To let multiple clients easily find and negotiate with each other.

To prevent two users from modifying the same record at the same time.

CREATE DATABASE IF NOT EXISTS db_name;

IF NOT EXISTS CREATE DATABASE db_name;

IF NOT EXISTS db_name;

CREATE DATABASE IF NEW db_name;

AND item_price = 20;

AND item_price >= 20;

WHERE item_price = 20;

WHERE item_price >= 20;

The associative entity

A table’s intersection data

The rows to be included in the result set

A range of included columns

WHERE patient_id >=1000;

WHERE patient_id => 1000;

WHERE patient_id = 1000+;

WHERE patient_id > 1000;

SUM item_id;

GROUP BY item_id;

COUNT item_id;

ORDER BY item_id;

NULL

INSERT

SELECT

ALTER

It removes rows from a table.

It removes columns not named in the column list.

It removes views.

It removes columns from a table.

The VALUES list must contain a value for each non-null valued column in the table.

The VALUES list must contain a value for each attribute/column in the table.

The INSERT INTO portion of the statement must generate a LOAD DATA statement.

THE INSERT INTO portion of the statement must refer to a sampdb database table.

customer_id INT NOT NULL,

PRIMARY KEY (invoice_id),

CREATE TABLE Invoice (

FOREIGN KEY (customer_id) REFERENCES Customer (customer_id)

CREATE TABLE new_tbl_name INTO tbl_name;
INSERT INTO new_tbl_name;

INSERT TABLE new_tbl_name SELECT tbl_name;
INSERT INTO new_tbl_name LIKE tbl_name;

CREATE TABLE new_tbl_name LIKE tbl_name;
INSERT INTO new_tbl_name SELECT * FROM tbl_name;

INSERT TABLE new_tbl_name LIKE tbl_name;
SELECT tbl_name;

TRUNCATE TABLE

DELETE TABLE

REMOVE TABLE

DROP TABLE

To limit many-to-many relationship between various entities and attributes

To restrict access to persons retrieving and modifying sensitive information

To move complicated security routines to subqueries

To add complexity to encryption techniques

SELECT

INSERT

ALTER

NULL

ALTER custview AS

WHERE VIEW custview IS

CREATE VIEW custview AS

VIEW custview

ALTER VIEW

CHANGE VIEW

MODIFY VIEW

UPDATE VIEW

Unauthorized access to the view is restricted

The view is discarded

The data is discarded

The patient table data is discarded

TO

WITH GRANT OPTION

REQUIRE

FOR

Cascaded delete

Foreign key constraint

Referential delete

Dynamic update

FOREIGN KEY (customer_id) (index_columns)

FOREIGN KEY (customer_id) REFERENCES customer (customer_id)

FOREIGN KEY [table_name](customer_id)

FOREIGN KEY = (customer_id) REFERENCES customer (customer_id)

ALTER TABLE child
ADD FOREIGN KEY (parent_id) ON DELETE CASCADE;

ALTER TABLE child
ADD FOREIGN KEY WHERE parent (parent_id) ON DELETE CASCADE;

ALTER TABLE child
ADD FOREIGN KEY (parent_id) REFERENCES parent (parent_id) ON DELETE CASCADE;

ALTER TABLE child
ADD FOREIGN KEY (parent_id) WHERE parent (parent_id) ON DELETE CASCADE;

DROP INDEX ‘PRIMARY’ ON tbl_name;

DROP INDEX WHERE PRIMARY KEY = ON tbl_name;

DROP INDEX ‘PRIMARY KEY’ ON tbl_name;

DROP INDEX PRIMARY KEY tbl_name;

The set-to-null delete rule

The restrict rule

The default delete rule

The cascade delete rule

The row values for two individual columns

The attributes that are changeable

The column values for two individual rows

The data to be duplicated.

DELETE FROM Invoice WHERE invoice_id = *;

DELETE FROM Invoice;

DELETE FROM Invoice WHERE invoice_id == *;

DELETE ALL FROM Invoice;

It selects only the rows in Table 1 that are the same as Table 2

It selects the rows in both Tables that have numerical data that is left-aligned.

It selects the rows in Table 1 numbered the same as Table 2.

It selects all of the rows in Table 1 (regardless of if there is a match in Table 2) and the matching rows in Table 2.

(SUBQUERY = customer_id

(FIND customer_id

(SELECT customer_id

(SUBQUERY customer_id