INSERT and DELETE Reference
From SQLZoo
Jump to navigation
Jump to search
How to put records into a table, change them and how to take them out again.
INSERT and DELETE Operations
INSERT new records
UPDATE existing records
DELETE records
INSERT ... SELECT
INSERT: Not all fields need to be specified
INSERT a date
Explicitly enter a NULL
INSERT problems: reference
DELETE problems: reference
INSERT problems: incompatible formats
String contains a quote '
Data normalization
DataWars:
Practice Data Science/Analysis with
+100 Real Life Projects
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
British English
Views
Read
View source
View history
More
SELECT basics
quiz
SELECT from world
quiz
SELECT from nobel
quiz
SELECT in SELECT
quiz
SUM and COUNT
quiz
JOIN
quiz
More JOIN
quiz
Using NULL
quiz
Self JOIN
quiz
Reference
NoSQL zoo
SELECT
Functions
SELECT .. WHERE
SELECT .. GROUP BY
SELECT .. JOIN
SELECT .. SELECT
INSERT .. VALUES
INSERT .. SELECT
UPDATE
DELETE
CREATE TABLE
CREATE VIEW
CREATE INDEX
DROP
ALTER
UNION
LEFT JOIN
NULL
Tools
What links here
Related changes
Special pages
Printable version
Permanent link
Page information