Write a MySQL command for creating a table PAYMENT whose structure

Q. Write a MySQL command for creating a table PAYMENT whose structure is given below:

Table: PAYMENT

 

 
	 
Field Name
 
	 
Datatype
 
	 
Size
 
	 
Constraint
 
 
 
	 
Loan_number
 
	 
Integer
 
	 
4
 
	 
Primary key
 
 
 
	 
Payment_number
 
	 
Varchar
 
	 
3
 
	 

 
 
 
	 
Payment_date
 
	 
Date
 
	 

 
	 

 
 
 
	 
Payment_amount
 
	 
Integer
 
	 
8
 
	 
Not Null
 
 

Answer :-

Create table PAYMENT (
Loan_number int(4) primary key ,
Payment_number Varchar(3) ,
Payment_date Date ,
Payment_amount int(8) Not Null ) ;