Question

Write MYSQL command to create the table SHOP with given structure and constraint :

              **Table: SHOP**

| Column_Name | Data Type(size) | Constraint |
| Fno | Int (10) | Primary Key |
| Fname | Varchar (15) | |
| Type | Char (10) | |
| Stock | Int (3) | |
| Price | Decimal (8, 2) | |

Answer 1

CREATE TABLE SHOP(Fno int(10) Primary Key, Fname Varchar(15), Type Char(10), Stock int(3), Price decimal(8,2));