ONE Active Server Pages Product Home Page Developer Site Version


Working with SQL Statements

The DBMS interface can be used to query a database using SQL statements. SQL statements are displayed in the left pane of the DBMS interface, and corresponding properties are displayed in the right pane. Clicking the words SQL Statements in the interface displays a list of SQL statements that have been created and saved. You can also click the plus (+) sign to expand the list of SQL statements. Clicking a specific SQL statement displays that statement.

SQL statements are computer specific, which means that SQL statements created when using DBMS on one computer will not be visible when DBMS is accessed from another computer. You can add, save, and execute the most commonly used SQL statements (SQL statements are saved in DBMS, not in your database). This section describes how to add, edit, execute, and delete SQL statements.

Note icon Note The actions you can take are governed solely by the privileges granted to you by the MySQL database administrator.

In this section:

Adding SQL Statements

Editing SQL Statements

Executing SQL Statements

Deleting SQL Statements