	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

Wizard for creating SQL statements for MySQL and MariaDB databases

The SQL wizard is part of the SQL editor

Creating simple SQL statements using the SQL wizard:

Selection of the SQL statement - available:
SELECT:	Selection of options, database, table or view (FROM), table columns for output, WHERE clause and sorting (ORDER BY).
UPDATE:	Selection of options, database, table (FROM), table columns for value assignment and WHERE clause.
INSERT:	Selection of options, database, table and table columns for value assignment.
REPLACE:	Selection of options, database, table and table columns for value assignment.
DELETE:	Selection of options, database, table, table columns for WHERE clause and sorting (ORDER BY). Sorting only makes sense with a LIMIT clause - this must be added in the SQL editor.
TRUNCATE:	Selection of database and table. This statement deletes all data from a table.
CALL:	Calling procedures. Selection of database and procedure with parameter input.
SHOW:	Display of database definitions with selection and entry of parameters.
START TRANSACTION:	No parameters to choose from.
COMMIT:	No parameters to choose from.

	Copy the generated SQL statement into the SQL editor.
	Add the generated SQL statement to the content of the SQL editor.
	Copy the generated SQL statement to the clipboard.
	Clear wizard for new entry.

	Select table column for data output or data assignment.
	Select table column for data restriction (WHERE).
	Select table column for ascending sorting.
	Select table column for descending sorting.
	Remove table column from selection.

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer