fbpx
33 C
Lahore
- Advertisement -spot_img

TAG

MySQL

Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used...

How to get phpmyadmin / Mysql root password through terminal?

Required steps to perform this: You should have root access to terminal. Server: Ubuntu 14 LAMP should be installed. Run this command: cat /etc/motd.tail

MySQL: How to get latest updated Tables’ list

Following query will show a list of the all latest tables which are changed/updated ( by inserting/deleting/updating rows ) recently. USE information_schema; SELECT TABLE_SCHEMA ,...

How to setup Google reCaptcha Version 2.0?

To setup Google reCaptcha oepn url https://www.google.com/recaptcha/admin and fill form as shown in the screenshot below: After registration open newly created reCaptcha site and read the guide...

PHP: How to search and replace string from complete database using PHP

If you want to search and replace string from entire database (from all tables of any database) using php then use following code. <?php // Find...

MySQL: How to duplicate a row using SQL ?

Use following SQL query to duplicate any single row. Use your own field names to make this working in your case. insert into packages (`field_1`,...

Latest news

- Advertisement -spot_img