Sara Mercedes Cornejo Portillo
Ya nació mi hija Sara Mercedes. Una preciosa bebita que nació el 23 de Agosto del 2006 a las 3:45 am y que no me ha dejado dormir desde entonces.
Peso 3 Kg y midio .51 m
Firebird 2.1 UPDATE OR INSERT
Another great feature that I like in Firebird 2.1 is the UPDATE OR INSERT statement. It's a really time saver and it makes the SQL cleaner. For example suppose I have a products table like the one I use in my last post and an inventory table to store the product stock. Before Firebird 2.1 if I want to set the stock for a product I needed to check if a record for that product_id already exists; if the product_id already exists then I write an update. If not then I write an insert statement. So I ended up with something like this: IF EXISTS(SELECT * FROM inventory WHERE product_id = :product_id ) THEN UPDATE inventory SET stock = :stock WHERE product_id = :product_id; ELSE INSERT INTO inventory (product_id, stock) VALUES (:product_id, :stock); In this example I only update one field but when I have to update a big table I ended up with a big chunk of code and thinking: "there should be another (better) way to do this". Fortunately now with
esta bonita nina tan bonita pero latosa jijiji de verdad
ResponderBorrarMuchas felicitaciones Mario, los mejores deseos para ti y toda tu familia.
ResponderBorrarGracias
ResponderBorraresa soy yo :) estaba tan pequeña. :3
ResponderBorrar