Write MySQL code to create a table with the following field name: empNo, empName, empBasicSalary, empHouseAllowance, empPhoneNo

      

Write MySQL code to create a table with the following field name: empNo, empName, empBasicSalary, empHouseAllowance, empPhoneNo

  

Answers


Benjamin
CREATE TABLE Employees (
empNo INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
empName VARCHAR(30) NOT NULL,
empBasicSalary INT(50) NOT NULL,
empHouseAllowance INT(30) NOT NULL,
empPhoneNumber INT(10) NOT NULL
)

Future Great Thinker answered the question on August 7, 2020 at 08:40


Next: Discuss the main shortcomings and failures of educational planning in the third world countries
Previous: Write MySQL code to insert at least one record into employees table table with the following fields:empNo, empName, empBasicSalary, empHouseAllowance, empPhoneNo

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions