Recursos Gratuitos para IGU - Free resources for design GUI - Freie Ressourcen für die GUI

How To Remove Foreign Keys In MySQL

Today i have a problem when trying to delete some tables that had circular reference (one was FK NULL) but the way is that you can not drop the table until you drop the foreign key reference for example:

ALTER TABLE myTable DROP FOREIGN KEY FK_nameDefinition;

You can check for more information with the ALTER TABLE instrucction on:
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

But browsing i have find a really cool solution to drop all foreign Keys or just get the names of this
foreign keys in the following blog:

http://www.justin-cook.com/wp/2006/05/09/how-to-remove-foreign-keys-in-mysql/

I have found it in a commet by "Jason" he recommends this cool query:

select concat('alter table ',table_schema,'.',table_name,' DROP FOREIGN KEY ',constraint_name,';') from information_schema.table_constraints;

Try out... see you... MySQL still Rules !!!

¿ Cómo Realizar Post por Correo electronico en Blogger ?

Esta funcionalidad existe hace bastante tiempo, si no saben como hacerlo visiten la pagina de soporte
de blogger.

http://www.google.com/support/blogger/bin/answer.py?hlrm=en&answer=41452

Tambien existen otras opciones para postear por correo, como ser http://www.posterous.com donde
tengo una cuenta: http://efsandino.posterous.com/

Esta muy buena la idea, para realizar publicaciones simultaneas en varios blogs.