Explicitly enter a NULL
From SQLZOO
Jump to:
navigation
,
search
Explicitly enter a NULL.
schema:scott
DELETE
FROM
t_peep
WHERE
id
=
4677
INSERT
INTO
t_peep
VALUES
(
4677
,
NULL
)
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
Personal tools
Create account
Log in
Namespaces
Page
Discussion
Variants
Views
Read
Edit
View history
Actions
Search
Reference
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
Toolbox
What links here
Related changes
Special pages
Printable version
Permanent link
Google AdSense