Tag Archives: MySql

Difference between joomla and drupal

Comparison  between joomla and drupal is a complex topic. Users of both CMS claims that they are the best. Now, Without wasting time let me show you the tabular difference between joomla and drupal. If anybody feels to add few … Continue reading

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

WordPress fetch ACF email ids

if you are you advanced custum field plugin and wants to fecth all  email ids you can use following query SELECT a.meta_value AS Name, b.meta_value AS Email FROM ( SELECT * FROM `wp_postmeta` WHERE meta_key = ‘custom_author’ ) AS a, … Continue reading

Posted in Development | Tagged , | 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

phpmyadmin_csv_upload_4

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

MySQL Community Edition

MySQL Community Edition continues to be available under the open source GPL  with no change. This is a great news form the MySql developers and users. Those are thinking about commercialization of the MySql Since the acquisition by Oracle. MySQL … Continue reading

Posted in Development | Tagged , | Leave a comment