创建表：

    create table store
    (
    id int unsigned auto_increment
    primary key,
    uname varchar(20) null,
    money double null,
    nums int null,
    address varchar(30) null,
    bayType varchar(10) null
    );

    插入数据：

    | INSERT INTO coco.store (id, uname, money, nums, address, bayType) VALUES (1, ‘草莓’, 10.5, 12, ‘河南郑州’, ‘货车’);
    INSERT INTO coco.store (id, uname, money, nums, address, bayType) VALUES (2, ‘香蕉’, 11.2, 15, ‘河南漯河’, ‘火车’);
    INSERT INTO coco.store (id, uname, money, nums, address, bayType) VALUES (3, ‘西瓜’, 16.5, 16, ‘河南洛阳’, ‘飞机’); | | —- |