A

Admin • 833.24K Points
Coach

Q. Which of the following is the correct syntax to add a field using alter command?

  • (A) ALTER TABLE table_name ADD field_name data type;
  • (B) ALTER TABLE table_name, field_name data type;
  • (C) ALTER TABLE field_name data type;
  • (D) None of these
  • Correct Answer - Option(A)
  • Views: 36
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

To add a field using alter statement following syntax should be followed:

ALTER TABLE table_name ADD field_name data type;

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.