MYSQL Group By

 SELECT YEAR(suscribed_at), MONTH(suscribed_at), count(id) FROM `xp_myxpendy_subscription` WHERE `subscription_id` IS NOT NULL GROUP BY YEAR(suscribed_at), MONTH(suscribed_at)

Comments

Post a Comment

Popular posts from this blog

Import csv file in laravel

           1. I nstall maatwebsite via the Composer package manager                composer require maatwebsite/excel        2.  Then open config/app.php file and add service provider and aliase.           'providers' => [ Maatwebsite\Excel\ExcelServiceProvider::class,           ],           'aliases' => [ 'Excel' => Maatwebsite\Excel\Facades\Excel::class,           ],          3 . Define Routes              In routes/web.php                Route :: get ( ' /upload ' , 'Post Controller@index ' );         Route :: post ( ' /pupload ' , 'Post Controller@uploadp ' )-> name ( ' uploadp ' );       ...
Read more

Remove css or js version wordpress

 // remove wp version number from scripts and styles function remove_css_js_version( $src ) {     if( strpos( $src, '?ver=' ) )         $src = remove_query_arg( 'ver', $src );     return $src; } add_filter( 'style_loader_src', 'remove_css_js_version', 9999 ); add_filter( 'script_loader_src', 'remove_css_js_version', 9999 );
Read more

Print Laravel Query Or Debug Laravel Query

Method 1:-  $posts = Post::where('id',' '> ,10)->toSql(); dd($posts); Method 2:- DB::enabLeQueryLog(); // Enable query tog $posts = Post::with('comments')->where('id',' '> ,10)->get(); dd(DB::getQueryLog()); // Show results of tog Method 3:- $posts = Post::with('comments')->where('id',' '> ,10)->get(); $comments = Comments::all(); DB::listen (function($query) { print_r(value: "DB:" . $query->sql ."[".implode(separator. " , " , $query->bindings) . "]"); });
Read more