Hi am really new with php mysql, i need help pls.
I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me how can i insert the huge data from my list to mysql.
Here is the structure of sql for the software.
--
-- Table structure for table `email_users`
--
CREATE TABLE IF NOT EXISTS `email_users` (
`user_id` int(15) NOT NULL AUTO_INCREMENT,
`category_id` int(10) NOT NULL,
`user_name` varchar(200) NOT NULL,
`user_email` varchar(255) NOT NULL,
`add_date` date NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`status` int(1) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;