CREATE DATABASE Fruits;
Use Fruits;
CREATE TABLE Apples (
ID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(30) NOT NULL,
ShelfLife INT NOT NULL, -- 保质期（天数）
SupplierID TEXT, -- 供应商ID（文本类型，例如 "SUP-001"）
Price DECIMAL(10, 2), -- 价格（精确到分）
Sweetness VARCHAR(20)
);
INSERT INTO Apples (Name, ShelfLife, SupplierID, Price, Sweetness) VALUES
('Red Delicious   ', 30, 'SUP-001', 1.99, 'Sweet '),
('Granny Smith    ', 45, 'SUP-002', 2.49, 'Tart '),
('Golden Delicious', 25, 'SUP-001', 1.69, 'Mildly Sweet'),
('Fuji            ', 35, 'SUP-003', 2.99, 'Sweet '),
('Pink Lady       ', 30, 'SUP-002', 2.29, 'Sweet '),
('Braeburn        ', 40, 'SUP-003', 3.49, 'Tart '),
('Russet          ', 60, 'SUP-001', 1.29, 'Bitter '),
('Honeycrisp      ', 20, 'SUP-003', 3.99, 'Sweet ');

SELECT * FROM Apples;