Examples of some raw mysql querys: Insert Into.. On Duplicate Key Update

mysql_querys.sql

/**
 *
 * @author  Paulo Silva(Exadra37)     exadra37 in gmail point com
 * @package Exadra37/Mysql-Examples
 * @version 0.0.1
 * @since   28/01/2014 - v.0.0.1
 *
 */

INSERT INTO stores (storeName, address, phone) 
VALUES ('MyStore1', 'MyAddress1', 'MyPhone1'), 
VALUES ('MyStore2', 'MyAddress2', 'MyPhone2'), 
VALUES ('MyStore3', 'MyAddress3', 'MyPhone3')
ON DUPLICATE KEY UPDATE
	storeName = VALUES(storeName), 
	address = VALUES(address), 
	phone = VALUES(phone);