Syntax
Example
UPDATE medialist
SET MediaType=’marker’
WHERE ID=’1001’
DELETE FROM
Syntax
Example
DELETE FROM medialist
WHERE ID=’1002’
DELETE TABLE CONTENTS
Syntax
DELETE FROM table_name
DELETE * FROM table_name
Example
DELETE FROM medialist
DELETE * FROM medialist
- Log in to post comments
Tags