I have a table name flextable with columns containing:
timestamp: application: module: users: comments: batchdate: batchtime.

I created a second table name license with columns containing:
free_license: application: batchdate: batchtime:

Question:
Data for column "free_license" for the second table will be parse from a text file.
I would also like to have data store from flextable into application,batchdate and batchtime columns and as foreign key.
What would reccomend to accomplish this task?I could be wrong in this stratagy but that is why I am here.
thanks
-t

To make foreign keys in MySQL, you need to convert the table from the ISIAM format to INNODB, i know this is easily possible using phpMyAdmin, but have no idea how to do it in shell

Hi,

Let me preface this with: I've never used mySQL, so what I'm going to say here may be way offbase. That said:
Why are you defining those columns for the second table? You should be able to display them directly from the 1st table. Define a database that contains the 2 tables.

flextable with columns containing:
timestamp: application: module: users: comments: batchdate: batchtime.

license with columns containing:
free_license: key2flextable

and then simply select the appropriate columns based on the key with a join

Vinny