A

Admin • 832.27K 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: 23
  • 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.