[reshma]

Hi

Is there any way in which you can enter muliple records into our database, like if i want to enter 50 records initially and then want to keep adding on records whenever required, how can i do that? do i have to actually hard code the values everytime or is there some other way out ? i hope i am clear

[kaceykeleher]

You can just create an SQL file to upload into your MySQL database. It would look similar to this:

# --------------------------------------------------------
#
# Table structure for table 'table_name'
#
CREATE TABLE table_name (
user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
user_name varchar(25) NOT NULL,
user_pass varchar(32) NOT NULL,
PRIMARY KEY (user_id)
);

# -- User Info
INSERT INTO table_name (user_id, user_active, user_name, user_pass) VALUES ( '', '', 'admin', 'password');
INSERT INTO table_name (user_id, user_active, user_name, user_pass) VALUES ( '', '', 'user', 'password');

Then you save the file as filename.sql, and run it in your MySQL database. You'd have to create the INSERT INTO line 50 times, and change the user_name (for this particular insert) but it's easier than creating a form and entering the data for each one. I think, anyway.

[reshma]

Thanks a lot !!! i will try this out...