How to make an insert query in DQL

insert dql doctrine-1.2
greg0ire picture greg0ire · Jun 22, 2011 · Viewed 12.4k times · Source

I'm working with symfony and I would like to know how I can do a simple insert using the doctrine:dql task.

./symfony doctrine:dql "<what should I put here?>"

Answer

Yura picture Yura · Jun 27, 2011

You officially cannot INSERT using DQL. Only SELECT, UPDATE and DELETE.

Related questions

Inserting multiple rows in a single SQL query?

I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and Office. INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office"); INSERT INTO MyTable VALUES ("Jane", 124, "Lloyds Office"); INSERT INTO MyTable VALUES ("Billy", 125, "…

Read More
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appear to be the use of either: ON DUPLICATE KEY UPDATE which implies an unnecessary update …

Read More
Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to pulling up tons of help docs and articles about "bulk imports". Here's what I want to do, but …

Read More