Welcome Guest, Not a member yet? Register   Sign In
how to delete from multiple tables using QB
#3

(04-13-2016, 07:41 AM)Tpojka Wrote: Try with:

PHP Code:
"DELETE users, users_temp, user_settings FROM users INNER JOIN users_temp ON users.user_id = users_temp.utemp_user_id INNER JOIN user_settings
ON users.user_id = user_settings.uset_user_id WHERE users.user_id = 
$user_id"

Not sure if it will work, you have to test it though. MySQL official docs say next.

it seems u missunderstood me, my query is works, i have no problem with this, but i wonder if it possible to make it with query builder, without using native queries with query() method

anyway thanks for a reply Smile
Reply


Messages In This Thread
RE: how to delete from multiple tables using QB - by Tecvid - 04-13-2016, 08:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB