Very simple Query (My)SQL Applet

Enter a SQL expression in the small text-line window:

This applets connects to the coffeebreak table and let's you type in some SQL expressions. It will print all cols (except SUP_ID). Examples:

    SELECT * FROM COFFEES
    SELECT * FROM COFFEES WHERE PRICE > 9
Important: A Query like 'SELECT PRICE, COF_NAME FROM COFFEES' will *not* work. See MySqlUpdateLineApplet.html.

Here is the table definition:

Database: COFFEEBREAK  Table: COFFEES  Rows: 12
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| COF_NAME | varchar(32) |      | PRI |         |       |
| SUP_ID   | int(11)     | YES  |     |         |       |
| PRICE    | float(10,2) | YES  |     |         |       |
| SALES    | int(11)     | YES  |     |         |       |
| TOTAL    | int(11)     | YES  |     |         |       |
+----------+-------------+------+-----+---------+-------+

Source: MySqlQueryLineApplet.java
D.K.S.