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 from my admin panel, 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 a table 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
