Write a MYSQL command for creating a table “PAYMENT” whose structu

1.	Write a MYSQL command for creating a table “PAYMENT” whose structure isgiven below:Table : PAYMENTField Name DateType Size ConstraintLoan_number Integer 4 Primary keyPayment_number Varchar 3Payment_date DatePayment_amount Integer 8 Not NULL
Answer» 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)

Write a MYSQL command for creating a table “PAYMENT” whose structure isgiven below:Table : PAYMENTField Name DateType Size ConstraintLoan_number Integer 4 Primary keyPayment_number Varchar 3Payment_date DatePayment_amount Integer 8 Not NULL

Answer»

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)