JusanSG Not quite sure if this can be done on the MySql level. (I am not an expert in MySql queries, an expert could do this on MySql level as well)
This can surely be done with some PHP code on the backend.
You could do this:
Goto AdminController.php file present in /app/Http/Controllers
Goto the first public function dashboard()
Add the following to the dashboard method:
$users = User::get()->pluck('default_address_id');
DB::table('addresses')->whereNotIn('id', $users)->delete();
dd('done');
Save the file and go to your Admin Dashboard. You should get the "Done" message.
Go back to the AdminController.php file and remove the newly added 3 lines of code. Save the file.
NOTE: this will leave the default address of each user and delete other addresses.
Example: If Saurabh has 5 addresses, of course only one is the default one, the other 4 will be deleted.
