Update Adding-Comment-to-Table-Columns-in-MySQL.sql

Mateen0007 · web-flow · commit 7bb21c5a3b05 · 2024-11-24T13:05:14.000+05:00
diff --git a/table-operations/Adding-Comment-to-Table-Columns-in-SQL/Adding-Comment-to-Table-Columns-in-MySQL.sql b/table-operations/Adding-Comment-to-Table-Columns-in-SQL/Adding-Comment-to-Table-Columns-in-MySQL.sql
@@ -1,8 +1,8 @@
 --Adding Teachers Table with Comments to University database
 CREATE TABLE Teachers ( 
   teacher_id INT NOT NULL COMMENT 'Unique identifier for each teacher', 
-  first_name VARCHAR(50) COMMENT 'Teacher's first name', 
-  last_name VARCHAR(50) COMMENT 'Teacher's last name', 
+  first_name VARCHAR(50) COMMENT 'first name of the teacher', 
+  last_name VARCHAR(50) COMMENT 'last name of the teacher', 
   department_id INT COMMENT 'Department id describing where the teacher belongs to', 
-  hire_date DATE COMMENT 'Teacher's hiring date' 
-  );
+  hire_date DATE COMMENT 'the date the teacher was hired' 
+ );
