©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Creating MySQL, MariaDB views, CREATE VIEW

Creating MySQL and MariaDB views (CREATE VIEW)

Views Creating MySQL views is part of the view management
Edit MySQL views

Module for editing MySQL views:

You can search and mark in the SQL editor.

SELECT statement can be executed and parsed.

SELECT test Runs the view's SELECT statement as a test and displays the data result.
Explain SELECT Executes EXPLAIN SELECT of the view as a test and outputs the analysis result.
Save changes Saves the new view to the database.
Searching in SQL Editor:
Search SQL text Find and highlight terms in the SQL Editor.
Delete markers Delete search markers.
Jump to previous marker Jump to previous marker.
Jump to next marker Jump to next marker.
Views head:
Name: Name of the view.
Column names: Specification of the column names for the query result of the view.
Creator: Creator of the view.
Algorithm: Choice of algorithm.
SQL security: Choice of SQL security.
Check option: Selection of the check option.
Learn more about editing SQL scripts: SQL editor
More information about MySQL views can be found here: mysql.com und mariadb.com
Updated: 2023-09-16ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer