SQL: 05 - INSERT, DELETE

 

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



 

Tags