Mysql General Error 1364 Field Doesn’t Have Default Value

Hi All, Since I’ve updated my homestead to 0.3.0 and mysql version is upgrade to 5.7.4. From that moment, my old projects has been started to throw problems which is Mysql General Error 1364 Field doesn’t have default value. Even migrations was not working, there has to be a problem. After my first research I’ve […]

LaravelMySQLPHP

Laravel Eloquent Model Events

Hi All , In this post , I’ll talk about Eloquent Model Events. Looks Like Database Trigger Isn’t it? When I read the documentation , I said “Mysql already doing this so..”. Personally, still I prefer to use Mysql Triggers for database operations. It’s more faster and guaranteed. But day by day NoSQL solutions or Hybrid database solutions […]

LaravelMySQLPHP

MySQL Limitli Sorgu Toplam Satır Sayısı

Merhaba Arkadaşlar  , Web uygulamalarımızın vazgeçilmezi olan Ajax uzun database sorgularında bizi çok işten kurtarıyor. Ama sayfalama yaparken , datatables kullanırken  veya search gibi karmaşık sorgularımızın gerçek uzunluğuna ihtiyacımız oluyor.  MySQL’in bunun için çözümü şu şekilde SELECT SQL_CALC_FOUND_ROWS user_id , username FROM users LIMIT 10 Bu sorgudan sonra; SELECT FOUND_ROWS() AS `Count` sorgusunu çalıştırırsanız , […]

MySQL