PHP DF: A comunidade de PHP no DF

Using User-Defined Varibles in MySQL

• September 28, 2006

• MySQL

Cast the first stone he who never made a mistake modeling a database! Every now and then in your career you will be face to face with a problem like this: due to the nature of a table’s data you created a table without a primary key, or using a composed key. So far so good, but due to an upgrade you see the need to have a unique key identifying all the registers in your table, in my case it was due to a AJAX interface.

So what now? You have a table full of data, and of course, as Murphy’s law will tell you, that data cannot be erased. MySQL will prevent you from turning a filled to a primary key if it finds duplicated values in the table. Quite a brain twister, but I did a little research and found a rather simple solution to the matter.

UPDATE: So it actually came to my atention that a query I had already tried does the job in an even simpler form, but my modelling tool executed the commands out of sync and that why i had problems. So this article stays on as a good example of how to use mysql variables.

OpenX 2.5 beta - Primeiras impressões

• March 28, 2008

• PHP, Software / Systems

Foi anunciado hoje o primeiro beta público do OpenX 2.5, a primeira versão puramente OpenX a ser lançada, digo isso por ser a primeira versão que incorpora as milhares de linhas que forma re-escritas, criando quase que praticamente uma nova aplicação.

On the blogging road...

• July 8, 2006

• Pessoal/Off-topic

Saudações visitantes, Por algum tempo pensei em entrar para este mundo “blogger”, mas não o blog pessoal de relatos pessoais sobre eventos diários, não faço coisas novas e diferentes o bastante para contar ao “meu querido diário”, então essa idéia nunca teria chances.