MySQL Query Practice

Light Dark
SELECT * FROM employee INSERT INTO employee UPDATE employee DELETE FROM employee JOIN employee & department Subquery example GROUP BY example

Tables

employee
department

Fields

Query Builder

Drag tables and fields here

Generated Query:

SELECT * FROM ...

Results

0 rows returned

Your query results will appear here.

Sample Data

emp_id emp_name emp_salary dept_id

Quick Query Examples

SELECT * FROM employee
Filter employees
Join tables
GROUP BY
Subquery