The SQL Word - SELECT, The rule for your search (like finding a specific name)., The name of the table where the data lives., Choose the specific fields you want to see on the screen., The SQL Word - FROM, The rule for your search (like finding a specific name)., The name of the table where the data lives., Choose the specific fields you want to see on the screen., The SQL Word -WHERE, The rule for your search (like finding a specific name)., The name of the table where the data lives., Choose the specific fields you want to see on the screen., The SQL Word - INSERT INTO, Remove a record completely from the database., Put your final list in a specific order., Add a brand new record to the table., Change information that is already in the table., The SQL Word - UPDATE, Remove a record completely from the database., Put your final list in a specific order., Add a brand new record to the table., Change information that is already in the table., The SQL Word - DELETE FROM, Remove a record completely from the database., Put your final list in a specific order., Add a brand new record to the table., Change information that is already in the table., The SQL Word - ORDER BY, Remove a record completely from the database., Put your final list in a specific order., Add a brand new record to the table., Change information that is already in the table., The SQL Word - ASC, Both rules must be true at the exact same time., Sort from lowest to highest, or alphabetical (A to Z)., Only one of the choices needs to be true (like choosing between two teams)., Sort from highest to lowest, or most recent date first (Z to A)., The SQL Word - DESC, Both rules must be true at the exact same time., Sort from lowest to highest, or alphabetical (A to Z)., Only one of the choices needs to be true (like choosing between two teams)., Sort from highest to lowest, or most recent date first (Z to A)., The SQL Word -AND, Both rules must be true at the exact same time., Sort from lowest to highest, or alphabetical (A to Z)., Only one of the choices needs to be true (like choosing between two teams)., Sort from highest to lowest, or most recent date first (Z to A)., The SQL Word - OR, Both rules must be true at the exact same time., Sort from lowest to highest, or alphabetical (A to Z)., Only one of the choices needs to be true (like choosing between two teams)., Sort from highest to lowest, or most recent date first (Z to A)., What is a Primary Key (PK)?, A secret password to log into the computer., A unique code that identifies one specific record so there are no duplicates., The name of the entire database., What is a Foreign Key (FK)?, A Primary Key from one table that is copied into another table to build a link., A key used by characters from different countries., A field that only allows you to type numbers.

SQL Keyword Match

autors:
Drukāt
Iegult

Līderu saraksts

Vizuālais stils

Iespējas

Pārslēgt veidni

Atjaunot automātiski saglabāto: ?