I want to use LIKE query as work on sql i mean If using a SQL or Mysql Like query to query data it will return data even if its only partially matched if i search just t then it will return all the records match t so you can add LIKE statement by using querystringyou can easily implem

when you install laravel and get the records from database then occur You need to specify a file path to store the seed laravel error that error happened because your php can not loading openssl extension so If you are using windows then you should enable openssl extension in following path

Over several previous blog posts, we’ve already discussed what information the 

EXPLAIN FORMAT=JSON

 output provides for some subqueries. You can review those discussions here, here and here. EXPLAIN FORMAT=JSON shows many details that you can’t get with other commands. Let’s now finish this topic and discuss the output for the rest of the subquery types.

…

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