Entries for tag: mysql

  • K.I.S.S. - Using Foreign Keys in MySQL (Ligaya Turmelle, 2008-03-24)
    No, foreign keys aren't from Brazil or Italy or even the US. Though they can be a bit strange to those who do not understand them, have no fear. We are here to teach you how to talk to them so they can serve your whims.
    Other tags: art   databases   foreign keys   homepage   php  
  • Now that we've become familiar with the fundamentals of stored procedures it is time to start playing with the “Big Boy Toys”. This article will go over stored procedures's built in error handling, the security features available, various “extras” available, what isn't allowed in a stored procedure, and some basic administration of the stored procedures. So lets stop talking and bust open the toy box and start playing!
    Other tags: art   stored procedures  
  • With the release of MySQL5 a bold new world opens up to the PHP developer... the world of a database programmer. In this world the interaction with the data can be done right where the data is located - not in a script that is far far away in a distant server. In this article we will be taking you on a journey that will introduce you to MySQL's stored procedures.
    Other tags: art   stored procedures