Convert sql to yii framework.

ehsepulvedao · October 17, 2019, 8:17am

Hello community, I have this sql code and I would like to know how it can be translated into the yii framework.

INSERT INTOapp_user_pruub(cedula, nombre, apellido) SELECT CAMPO01 As cedula,CONCAT( CONCAT(CAMPO02,’ ‘), CAMPO03) As nombre, CONCAT( CONCAT(CAMPO04,’ '), CAMPO05) As apellido FROM app_employees WHERE 1

thanks!

samdark · October 17, 2019, 10:00am

Query builder doesn’t support INSERT INTO ... SELECT so you have to form query yourself.

ehsepulvedao · October 18, 2019, 6:15pm

Thank you very much for the information.

You know how I could make a code that detects duplicates in a table, copy them to another table and then delete them? Thank you!

samdark · October 20, 2019, 1:22pm

It depends very much on what is duplicate.

ehsepulvedao · October 20, 2019, 10:21pm

I have an identification number and I want to know if that same number is in other rows of the same column.

samdark · October 21, 2019, 6:41am

If you have three rows with the same ID, which one of the three you’d keep?