Category : MySql

ItSolutionStuff.com have tutorials for MySql, here you can study articles of MySql, MySql posts collection, most popular and useful tutorials of MySql, here you can find list of all relevant posts and example about MySql, we have lists of tutorials and examples about MySql.very simple and quick example collection of Latest MySql category.




How to count unique domains from email address field in MySQL ?

How to count unique domains from email address field in MySQL ?

you want to count domain from your email address field in mysql. if you are working on PHP then you could do easily by using explode function and counting domains, but that way is a very bad logic and it take max time on execution when you have lot of data. But we can do easily in MySQL by using SUB.....

By Hardik Savani | Views: 29407 | January 14, 2016 | Category : MySql

How to get last executed mysql query in laravel ?

How to get last executed mysql query in laravel ?

If you are working on laravel framwork and you use query builder of laravel 5. but you want to get last executed mysql query from laravel. If you are working on laravel 5 then you have to first enable query log that way it can be store query log. At last getQueryLog() through you can get last execut.....

By Hardik Savani | Views: 30301 | January 11, 2016 | Category : MySql


Mysql procedure with pagination in laravel 5?

Mysql procedure with pagination in laravel 5?

You are working on laravel with mysql database. you had created mysql procedure for get data and you want to call procedure with pagination in laravel 5 then you can not directly make pagination as laravel document.If you are using directly MySQL stored Procedure in your controller, model or reposit.....

By Hardik Savani | Views: 39698 | January 11, 2016 | Category : MySql

Which MySQL datatype use for store an IP address?

Which MySQL datatype use for store an IP address?

If you want to store IP address in mysql database then don’t mistake to use varchar datatype because you can use INT UNSIGNED 4(BYTE) datatype. using integer datatype you can save more space in database. when you fire insert query at that time use INET_ATON() and select query at that time INET_NTO.....

By Hardik Savani | Views: 57679 | January 7, 2016 | Category : MySql

Mysql Hexadecimal color code store in binary datatype.

Mysql Hexadecimal color code store in binary datatype.

If you have thousands of record store, that time database size would be large. but you can some field can save your number of bites in the database. you have color field then most of you choose string(6) data type and you wast 6 bites on every record, but you can save number of bites data by using B.....

By Hardik Savani | Views: 42970 | January 7, 2016 | Category : MySql