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 …
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: …
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 …
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 …
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 …
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 …
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. …
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. …
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 …
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 …
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. …
By: Prem Tiwari | Last Updated: | In: 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 …
By: Prem Tiwari | Last Updated: | In: 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 …
By: Prem Tiwari | Last Updated: | In: Mysql, Oracle
A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. These statements provide control over use of transactions: START TRANSACTION or BEGIN start a …
By: Prem Tiwari | Last Updated: | In: Javascript & Ajax, Mysql, PHP Tutorial, Web Technologies
Have you thought about own facebook-style photo gallry system with comments? I have and today I prepared it for you. In this post i explained the easy way to create your Facebook style photo gallery …
