Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92)

The following list was taken from the MySQL Web site; you might want to check there for updated information (www.mysql.com). I have removed some items that you are not likely to ever use, and I have expanded certain items for clarity.

  • “The field attributes AUTO_INCREMENT, BINARY, NULL, UNSIGNED and ZEROFILL.” [1]

    [1] .“5 How standards-compatible is MySQL? / 5.1 MySQL extensions to ANSI SQL92.” MySQL Reference Manual for Version 3.23.25-beta [online]. August 2000 [cited 1 September 2000]. Available from Internet: http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html

    • The AUTO_INCREMENT attribute may be applied to any integer column. When you attempt ...

Get MySQL Building User Interfaces now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.