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 ;

In which format do you have the "huge data"? In general I'd recommend that you use the mysql command line client and the LOAD DATA statement.

In which format do you have the "huge data"? In general I'd recommend that you use the mysql command line client and the LOAD DATA statement.

I do have the data in a textpad, i dont have any idea for command for mysql database, i need help of u people

Thanks a lot let me try

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.