We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

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

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

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.



4.3k

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