To create the temperatures database with one table inputdata,
we proceed as follows:

$ means at command prompt
# means comment

1. $ sudo mysqld_safe 
   # we start the deamon

2. $ sudo mysqladmin create temperatures
   # we created the database temperatures

3. $ sudo mysql
   mysql> use temperatures
   # in mysql monitor we use the db

4. mysql> create table inputdata
    -> (k INT, p CHAR(20), d DATE, t TIME, temp REAL);
   mysql> explain inputdata;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| k     | int(11)  | YES  |     | NULL    |       | 
| p     | char(20) | YES  |     | NULL    |       | 
| d     | date     | YES  |     | NULL    |       | 
| t     | time     | YES  |     | NULL    |       | 
| temp  | double   | YES  |     | NULL    |       | 
+-------+----------+------+-----+---------+-------+