As developers we write code everyday, only to frown at it a week after that. Why do we have such a hard time with code written by others and ourselves, this raging desire to rewrite everything we see? Writing code that survives the test of time and self judgment is a matter of clarity and simplicity. Let’s talk about growing, learning and improving our code with calisthenics, readability and good design.
![AJAX e PHP: Aprendendo a base [Parte 2]](/images/blog-placeholder-12_hufb398b366333ab6ced05513661a71e86_176380_420x184_fill_q80_h2_lanczos_smart1_3.webp)
Continuando o post anterior , seguiremos agora para o módulo PHP, HTML e a conclusão do artigo.
Read More
Nunca havia entendido o grande motivo para ter um blog e escrever artigos, até que meu bom amigo Leonardo França me incentivou a iniciar este blog.
Read More
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.
Read More