Structured Query Language [SQL]

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

FOREIGN KEY

A field (or collection of fields) in one table that uniquely identifies a row of another table.

Tuple

A row in a database.

PRIMARY KEY

A unique identifier for each record in a database table.

INSERT

This SQL statement is used to add new data into a database.

CREATE

This SQL statement is used to create a table in a database.

DROP

This SQL statement is used to delete a table from a database.

DELETE

This SQL statement is used to delete rows in a table.

WHERE

This SQL statement is used to return data which meets specified requirements.

SELECT

This SQL statement is used to select data from a database.

ORDER BY

This SQL statement is used to sort the result-set by one or more columns and is ascending by default.

UPDATE

This SQL statement is used to update data records in a database.

CASCADE

Whatever happens to the master table, will effect the child table.


Set pelajaran terkait

International Relations - Unit 2

View Set

Abeka 4th grade spelling list 25 (Mr. Holder) EBA

View Set

Biology for a Changing World Chapter 19

View Set

World History: Unit 5- A World In Conflict Exam

View Set

1.3 Physical and Chemical Properties

View Set

Effective Leading Citizens: Qualities of an Effective Leader

View Set