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.

Form Example

Example 1(b): Results after using MySQL Generator

Form Example

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.