Anonymous

Not logged in

  • Log in
SQLZoo

Explicitly enter a NULL

From SQLZoo

Namespaces

  • Page
  • Discussion

More

  • More

Page actions

  • Read
  • View source
  • History

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
SQLZoo is seeking advertisers/sponsors ()
  • Served by: bill at 2026-06-21T08:29
  • Retrieved from "https://sqlzoo.net/w/index.php?title=Explicitly_enter_a_NULL&oldid=1456"
    Category:
    • Pages using deprecated source tags

    Navigation

    • 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

    Wiki tools

    Wiki tools

      Page tools

      Page tools

        User page tools

          More

          • What links here
          • Related changes
          • Printable version
          • Permanent link
          • Page information
          • Page logs

          Categories

          Categories

          • Pages using deprecated source tags
          • Powered by MediaWiki
          • This page was last modified on 17 July 2012, at 10:47.
          • Privacy policy
          • About SQLZoo
          • Disclaimers