Question 16Write a MySQL command for creating a table PAYMENT whose structure is given below:Table: PAYMENTField NameData typeSizeConstraintLoan_numberInteger4Primary keyPayment_numberVarchar3Payment_dateDatePayment_amountInteger8Not Null

Question

Bright Tutorials · Accepted Answer

CREATE TABLE PAYMENT (
    Loan_number INT(4) PRIMARY KEY,
    Payment_number VARCHAR(3),
    Payment_date DATE,
    Payment_amount INT(8) NOT NULL
);

Field Name	Data type	Size	Constraint
Loan_number	Integer	4	Primary key
Payment_number	Varchar	3
Payment_date	Date
Payment_amount	Integer	8	Not Null

Database Query using SQL — Question 16

Question 16