Sme meta base querys

 select * from SMEPROD.stores  where contact_number = '9966577499' order by id desc limit 20


select * from mfscore.tbl_send_sms order by insert_date desc limit 5


select * from SMEPROD.stores where api_key = '785ca71d2c85e3f3774baaf438c5c6eb' order by id desc limit 10


select * from SMEPROD.stores where contact_number = '9966577499' order by id desc limit 10


select * from SMEPROD.stores where contact_number = 8877112244 order by id desc limit 10


select * from mfscore.tbl_send_sms where msisdn = 8877112244 order by insert_date desc


select * from mfscore.t_um_key_value where entity_id=21000000221;

select * from mfscore.t_um_key_value where entity_id=21000000222;

select * from mfscore.t_um_key_value limit 10;

select * from mfscore.t_um_user_detail  where msisdn = 9966577499


select * from mfscore.t_um_user_identity  where msisdn = 9966577499


select * from mfscore.t_um_user_identity  where msisdn = 8067498242

Comments

Post a Comment

Popular posts from this blog

Add Css And Js Files on Specific Page In laravel

  1. Using Blade Layout Sections: Laravel's Blade templating engine provides a powerful way to manage layouts and include specific content on different pages. Here's how to achieve this: a. Base Layout ( layouts/app.blade.php ): <!DOCTYPE html> <html> <head> <title>My Website</title> @yield('page-css') <link rel="stylesheet" href="{{ asset('css/app.css') }}"> </head> <body> @include('partials.header') <main>@yield('content')</main> @include('partials.footer') @yield('page-js') <script src="{{ asset('js/app.js') }}"></script> </body> </html> b. Specific Page View ( views/home.blade.php ): @extends('layouts.app') @section('content')   @endsection @section('page-css')   <link rel="stylesheet" href="{{ asset('css/home.css') }}">  @endsection @se...
Read more

Be 10x 10 tools from sessions

 gamma.app  create ppt paywallhub.com sci-hub.se ui.playground.ai  for creating images with prompt  app.yoodli.ai   for job search resume practice for your speech ChatGPT codedamn.com/ai    help to find out the bug in your code Gemini formula.dog creates the formula for Excel
Read more

Diffrence between Put and Patch

PUT: Imagine you're replacing the entire contents of a document. With PUT, you send the complete updated version of the data to the server. It's like rewriting the whole document. PATCH: This is like editing specific parts of a document. You only send the changes you want to make, leaving the rest untouched. Example: Let's say you have a user profile with information like name, email, and phone number. PUT: If you want to update the entire profile with new data for all fields (name, email, phone), you'd use PUT and send the complete new user information. PATCH: If you only want to change the user's email address, you'd use PATCH and send just the updated email information. Here's the key difference: PUT: Replaces the entire resource. PATCH: Updates specific parts of a resource. 
Read more