MySQL build query to drop all foreign keys for a table

mysql_build_drop_fk_for_table.txt

---------------------------------------------------------------------
---- build sql to drop all foreign keys for a table
---------------------------------------------------------------------

SELECT CONCAT('ALTER TABLE `',table_schema,'`.`',table_name,'` DROP FOREIGN KEY ',constraint_name,';')
    FROM information_schema.table_constraints
    WHERE constraint_type='FOREIGN KEY'
    AND table_schema='{database}'
    AND table_name IN ('{table}');