Related Articles
How to find duplicate rows in Sql or Mysql
You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]
How to Add Column to Mysql Table and Auto Increment with Primary Key
Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY auto_increment; ALTER TABLE users ADD id […]
How to use Google map Address in PHP
Let’s Start, First we Getting latitude and longitude from Address in Google Maps Using PHP. The script is given below. Google map Address in PHP In Above code, we just pass the latitude and longitude point (,). See $Lat for latitude and $Lon for longitude . In script code iset the zoom level to 5 […]