Category : MYSQL

18 posts

Here I am not going to show most common query like INSERT, UPDATE, DELETE etc. I’ll show you some other one step up queries which I feel we required these during development, Generally we create common function and classes at once and we uses these functions and classes many times as per need. But in …
Here I’ll show you How to reset/change MySql root password command line in ubuntu linux, Using some mysql CLI commands you can easily recover your mysql administrative password. As I forgot to my mysql root password then i use below commands to reset my mysql root password and it works like charm. Step-1: First login …
Hello friend in this tutorial I am going to show you How To Access PhpMyAdmin without cPanel login, Yesterday i need this feature in my hosting, Actually i am using godaddy shared hosting and every time if you want to access database you have to log-in in your Cpanel, So I was looking for solution …
Suppose you are working on some project and your code/application hosted on different hosting server and mysql database hosted on other different shared hosting server and you want to access your mysql database from application server remotely then this tutorial for you. In some cases of development it requires to use multiple database in single …
This tutorial about importing and exporting database command line superfast. If you have big mysql database and you try to import, you may feel lot’s of trouble in regular method and it also takes too much time to upload from local to server then running queries. But recently I tried command line method to upload …
In this quick tutorial i am going to show a very simple mysql query to find specific text and remove the same from selected table column. This is the quickest way to replace text from mysql table. Suppose you have a table name posts with title and description, These is some common text you have …
This is quick tutorial to removing unique or primary key from your MYSql table. Sometime we add unique key on table column to prevent from duplicate entry, But if in any case you need some duplicate data in your table like in my case i assigned unique key as company_name in my companies table to …
This is the very often problem to handle duplicate data in mysql table, If you are working on huge amount of data, You might have face this problem, So in this post I am going to show you MYsql query by which you can find duplicate data and remove it. This is also the most …
PAGE TOP

Don't show again | X

Follow Rohit on Facebook

Join me to get interesting insights!

Rohit Kumar