Adobe Flex - Conheça esta nova tecnologia

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.

ZendCon '08: Day 02

• September 17, 2008

• Conferences , PHP

Ok, here we go, end of day 2 and I got a horrible sore throat, and a headache.. but let me try to tell about my day.

Being an Enabler

• December 19, 2012

• Community , PHP

When you look around at user groups you will notice that many groups have “leaders” or “managers”, this is usually the person who started the group and is not really calling the shots, but usually is giving direction to the group. This is an usual model and it works pretty well in most cases, however I have ran into situations where this causes some misconceptions.