Flashcards
INSERT UPDATE DELETE statements
Cards in this deck (6)
- 1TO UPDATE THE RECORD YOU NEED TO WRITE ALL THE COLUMN NAMES AND INCLUDE VALUES FOR ALL OF THEMFALSE
- 2I CAN CHANGE THE DATA TYPE FOR DATA COLUMN USING UPDATE STATEMENT EX. CHANGE PHONE NUMBER FIELD TO BE STORED AS A TEXTFALSE
- 3BY RUNNING THIS STATEMENT DELETE SURNAME FROM STAFF; COLUMN SURNAME WILL BE DELETED FROM TABLEFALSE - ALL TABLE RECORDS WILL BE DELETED
- 4I RUN UPDATE STATEMENT AND I WANT TO GO BACK TO PREVIOUS DATASHEET VIEW BEFORE I RUN MY QUERY I CAN RESTORE THE PREVIOUS VIEW BY HITTING BACK ARROW KEY IN MS ACCESSFALSE
- 5YOU CAN WRITE INSERT STATEMENT WITHOUT DEFINING ALL OF THE COLUMNS AND ITS VALUES WITHIN TABLETRUE
- 6WHEN INSERT STATEMENT WILL NOT WORK IF YOU DEFINE ONLY SOME COLUMNS FROM DATA TABLE?WHEN PRESENCE CHECK VALIDATION IS ENABLED FOR COLUMN WHICH IS NOT DEFINED IN INSERT STATEMENT
Information
- Description
- A level Computing Flashcards on INSERT UPDATE DELETE statements, created by ADRIANNA DAR on 30/11/2020.
- Created by
- ADRIANNA DAR
- Views
- 0
- Rating