Cacher is the code snippet organizer for pro developers

SET NAMES 'utf8'
SET CHARACTER SET utf8

SET character_set_results = NULL;

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';

LOAD DATA LOCAL INFILE "C:/BSUSUARIOS.TXT" INTO TABLE bdusuario
CHARACTER SET 'utf8'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

use clubpark_website;


SET FOREIGN_KEY_CHECKS=0;
DROP table pr_country;
DROP table pr_destination;
DROP table pr_region;
DROP table pr_resort;
DROP table pr_subregion;

SET FOREIGN_KEY_CHECKS=1;


CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;


ALTER TABLE tabla1 
ADD CONSTRAINT nombreclaveforanea 
FOREIGN KEY (campotabla1) 
REFERENCES tablaquereferencia (campoquereferencia) 
ON DELETE NO ACTION 
ON UPDATE NO ACTION ;

ALTER TABLE nombretabla DROP FOREIGN KEY nombre_clave_foranea;

ALTER TABLE pr_unit_alias ADD CONSTRAINT unit_FK FOREIGN KEY(unit_id) REFERENCES pr_unit(id) ON DELETE NO ACTION ON UPDATE NO ACTION;

GRANT ALL PRIVILEGES ON  `royal\_club\_engine` . * TO  'jgodoy'@'%';

sp_password @old = 'oldpassword', @new = 'newpassword', @loginame = 'sa'