mySQL |
X

Congrats, You are Subscribed to Receive Updates.

How to change SQL_MODE in MySQL Permanently

How to change SQL_MODE in MySQL Permanently
Introduction This is very simple article to set the mysql mode permanently inside your Mysql Server 5.7 or above versions. I tried some articles and finally found this to helpfull for someone who came with same issue. Usually some queries needs to change the sql mode permanently, Otherwise you need to write  set mode everytime. I got stressed to set sql_mode on every query. So ...

PHP Create MySQL backup

PHP Create MySQL backup
Introduction PHP Create MySQL backup for your client site. Sometimes you need to keep a backup before making a big change or a periodic backup will help you to avoid losing of data. And also if you have risk of hacking the backup will help you to get back to live with backups. There  are two kinds of backup 1. Whole database backup 2. Selected ...

Solution for phpmyadmin.pma_table_uiprefs doesn’t exist

Solution for phpmyadmin.pma_table_uiprefs doesn’t exist
Solution for phpmyadmin.pma_table_uiprefs doesn’t exist. the below image explains you the error message completely.The error is ” SELECT `prefs` FROM `phpmyadmin`.`pma_table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'kvcodes_test' AND `table_name` = 'kvc0005_users' MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist The images tells you more .   If you faced any such a error.  just do the following steps, your problem will be solved. ...

How to use Raw MySQL queries in Laravel

How to use Raw MySQL queries in Laravel
How to use Raw MySQL queries in Laravel. Many developers have implementation problem with MySQL queries in Laravel and also, Laravel doesnot support the whole features of SQL queries. So we have one base function to use our Raw queries inside the function. Which is even better for new developers and those who have problem with Laravel functions. By the way it protects the SQL ...

Essential Software’s for Aspiring Web Developer(PHP)

Essential Software’s for Aspiring Web Developer(PHP)
Everyday web is growing tremendously, Based on its growth  many peoples want to become a successful web developer and framework builder.  There are huge number of freelancers are doing it as a self employed service and business. Even I am also one among the freelancer. So here I just gathered few Software’s for beginners to use while come to learn web design. A web developer ...

Menu

Sidebar