I am looking for some mysql query assistance from you experts
I have a table that stores all the download logs of software on my website.
The table structure is as below:
CREATE TABLE `software_downloads` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `software_id` INT(10) DEFAULT NULL, `download_date` DATETIME DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MYISAM DEFAULT CHARSET=latin1
Thanks in advance for your help.