[PHQL] INSERT IGNORE INTO gives -> unexpected token IDENTIFIER(ignore)

Question

Nuno Jan '14

Created Jan '14	Last Reply Jan '14	Replies 1	Views 1216	Votes 0

Nuno 4.3k

Hello,

When I try to execute a PHQL Query using INSERT IGNORE INTO ... I get: Syntax error, unexpected token IDENTIFIER(ignore), near to ' INTO {Continue}

Why is this happening? Can I use other method?

Thanks

roman-kulish · Answer 1 · 2014-01-03T07:24:24-07:00

Probably not, because PHQL is not a real SQL, it's an abstraction that aims to support different databases. INSERT IGNORE is a MySQL only feature.

Nuno · Answer 2 · 2014-01-03T08:07:10-07:00

Nuno
4.3k

Thanks, I switched to \Phalcon\Mvc\Model\Resultset\Simple