New Pub in Melksham!

Open bar tonight! ...
• Have a Vodka. That contains 11.5 cc of alcohol
• Have a Gin. That contains 10.75 cc of alcohol
• Have a Leffe Blond. That contains 56.25 cc of alcohol

Copyright, price list hereafter ...

This is the setup ....
 

mysql> use avoncliff;
Database changed
mysql> create table drinks (did int primary key not null auto_increment,
    ->       name text,
    ->       alcontent float,
    ->       volume int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into drinks (name, alcontent, volume)
    ->  values ("Vodka",46.0,25),("Gin",43.0,25),("Leffe Blond",7.5,750);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> 



Training sample © 2024, WELL HOUSE CONSULTANTS LTD
This is http://www.wellho.net/demo/yellowlion.php
See source code here • More examples - same topic here
Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
Phone: +44 (0) 1225 708 225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net