Select The Query Operation

• Select
• Insert
• Update
• Delete

Table Name

Select Particular Columns

Column Names (Separated by Comma) Name, Email, Address, City, PostalCode, Country

Where Clause

Separated by comma with an Operator City != "New York" AND Country IS NOT NULL

Order By Clause

Conditions

Ascending Descending

Add More Remove

Group By Clause

Conditions (Input Field Names Separated By Comma)

Having Clause

Conditions

COUNT(CustomerID) > 5

Join Tables

Join Types INNER JOIN LEFT JOIN RIGHT JOIN CROSS JOIN

Name of Table 2

Field in Both Tables as The Relationship.

Add More Table Joins

Add More Remove

LIMIT

Table Name to Insert Data

Input the Column Names and Values to Insert

Add More Remove

Add Another Entry Delete Entry

Table Name to Update Data

Input the Column Names and Values to Update

Add More Remove

Where Clause

Separated by comma with an Operator GNI > 13000

Table Name to Delete Data From

Where Clause

Separated by comma with an Operator Country = "Norway"

Auto

Generate

Reset

sql-generator.sql