A

Admin • 833.24K Points
Coach

Q. Which of these is used to ensure a column value automatically increments for each new row?

  • (A) AUTO_INCREMENT
  • (B) SERIAL
  • (C) INCREMENTAL
  • (D) SEQUENCE
  • Correct Answer - Option(A)
  • Views: 20
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

AUTO_INCREMENT is MySQL's attribute for automatic numeric incrementing on insert. SERIAL is a shorthand in some systems (in MySQL it's an alias for BIGINT AUTO_INCREMENT NOT NULL UNIQUE). INCREMENTAL is not a keyword. SEQUENCE objects are used in some RDBMS (like PostgreSQL) but not as a built-in object in MySQL prior to newer versions where sequences might be supported differently.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.