TEXT   25
Untitled
Guest on 16th March 2023 07:30:39 AM


  1. 1)
  2. ALTER TABLE EMPLOYEE ADD SSN INT;
  3. Query OK, 0 rows affected (0.81 sec)
  4. Records: 0  Duplicates: 0  Warnings: 0
  5.  
  6. desc EMPLOYEE;
  7. +------------+-------------+------+-----+---------+-------+
  8. | Field      | Type        | Null | Key | Default | Extra |
  9. +------------+-------------+------+-----+---------+-------+
  10. | emp_id     | int(11)     | NO   | PRI | NULL    |       |
  11. | Name       | varchar(30) | NO   |     | NULL    |       |
  12. | City       | varchar(40) | YES  |     | NULL    |       |
  13. | DOB        | date        | YES  |     | NULL    |       |
  14. | aadhaar_no | int(11)     | NO   |     | NULL    |       |
  15. | SSN        | int(11)     | YES  |     | NULL    |       |
  16. +------------+-------------+------+-----+---------+-------+
  17. 6 rows in set (0.00 sec)
  18.  
  19.  
  20. 2)
  21. ALTER TABLE EMPLOYEE MODIFY COLUMN DOB YEAR;
  22. Query OK, 0 rows affected (1.32 sec)
  23. Records: 0  Duplicates: 0  Warnings: 0
  24.  
  25. mysql> DESC EMPLOYEE;
  26. +------------+-------------+------+-----+---------+-------+
  27. | Field      | Type        | Null | Key | Default | Extra |
  28. +------------+-------------+------+-----+---------+-------+
  29. | emp_id     | int(11)     | NO   | PRI | NULL    |       |
  30. | Name       | varchar(30) | NO   |     | NULL    |       |
  31. | City       | varchar(40) | YES  |     | NULL    |       |
  32. | DOB        | year(4)     | YES  |     | NULL    |       |
  33. | aadhaar_no | int(11)     | NO   |     | NULL    |       |
  34. | SSN        | int(11)     | YES  |     | NULL    |       |
  35. +------------+-------------+------+-----+---------+-------+
  36. 6 rows in set (0.00 sec)
  37.  
  38.  
  39.  
  40. 3)
  41. ALTER TABLE EMPLOYEE DROP emp_id;
  42. Query OK, 0 rows affected (0.83 sec)
  43. Records: 0  Duplicates: 0  Warnings: 0
  44.  
  45.  
  46.  
  47. mysql> DESC EMPLOYEE;
  48. +------------+-------------+------+-----+---------+-------+
  49. | Field      | Type        | Null | Key | Default | Extra |
  50. +------------+-------------+------+-----+---------+-------+
  51. | Name       | varchar(30) | NO   |     | NULL    |       |
  52. | City       | varchar(40) | YES  |     | NULL    |       |
  53. | DOB        | year(4)     | YES  |     | NULL    |       |
  54. | aadhaar_no | int(11)     | NO   |     | NULL    |       |
  55. | SSN        | int(11)     | YES  |     | NULL    |       |
  56. +------------+-------------+------+-----+---------+-------+
  57. 5 rows in set (0.00 sec)
  58.  
  59.  
  60.  
  61. 4)
  62. ALTER TABLE EMPLOYEE ADD CONSTRAINT c1 UNIQUE(SSN,aadhaar_no);
  63. Query OK, 0 rows affected (0.29 sec)
  64. Records: 0  Duplicates: 0  Warnings: 0
  65.  
  66. mysql> DESC EMPLOYEE;
  67. +------------+-------------+------+-----+---------+-------+
  68. | Field      | Type        | Null | Key | Default | Extra |
  69. +------------+-------------+------+-----+---------+-------+
  70. | Name       | varchar(30) | NO   |     | NULL    |       |
  71. | City       | varchar(40) | YES  |     | NULL    |       |
  72. | DOB        | year(4)     | YES  |     | NULL    |       |
  73. | aadhaar_no | int(11)     | NO   |     | NULL    |       |
  74. | SSN        | int(11)     | YES  | MUL | NULL    |       |
  75. +------------+-------------+------+-----+---------+-------+
  76. 5 rows in set (0.00 sec)
  77.  
  78.  
  79.  
  80.  
  81. 6)
  82.  
  83. ALTER TABLE EMPLOYEE RENAME TO PERSON;
  84. Query OK, 0 rows affected (0.15 sec)
  85.  
  86.  
  87.  
  88.  
  89. 7)
Raw Paste

Login or Register to edit or fork this paste. It's free.