In MSSQL, I needed to loop over a bunch of orders and execute a stored procedure, except in one case. This does that:
By halfgaar, 1 year ago, on September 30, 2013, at 14:09 |
These are some random new PostgreSQL features that I'm interested in: The EXECUTE USING feature in PostgreSQL 8.4 will allow the use of more secure dynamic SQL in PL/PgSQL.
By Rowan Rodrik, 6 years ago, on April 15, 2009, at 22:04 |
When I clone a production database to a development database, I always need to empty the development database first. I could never find an SQL command to completely purge a database, bur, recently, I learned something about MySQL that surprised me: MySQL doesn't lose the user rights for a database when you drop it. So, purging a MySQL database (without losing any access data meta data about that DB) is as simple as issuing the following statements:
By Rowan Rodrik, 6 years ago, on July 12, 2008, at 01:07 |