Difference between revisions of "SQL Browser"

Revision as of 20:16, 14 November 2011

Designer > Data > Objects > [SQL Browser]

The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

How it works

The navigation pane on the left shows all of the tables in your database.
Clicking the arrow next to one expands the tree, showing the columns in the table
Double-clicking a table populates the statement pane with a default query (SELECT *) from that table.
Clicking the triangle-button on the right runs the query.

Considerations

SQL syntax is not case-sensitive, except for table names and field names.
It's a good idea to enclose table names in back-ticks (`), in case the table name turns out to be in the (fairly lengthly) list of SQL Reserved Words.

For example:

SELECT * FROM `ORDER`

(When you double-click a table name, the backticks are added for you.)

Learn more

@@ Line 14: / Line 14: @@
 ;Considerations:
 :* SQL syntax is not case-sensitive, except for table names and field names.
-:* If the table name is one of the [[SQL Reserved Words]], then it must be enclosed in back-ticks (<tt>`</tt>).
+:* It's a good idea to enclose table names in back-ticks (<tt>`</tt>), in case the table name turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
-:: For example, "Order" is a reserved word in SQL (it's part of the "ORDER BY" clause), so a query on a table named "Order" looks like this:
+:: For example:
 ::: <tt>SELECT * FROM `ORDER`</tt>
-:: Without the backticks, you get an error like this:
+:: (When you double-click a table name, the backticks are added for you.)
-:::<tt>Encountered "Order" at line 1, column 15. Was expecting (...</tt>
-::which means that parser found a word it recognized, but didn't find the things it expected to see before it got to that word.
 ;Learn more:
 :* [[SQL Syntax]]
 :* [[SQL Functions]]