How can we insert five time values in only a sql query??

Question

In just one query.

Answer 1

Check this. You can insert multiple rows in a single query like this

INSERT INTO MyTable ( Column1, Column2, Column3 ) VALUES ('John', 123, 'Lloyds Office'), ('Jane', 124, 'Lloyds Office'), ('Billy', 125, 'London Office'), ('Miranda', 126, 'Bristol Office');

Answer 2

Exactly I want that answer
AJ || ANANT || AC || ANANY || AY

Thanks

Answer 3

Sorry dear
But someone asked me this, that time I can't handle it. But now I just remember so I ask

Answer 4

We have a table that contains the columns firstName and email.
Now someone is asked me that I have to insert one entry to the table and the value was
firstName = John
email = [e-mail]
so I was written the query

Insert into user
Values('john', '[e-mail]')

After that he again ask me a another question related to this table.
The question was that insert the 5 different entry using one query and the values was

1. Harry 2. Jess 3. Doe 4. Hanry 5. Sui
The above entries for the firstName

1. [e-mail] 2. [e-mail] 3. [e-mail] 4. [e-mail] 5. [e-mail]

So what will be the one query for these entries?

Sorry for grammatical mistake.

Answer 5

Let I explain to you just wait