MYSQL program to create table, drop cust. name, insert cust. salary, change data type.
1. Write MYSQL command to create table show below
FIELD NAME DATA TYPE CONSTRAINTS
CUSTOMER ID INT PRIMARY KEY
CUSTOMER NAME VARCHAR(20) NOT NULL
CUSTOMER ADDRESS VARCHAR(20) NOT NULL
FILL DETAILS INTO IT AND DO THE FOLLOWING
A. DELETE THE CUSTOMER NAME
B. ADD NEW FIELDS CUSTOMER SALARY
C. CHANGE DATA TYPES OF CUSTOMER ID TO CHAR(20).
For code pdf : https://drive.google.com/drive/folder...
Access to MySQL Full course Playlist : • MySQL full couse with Notes.