Question

Q.17 Write MySql command to create a table CANDIDATE with the following specification
Table : CANDIDATE
DOB
DATE
Field Name | CNUM
Type VARCHAR
Width 8
Description Candidate number of the
candidate
CNAME
VARCHAR
30
Name of the
candidate
Date of Birth of the
Candidate​

Answer 1

Query:

It goes like if you have already selected a database to make table in, if not run Use Database_name first.

create table Candidate( DOB date, Cnum Varchar (8), Cname Varcher (30));