Create a table with below details.
Table name depart 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 and run the SQL on the prompt.
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...