0

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 ;

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

2
Contributors
4
Replies
6
Views
6 Years
Discussion Span
Last Post by duffy12
0

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.

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.