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 ;