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