Any one can suggest One time password generator packages while authentication in laravel 5.1

Hi @yadhul Have you solved your issue?

To know which business_ids are not present in the business_language table and that are with language_id, see the query below:

SELECT business_id 
FROM business
WHERE business_id NOT IN (SELECT business_id
                              FROM business_language 
                              WHERE language_id IS NOT NULL OR language_id <> '');

Then now you can insert those business_id that are not present based from the result of the query.

Also, i noticed that the title of this seems not related to the description :)

hey hi @JoerJoers iam really happy and thanks for ur reply... i knw this subquary for listing out.... from business_lanaguges which are not present.. i want a query where thousands of business_id's are not their.. it should insert in business_language with one single query it should insert multipel ids... that how iam not able to get it

Upadte business_language ..?

I guess inserting multiple business ids using a single query is not possible. You need to do it one by one. However, using seeders can actually work. Create a seeder by following instructions here https://laravel.com/docs/5.2/seeding then on the run function do the following:

public function run()
    {
       $businessIds = DB::table('business')
            ->whereNotExists(function ($query) {
                $query->select(DB::raw(1))
                      ->from('business_langauge')
                      ->whereRaw('business_language.business_id = business.id');
            })
            ->get();

    foreach ($businessIds as $businessId) {
            //Do the insert process here for each business_id
    }
    }