JavaScript Example:
CREATE DATABASE IF NOT EXISTS shopDB;
USE shopDB;
CREATE TABLE sales (
id INT AUTO_INCREMENT PRIMARY KEY,
product_name VARCHAR(50),
quantity INT,
price DECIMAL(10,2),
sale_date DATE
);
INSERT INTO sales (product_name, quantity, price, sale_date)
VALUES
('Laptop', 2, 800.00, '2025-05-28'),
('Phone', 5, 300.00, '2025-05-28'),
('Tablet', 3, 450.00, '2025-05-27');
SELECT * FROM sales;
SELECT * FROM sales WHERE product_name = 'Laptop';
SET SQL_SAFE_UPDATES = 1;
UPDATE sales
SET quantity = 10
WHERE product_name = 'Phone';
Back to Home