How to change MySQL password

Added By: Prem Tiwari | Last Updated: | In: Mysql


Are you want to change the password of your MySQL database, then keep your close attention in this tutorial as I am going to share how to change MySQL password using the command line. Below …

How to Replace All Matched Fields in MySQL

Added By: Prem Tiwari | Last Updated: | In: Mysql


Sometime you need to replace some string urls with some thing else in your database table. This is very hard to replace the string or urls in database table manually one by one. Mysql replace …

Working With MySQL Events – Complete Beginners Guide

Added By: Prem Tiwari | Last Updated: | In: Mysql


Hello friends, hope you are doing good. In today’s tutorial, I will explain the very simple and easy steps to working with MySql events with the example. After this tutorial, you will be able to: …

Best MySQL GUI Tools for Developers 2017

Added By: Prem Tiwari | Last Updated: | In: Mysql


MySQL GUI tools play a big role when you are developing the data storage and management web applications. Nowadays MySQL is the world’s second most common used for relational database management system to deliver the …

Some Useful WordPress MySQL Queries

Added By: Prem Tiwari | Last Updated: | In: Mysql, WordPress, WordPress Snippets


This is a very quick tutorial about some useful WordPress MySQL queries. In this tutorial, I will share some useful MySQL queries which will help you when you are going to move your WordPress site …

How to get data from mysql using AngularJS and PHP

Added By: Prem Tiwari | Last Updated: | In: Angular JS, Featured, Mysql


Hi friends, hope you are doing well. In today’s post i will share a very important things with you. Now days AngularJS is the best option to develop next web application. If you are going …

Start using PDO instead of PHP MySQL extension

Added By: Prem Tiwari | Last Updated: | In: Mysql, PHP Tutorial


Hi Friends, Thanks for be with Freewebmentor. Freewebmentor wishes you Happy New Year 2017. This is the my first post in 2017. Today i am going to share very useful thing. If you are a …

How to Export Data in .CSV File From Mysql Using PHP

Added By: Prem Tiwari | Last Updated: | In: Mysql, PHP Tutorial


Are you looking to export your mydal data in .csv file using simple PHP code, then please keep your close attention in this post How to Export Data in .CSV File From Mysql Using PHP. …

How To Create MySQL Trigger

Added By: Prem Tiwari | Last Updated: | In: Mysql, Oracle


This article will explain how to create Trigger in mysql. A mysql trigger is a procedural code which is automatically executed after response to certain events on a particular table or view in a database. …

Sql User Table Schema For Yii2 Starter Kit

Added By: Prem Tiwari | Last Updated: | In: Mysql, Yii framework


Are you going to develop your web application in yii2 framwork, then this article will help you. The user table schema is not provided with yii2 starter kit by yii2 framework package. Below is proper …

How to delete duplicate data from database table

Added By: Prem Tiwari | Last Updated: | In: Mysql, Oracle


Hi friend, today i am going to share How to delete duplicate data from database table. For preventing from duplicate entries in datatbase table you cna use PRIMARY KEY or UNIQUE Index on table with …

Responsive country,state,city dropdown using PHP

Added By: Prem Tiwari | Last Updated: | In: Freebies, Javascript & Ajax, Mysql, PHP Tutorial


I got many request to Responsive country,state,city dropdown values from the database without refresh page using Ajax and PHP. In this article, I’ve put three drop down of country,state,city, drop downs without refreshing the page. …