编辑代码

CREATE DATABASE SuperMarket;
USE SuperMarket;
CREATE TABLE Products (
    ID        VARCHAR(10) PRIMARY KEY,     
    Name      VARCHAR(100),     
    Price     DECIMAL(10, 2),  
    ShelfLife DATE   -- 保质期截止日期
);
INSERT INTO Products (ID, Name, Price, ShelfLife) VALUES
('SKU-001', 'Apple  ', 15.99, '2025/12/31'),
('SKU-002', 'Bread  ', 8.99, '2025/06/15'),
('SKU-003', 'Milk   ', 6.49, '2025/05/30'),
('SKU-004', 'Cookie ', 12.99, '2025/09/30'),
('SKU-005', 'Spinach', 4.99, '2025/04/20'),
('CHU-006', 'yogurt ', 9.99, '2025/10/15'),     
('CHU-007', 'nuts   ', 24.99, '2026/03/30'),      
('CHU-008', 'paper  ', 12.99, '2026/12/31'); 

SELECT *
FROM Products;