Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/cookbook_1.sql

Created September 13, 2023 06:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save machinelearningplus/e8396f7bcd47ad18980db12c0bd41440 to your computer and use it in GitHub Desktop.
Save machinelearningplus/e8396f7bcd47ad18980db12c0bd41440 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cookbook_1.sql
CREATE TABLE Items (
id INT AUTO_INCREMENT PRIMARY KEY,
Category VARCHAR(255),
Price DECIMAL(5,2)
);
INSERT INTO Items (Category, Price) VALUES
('Fruit', 2.5),
('Fruit', 3.0),
('Veg', 1.0),
('Veg', 1.5),
('Grain', 0.5),
('Grain', 0.6);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment