Create a table with below details.
Table name depart_<<your lab username>> with below columns in same order.
depid of type integer with max value of 255 as auto incrementing primary key.
depname of type character string of variable-length of max length 150. It should be not null
depcity of type character string of variable-length of max length 150. It should be not null
depstreet of type character string of variable-length of max length 100. It should be not null
depopendate of type datetime
Login to MySQL prompt and switch to correct database. Prepare the table creation SQL query and run it.
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
Loading comments...