-- create a table
CREATE TABLE stock (
 moblD varchar(50)primary key,
    brand varchar(50)not null,
    model varchar(30)not null,
    color varchar(30)not null,
    memSize varchar(10)not null,
    price float not null,
    stockNum int not null
);