If you want to sort multiple columns in Laravel by using orderBy Whenever you need to give multiple column in your query then you can use twice time orderBy and give them you can give multiple columns in laravel by following example strongUsers Table strongtable classtable tableb

Reminder: MTS = Multi-Threaded Slave.

Update 2017-04-17: since the publication of this post, many things happened:

the procedure for fixing a crashed slave has been automated (Bug#77496) Bug#80103 as been closed at the same time as Bug#77496 but I still think there are unfixed things, see Bug#81840

End of update 2017-04-17.

I will be talking about parallel replication at FOSDEM in Brussel on

Whenever you are making table using migration with foreign key like i give you example as under and you forgot to set delete cascade on table then how can you add delete cascade in existing table so lets see your migration pre classlanguagephppublic function up Schemacreatelo

In February my colleague Morgan Tocker will travel through Europe and talk about MySQL 5.7, which recently went GA.

In Munich we're having a meeting for PHPers and other Web developers, where Morgan will talk about MySQL and JSON and I'll also be around.

Summary of the talk:

With the newly added JSON support in MySQL, you can combine the flexibility of NoSQL with the strength of a relational database. In this session, Morgan will explain the new JSON datatype, and the new set of functions for handling JSON documents, available storage and indexing options. In addition, he will present benchmarks showing how much one can expect from the MySQL server in different use case scenarios.

About Morgan: Morgan rejoined the MySQL team at Oracle in 2013 as MySQL Community Manager, having …

Many time you have face a problem in windows wampserver or virtualhost of indexphp file overwrite i also fetch that problem likehttplocalhosttestindexphpadminIn this url you can see indexphp wtite in url but URL must be without indexphp so if you are using windows wampserver then y

Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now!

Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database technologies have implemented a number of approaches, and data compression is by far the most common and important. Compression in open source databases is complicated, and there are a lot of different approaches – each with their own implications.

In this talk we will perform a survey of compression in some of the most popular open source database engines including: Innodb, TokuDB, MongoDB, WiredTiger, RocksDB, and PostgreSQL.

Important information: …

If you are working with laravel and you need to setup gmail configration for send email if you want to set configration of gmail then first go to mailphp file you are work on laravel 4 and laravel 5 its not issue because you can set comman setting for both version of laravel framworkstrongM

The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend.

Percona Live is the premier event for the rich and diverse open source community and businesses that thrive in the MySQL and NoSQL marketplaces. Attendees include DBAs, sysadmins, developers, architects, CTOs, and CEOs representing organizations from industry giants such as Oracle to start-ups. Vendors increasingly rely on the conference as a major opportunity to connect with potential high-value customers from around the world.

Below are some highlights for the upcoming conference regarding the conference schedule, Tutorial sessions, Birds of a Feather talks, and Lightning talks.

Conference Schedule

Percona Live is packed with engaging sessions, helpful …

Error Message:
Error Code: 1215. Cannot add foreign key constraint
Example:
Error Code: 1215. Cannot add foreign key constraint
  Possible Reason: Case 1: MySQL storage engine. MySQL supports several storage engines, comparing features of the different mysql storage engines are given below. Note that only InnoDB storage engine supports foreign key, when you are using different mysql storage engine you may get the error code: 1215 cannot add foreign key constraint.

Case 2: Key does not exist in the parent table. When …

If you want to set vertical align middle text image div etc then you can set easily by using following example you can give vertical align middle by saveral way i also give you example with output you use any of the example of vertical align middle by css I also provide saveral example with di