Tools
Visual SQL Query Builder100% Client-Side
Dialect:
Database Tables
users
PKidINT
nameVARCHAR(255)
emailVARCHAR(255)
ageINT
statusVARCHAR(255)
created_atDATETIME
orders
PKidINT
user_idINT
total_amountDECIMAL(10,2)
order_statusVARCHAR(255)
order_dateDATETIME
Select Columns
•
WHERE Filters (0)
No filters added. Returning all records.
JOIN Tables (0)
No JOINs configured.
Sort & Limit
Limit:
Offset:
Generated SQL Output
mysqlQuery Explanation
Get name, email from "users", sorted by name ASC, limit to 20 records.
SELECT
`name`,
`email`
FROM `users`
ORDER BY `name` ASC
LIMIT 20;
100% Client-Side Generator