heremiguel

MySQL Session Variables

Hi everybody! Where is the best place to set the environment variables? DB::statement("SET tmp_...

Another question regarding performance.

I got this query: SELECT (SELECT GenreDescription FROM Genre WHERE GenreId = Reports.ReportGenreId)...

If in statements

Hi everyone, a "simple question" maybe it's not possible... I have this query repeated con...

Question regarding aggregate in Query Builder

I am querying a table and I wonder why Laravel make a count(*) query before my query that spend addi...

I have used "take" + "get" instead "paginate" and getting similar exec...

Thank you very much kokokurak. Really helpful!

What happened if there are 2 consecutive "where"

Thank you, the reason to cast it's to detect an integer and query only the id fields. Thank you for...

Found the answer thank you! $query = DB::table('Reports'); if ($published == true) $query->w...