Category Archives: MySql

This category is use to display mysql related posts.

Whats new with PHP7?

PHP7 is latest version of PHP released in 2016.

Posted in Development, Internet Marketing, MySql, PHP | Tagged , , , , | Leave a comment

Visitors tracking on your website

Many developer want to create a solution that help them to track location and activity for their visitors on mobile and website. Analytics is used to measure audience reach, engagement, retention, conversions, revenue etc. 

Posted in Development, Internet Marketing, MySql | Leave a comment

Import data From CSV using PHPMyAdmin

These are simple steps for exporting data  from MySql using PhpMyAdmin. Step 1: Open your phpMyAdmin database will show list of all tables. You have to choose your table you  want to update with more data.

Posted in Development, MySql | Tagged , | Leave a comment

Export Data From PhpMyAdmin

These are simple steps for exporting data  from MySql using PhpMyAdmin. Step 1: Open your phpMyAdmin database will show list of all tables     Step 2: Click on export which will show you lot of option   Step 3: … Continue reading

Posted in Development, MySql | Tagged , | Leave a comment

Reset MySql Password

I was working with mysql and  something wrong happen do not know what is that but i was not able to login to my database either by phpmyadmin or but using my terminal i got scare may be i lost … Continue reading

Posted in Development, MySql | Tagged | Leave a comment

Replace space to hyphen in MySql

Again, I am publishing another mysql query to replace the space with the hyphen. also Below is the replace space to hyphen in MySql Query:- SELECT `id` , name, REPLACE( LCASE( name ) , ‘ ‘, ‘-‘ ) AS alias1 … Continue reading

Posted in Development, MySql | Tagged , | 1 Comment

Finding non-duplicate records from different MySql Tables

SQL Query For DeDuplication of Records

I was searching for the solution to match two database table with same or different fields and remove the data which is present in both tables. After goggling a lot, I realize find and remove duplicate records in mysql is … Continue reading

Posted in Development, MySql | Tagged , , , , | 7 Comments