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
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

  • Special pages

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