Скачать или смотреть CRUD Operations using Node JS, Express and MySQL | RESTful Web API | Postman + XAMPP Part One

CRUD Operations using Node JS, Express and MySQL | RESTful Web API | Postman + XAMPP
create table and insert
-- Create the table
CREATE TABLE product (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(255),
brand VARCHAR(255),
category VARCHAR(255),
price DOUBLE,
description TEXT,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);

-- Insert imaginary products
INSERT INTO product (name, brand, category, price, description) VALUES
('Laptop', 'XYZ Electronics', 'Electronics', 999.99, 'Powerful laptop for all your computing needs.'),
('Smartphone', 'ABC Mobiles', 'Electronics', 499.99, 'Feature-rich smartphone with a high-quality camera.'),
('Coffee Maker', 'Home Appliances Inc.', 'Home Appliances', 79.99, 'Brew your favorite coffee at home with this easy-to-use coffee maker.'),
('Running Shoes', 'Sports Gear Co.', 'Sports and Outdoors', 89.99, 'Comfortable and durable running shoes for your active lifestyle.');