Subject | sql query: firebird VS mysql |
---|---|
Author | Datatal AB - Gauffin, Jonas |
Post date | 2003-04-02T09:18:50Z |
Hello
I'm developing an application that should support both firebird and
mysql.
But since mysql doesnt support subselects i'm using joins.
Do this work in firebird:
UPDATE vm_mailbox box, usr_extension ext
SET user_rights = user_rights ^ 2
WHERE ext.mailbox_id=box.mailbox_id
AND ext.user_id=3
I'm developing an application that should support both firebird and
mysql.
But since mysql doesnt support subselects i'm using joins.
Do this work in firebird:
UPDATE vm_mailbox box, usr_extension ext
SET user_rights = user_rights ^ 2
WHERE ext.mailbox_id=box.mailbox_id
AND ext.user_id=3