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 > 9Important: 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 | | | | +----------+-------------+------+-----+---------+-------+