📊 MySQL
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
💬 Discuss
✅ Correct Answer: (A) ALTER TABLE table_name ADD field_name data type;

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

ALTER TABLE table_name ADD field_name data type;

Explanation by: Jatin Dubey
To add a field using alter statement following syntax should be followed:

ALTER TABLE table_name ADD field_name data type;

💬 Discussion

📊 Question Analytics

👁️
172
Total Visits
📽️
3 y ago
Published
🎖️
Jatin Dubey
Publisher
📈
83%
Success Rate