book MySQL Generator Examples
On this page, you will find examples on how to use MySQL Generator.
Example 1(a): Before using MySQL Generator
You may click on the images below to launch the Photo gallery and to see the screenshots in full page view.
Example 1(b): Results after using MySQL Generator
Instructions for using MySQL Generator:
-
Syntax: Select the SQL Syntax that you want to be generated automatically for you.
-
Columns 1: This would be the comma separated list of column names from Table 1.
-
Table 1: The first table from which you need the columns to be selected.
-
ADD: Lets you add more tables to the query so that you can perform actions on them.
-
Add Join: Lets you add joins on different tables for querying data.
-
Add Where: Lets you add WHERE clause for querying data.