DATAMODUL INFORMATION

DATABASES:
information_schema
coffeebreak
db_diakmunka
db_eep
db_publikacio
db_tiliath
dd
mysql
test
CONNECTED SERVER:localhost
USER NAME:root
SELECTED DATABASE:coffeebreak
TABLES:FIELDS:TYPES:NULLS:KEYS:DEFAULTS:EXTRAS:
coffeescof_namevarchar(32)NOPRI
sup_idint(11)NOMUL
pricefloatNO
salesint(11)NO0
totalint(11)NO0
suppliersup_idint(11)NOPRI
sup_namevarchar(20)NO
streetvarchar(20)NO
cityvarchar(20)NO
statevarchar(2)NO
zipvarchar(5)NO

DATAMODUL EXECUTED SELECT RESULT INFORMATION

SELECT STRING:SELECT * FROM coffees
cof_namesup_idpricesalestotal
1Colombian1017.9900
2Colombian_Decaf1018.9900
3Espresso1509.9900
4French_Roast498.9900
5French_Roast_Decaf499.9900

DATAMODUL EXECUTED SELECT RESULT INFORMATION

SELECT STRING:SELECT c.*, c.cof_name as cname, supplier.sup_name FROM coffees c, supplier WHERE c.sup_id=supplier.sup_id
cof_namesup_idpricesalestotalcnamesup_name
1French_Roast498.9900French_RoastSuperior Coffee
2French_Roast_Decaf499.9900French_Roast_DecafSuperior Coffee
3Colombian1017.9900ColombianAcme, Inc.
4Colombian_Decaf1018.9900Colombian_DecafAcme, Inc.
5Espresso1509.9900EspressoThe High Ground