ALTER TABLE site_listing ADD breed VARCHAR( 255 );


ALTER TABLE site_listing ADD `service_boarding` enum('No','Yes') DEFAULT 'No';


====================CALCULATE LAT AND LON===================================
SELECT denumire, (6371 * acos( cos( radians(45.20327) ) * cos( radians( coord_lat ) ) * cos( radians( 23.7806 ) - radians(coord_long) ) + sin( radians(45.20327) ) * sin( radians(coord_lat) ) )) AS distanta 
FROM obiective 
WHERE coord_lat<>'' 
    AND coord_long<>'' 
HAVING distanta<50 
ORDER BY distanta desc
========================================================
//FIND AND REPLACE
UPDATE menus SET menu_url=REPLACE(menu_url,'http://attorney-lawyers.com/client/prg/','http://localhost/pivtal/index.php/') WHERE 1
--------------------------------------
//MATCH
SELECT *
FROM tblcenter
WHERE MATCH (address) AGAINST('Magnolia Katherine')

SELECT * FROM tblcenter WHERE address REGEXP 'Magnolia|sdfdfd|Katherine';
-----------------------------------------------------------------------------
ALTER TABLE Persons DROP COLUMN DateOfBirth
-----
ALTER TABLE `site_listing` CHANGE `manufacurerid` `manufacturerid` INT;

================================================================================
INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers
WHERE Country='Germany'; 
---------------------------------------------------------------------------------


=============Creat Table====================
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

=================================