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 […]
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 […]
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 , […]