Question

Write a MYSQL command for creating a table “PAYMENT” whose structure is
given below:
Table : PAYMENT
Field Name DateType Size Constraint
Loan_number Integer 4 Primary key
Payment_number Varchar 3
Payment_date Date
Payment_amount Integer 8 Not NULL

Answer 1

step1: first, create a database and then create the table using:

create table PAYMENT;

step2:insert your values:

insert into PAYMENT values(Loan_number int(4) primary key, Payment_number varchar(3), Payment_date DATE, Payment_amount int(8) not null)