MYSQL QUESTION Create the following two tables include scree

MYSQL QUESTION
Create the following two tables. (include screenshot) of show columns from customer;and show columns from salesperson; as deliverables.

Customer

custid int(3) auto_increment

fname char(10)

lname char(10)

address char(10)

telnum int(10)

salespersonid int(3)

Salesperson

salesid int(3) auto_increment

fname char(10)

lname char(10)

officenum char(4)

telnum char(10)

What is the MySQL query needed to expand customer.custid to int(10)?

What is the MySQL command to reduce customer.salesperson id to int(1)?

How do you change customer.telnum to a character data type?

Solution

alter table Customer modify custid int(10); alter table Salesperson modify salesid int(10); alter table Customer change telnum telnum varchar(255);