domingo, 30 de octubre de 2016

jueves, 8 de octubre de 2009

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 !!!

viernes, 2 de octubre de 2009

NetBeans IDE 6.7.1

Ruby is Supported on the NetBeans IDE 6.7.1 too the JavaFX the new rival for AdobeFlash. If you want to try it download from the official site: http://www.netbeans.org/downloads/index.html

viernes, 25 de septiembre de 2009

ALTER TABLE ON MYSQL

If you have constantly changes in your DB and don't want to make remake TEST DB to your
developers, on MYSQL, you should try using the ALTER TABLE.

Check the documentation on: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

miércoles, 23 de septiembre de 2009

Making an NO AJAX H:INPUT AN AJAX COMPONENT !

<h:outputText value="#{messages['batch.detail.filter.lastname']}" />
<h:inputText id="lastNameFilter"
value="#{batchOrderItemListView.batchOrderItemFilter.lastName}">
<a4j:support event="onchange" reRender="lastNameFilter" ajaxSingle="true" limitToList="true" />
</h:inputText>

Hora / Bolivia

Tags

Followers

Datos personales

Twitter Updates