php - Getting data from similar columns but from different dynamic tables in MySql -
i have multiple dynamic tables like
{ user_details_1 user_details_2 user_details_6 user_details_9 }
all these tables contain same columns structure
{ user_id start_date end_date }
but have delete rows of users who's end_date lower today.
what need
{delete information_schema.tables.table_name 'user_details_%' end_date <= now()}
i need query purpose because above query not working.
Comments
Post a Comment