MySQL Online Compiler

Run MySQL queries online with our MySQL database tool. Perfect for learning MySQL-specific features, testing queries, and database development.

mysql Online Compiler

-- MySQL Online Compiler
-- Welcome to MySQL practice environment

-- Create database (simulated)
-- CREATE DATABASE company_db;
-- USE company_db;

-- Create table with MySQL-specific features
CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    category ENUM('Electronics', 'Clothing', 'Books', 'Home') DEFAULT 'Electronics',
    price DECIMAL(10,2) NOT NULL,
    stock_quantity INT UNSIGNED DEFAULT 0,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Insert sample data
INSERT INTO products (name, category, price, stock_quantity, description) VALUES
('iPhone 15', 'Electronics', 999.99, 50, 'Latest Apple smartphone'),
('MacBook Pro', 'Electronics', 1999.99, 25, 'Professional laptop'),
('Cotton T-Shirt', 'Clothing', 29.99, 100, 'Comfortable cotton t-shirt'),
('Programming Book', 'Books', 49.99, 75, 'Learn programming fundamentals'),
('Coffee Maker', 'Home', 89.99, 30, 'Automatic coffee brewing machine');

-- MySQL-specific queries
SELECT * FROM products;

-- Using MySQL functions
SELECT 
    name,
    price,
    CONCAT('$', FORMAT(price, 2)) as formatted_price,
    UPPER(category) as category_upper,
    DATE_FORMAT(created_at, '%Y-%m-%d') as creation_date
FROM products;

-- Conditional logic with CASE
SELECT 
    name,
    price,
    stock_quantity,
    CASE 
        WHEN stock_quantity > 50 THEN 'High Stock'
        WHEN stock_quantity > 20 THEN 'Medium Stock'
        WHEN stock_quantity > 0 THEN 'Low Stock'
        ELSE 'Out of Stock'
    END as stock_status
FROM products;

-- Group by with HAVING clause
SELECT 
    category,
    COUNT(*) as product_count,
    AVG(price) as avg_price,
    SUM(stock_quantity) as total_stock
FROM products 
GROUP BY category
HAVING avg_price > 50;

-- Subquery example
SELECT name, price
FROM products
WHERE price > (SELECT AVG(price) FROM products);

-- Update with MySQL functions
UPDATE products 
SET updated_at = NOW()
WHERE stock_quantity < 30;

-- Full-text search (simulated)
SELECT name, description
FROM products
WHERE description LIKE '%programming%' OR name LIKE '%programming%';

-- Window functions (MySQL 8.0+)
SELECT 
    name,
    category,
    price,
    ROW_NUMBER() OVER (PARTITION BY category ORDER BY price DESC) as price_rank
FROM products;

-- JSON operations (MySQL 5.7+)
SELECT 
    name,
    JSON_OBJECT('price', price, 'stock', stock_quantity, 'category', category) as product_json
FROM products
LIMIT 3;

Output

Click "Run" to execute your code and see the output here...

-- MySQL Online Compiler
-- Welcome to MySQL practice environment

-- Create database (simulated)
-- CREATE DATABASE company_db;
-- USE company_db;

-- MySQL-specific queries
SELECT * FROM products;

-- Subquery example
SELECT name, price
FROM products
WHERE price > (SELECT AVG(price) FROM products);

-- Update with MySQL functions
UPDATE products 
SET updated_at = NOW()
WHERE stock_quantity < 30;

-- Full-text search (simulated)
SELECT name, description
FROM products
WHERE description LIKE '%programming%' OR name LIKE '%programming%';

-- Window functions (MySQL 8.0+)
SELECT 
    name,
    category,
    price,
    ROW_NUMBER() OVER (PARTITION BY category ORDER BY price DESC) as price_rank
FROM products;

-- JSON operations (MySQL 5.7+)
SELECT 
    name,
    JSON_OBJECT('price', price, 'stock', stock_quantity, 'category', category) as product_json
FROM products
LIMIT 3;

MySQL Features

MySQL 8.0 features
Window functions and CTEs
JSON data type support
Full-text search capabilities
Stored procedures and triggers

About MySQL

MySQL is one of the world's most popular open-source relational database management systems. It's widely used for web applications, data warehousing, and e-commerce platforms.

MySQL offers excellent performance, reliability, and ease of use. It supports ACID transactions, replication, and clustering, making it suitable for both small applications and large-scale systems.

Use our MySQL online compiler to practice MySQL-specific syntax, test database queries, or learn advanced features like JSON operations and window functions.