0

MySql Query to remove unique or primary key from table

MySql-Query-to-Remove-Unique-or-Primary-Key-from-Table

This Is a Quick Tutorial to Remove Unique or Primary Key From MySql Table.Sometime we add unique key on table column to prevent duplicate entries but  a point you need some duplicate data in your column and that time you… Continue Reading

0

How to find and replace text in mysql table

How-to-find-and-replace-text-in-mysql-table

In this post i will explain an extremely basic MySql Problem of Replacing a Text in mysql Table.Suppose You have a table name posts with title and description. There are some normal content or links you have included in your all… Continue Reading

0

How to connect remote MySQL database in PHP

How-to-connect-remote-MySQL-database-in-PHP

Suppose you are working on a project and your code or application is hosted on a server and your mysql database is hosted on another server but you need to get your mysql database from code server remotely then this… Continue Reading

0

5 MySql useful queries

replace MySQL column value before matching

Here I am not going to indicate most regular query like INSERT, UPDATE, DELETE and so on. I’ll demonstrate to you some other one stage up query which I feel we required these amid advancement, Generally we make basic function… Continue Reading

0

Copy data from one database table to another in Mysql

Copy-data-from-one-database-table-to-another-in-Mysql

sometime you want to copy data from one database to another database that are on same server.The columns and tables got diverse name and wanna insert column data from one database to another using mysql query.if you want same thing… Continue Reading

0

How to Create MySQL views

view-tables

MySQL has bolstered database sees since rendition 5.x. Perspectives are quite helpful in the event that you need to allude to values computed from expressions without composing the expressions each time you can recover them. What is a view A… Continue Reading

0

replace MySQL column value before matching

replace MySQL column value before matching

How to use REPLACE in mysql query with example suppose you have a list of Spa Centers in your mysql table.and you want to search in your tables to get similier results that user searched for.if you are looking for… Continue Reading