MySQL Forums :: General :: Time Manipulation In Query

Dear Rick,
Ok manage to get it via the commandline.About the innodb pool buffer from your experience how much is best you suggest based on the ram sizes? I will shrink the driverID to smallint. About the latitude and longitude I have tried float as per your suggestion last time but I notice I miss the after 3rd place of the decimal so that is why I swap to double. About the rest of the 3 tables what do you want me to post?

SHOW TABLE STATUS LIKE 'tblAssociate' \G
*************************** 1. row ***************************
           Name: tblAssociate
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 117
 Avg_row_length: 420
    Data_length: 49152
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2011-10-14 02:50:08
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment: InnoDB free: 26624 kB
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE '%buffer%';
+-------------------------------+---------+
| Variable_name                 | Value   |
+-------------------------------+---------+
| bdb_log_buffer_size           | 262144  |
| bulk_insert_buffer_size       | 8388608 |
| innodb_buffer_pool_awe_mem_mb | 0       |
| innodb_buffer_pool_size       | 8388608 |
| innodb_log_buffer_size        | 1048576 |
| join_buffer_size              | 131072  |
| key_buffer_size               | 8384512 |
| myisam_sort_buffer_size       | 8388608 |
| net_buffer_length             | 16384   |
| preload_buffer_size           | 32768   |
| read_buffer_size              | 131072  |
| read_rnd_buffer_size          | 262144  |
| sort_buffer_size              | 2097144 |
+-------------------------------+---------+
13 rows in set (0.00 sec)