How to show the Store Procedure Code Syntax in MySQL

Prem Tiwari - - Mysql


If you want to show the procedure code in MySQL, then this tutorial is for you. In this tutorial, I am going to share how to show the store procedure code syntax in MySQL. Open …

How to change MySQL password

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - 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

Prem Tiwari - - Freebies, JavaScript, 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. …

Getting Started with MongoDB and PHP

Prem Tiwari - - Mysql, PHP Tutorial


This tutorial provides an introduction to basic database operations using the mongo shell. MongoDB is a document database that provides high performance, high availability, and easy scalability. MongoDB is a free and open-source cross-platform document-oriented …

How To Install Linux, Apache, MySQL, PHP (LAMP) Server on Ubuntu

Prem Tiwari - - Freebies, Mysql


LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. As a solution stack, LAMP is suitable for building …