Question

Write a MYSQL command for creating a table "BANK " whose structure is given below.

Field Name	Datatype	Size	Constraint
Acct_Number	Integer	4	Primary Key
Name	Varchar	3
BirthDate	Date
Balance	Integer	8	Not Null

Answer 1

CREATE TABLE BANK (Acct_Number INTEGER(4) PRIMARY KEY, Name VARCHAR(3), BirthDate DATE, Balance INTEGER(8) NOTNULL);