Insert multi values into a table

[haibec]

I want Insert multi values same same into a table .Please help me

[MrAdam]

i don't understand what you mean, fully?do you mean something like:

INSERT INTO table (id,name,email) VALUES ('1','ADARMMMM!','adarrrrrrrrrrrrm@summit.com')

(for example) ??

[jesh]

Or perhaps:

INSERT INTO table (name) VALUES ('ADARMMMM!'), ('jesh'), ('haibec');

[haibec]

Or perhaps:

INSERT INTO table (name) VALUES ('ADARMMMM!'), ('jesh'), ('haibec');

Example: I have a table Class include fileds : Name,Class . I want insert 1000 row same

[MrAdam]

<?phpfor (i=0;i<1000;i++) {$query = mysql_query("INSERT INTO Class (Name,Class) VALUES ('Something','Something')");}?>

use that php code ...

[PrateekSaxena]

I think what you can do is that first make an array of the things that you want to put into the table and then instead of writing "Something" you can write thatArray .

[Yahweh]

I want Insert multi values same same into a table .Please help me

Inserting a record with multiple values is easy:

INSERT INTO	table	(field1, field2, field3)VALUES   (val1a, val1b, val1c)WHERE   condition = @condition;

If you want to insert multiple records, its practically the same thing, except you seperate the values for each record by a comma:

INSERT INTO	table	(field1, field2, field3)VALUES   (val1a, val1b, val1c),   (val2a, val2b, val2c),   (val3a, val3b, val3c),   (val4a, val4b, val4c)WHERE   condition = @condition;