Skip to content

Mastering PHP and Laravel

Never stop learning!

Menu

  • LastPass – Are your passwords secure?

MySQL

MySQL Stored Procedures

Here is a tip you can use when writing a stored procedure, and using prepared statements. Since you have to pass the statements in through EXECUTE stmt USING …   it can get confusing if there are a large number of

Kenny October 11, 2018 Learning, MySQL, Programming No Comments Read more

SQL EXPLAIN: The “Extra” column

This column contains additional information about how MySql resolved the query. There is a line in the manual which states: If you want to make your queries as fast as possible, look out for Extra values of Using filesort and Using temporary. Let’s examine why

Kenny September 25, 2018 Learning, MySQL, Programming No Comments Read more

Archives

Categories

  • iPhone (2)
  • Learning (42)
  • Linux (4)
    • Debian (1)
  • Mac Terminal / Linux (5)
  • Other Stuff (1)
  • Programming (66)
    • .NET (1)
      • C# (1)
    • Java (1)
    • Javascript (6)
      • AngularJS (1)
      • Node.js (2)
    • MySQL (2)
    • Objective C (1)
    • PHP (45)
      • Community (5)
      • Laravel (9)
        • Eloquent (3)
    • SQL (7)
    • Tools (2)
      • PHP Storm (1)
  • Slim Framework (1)
  • Uncategorized (7)
  • WordPress (3)
Copyright © 2022 Mastering PHP and Laravel. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.