Hugo Estrada's House of Wonder

SELECT * FROM information_schema.tables

http://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-table...

I keep looking this up. so it has gain its place in this site:

GRANT EXECUTE ON procedureName to username

I was talking with Kate, of Maploser fame, about how one doesn't seem to find posts about ruby information on how to protect from sql injections. Kate, having incredible researching abilities, found this nice little tidbit on Ruby: Quick Visual Start http://my.safaribooksonline.com/9780321580658

db.execute("INSERT into testing (bogus, foo) values (?, ?)", variable1, variable2) 

This should work if you are using sqlite3, which happens to be what I am using at the moment.

I often forget this, so....

MySQL autoincrement == IDENTITY(1,1) as in

id int IDENTITY(1,1) PRIMARY KEY,