I have a table with 9 columns, one is an auto_increment for primary key. Data set: 2004-09-21 10:35:50,2004-09-21 10:45:48,tcp,111.111.111.111,80,222.222.222.222,1555,4700
Currently I just dump everyting into one table and query it that way. I was hoping to learn how to place the data into different tables. This will help the data files and index files from getting to large. Im just not sure where to start??? Currently I just use load data infile command from a shell script. I was wanting to have the datetime's stored in a different table, but have the same primary key as the data from the table with the Ip's and such. And help is great.... Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
