Watch, Read, Listen
-
One year ago today, 8/18/2009, I was getting ready to go to lunch with Matt, Jorge and a consultant at work
-
I watched the old John Wayne “Alamo” movie and wondered about the text of the letter Travis sent out. To the People of Texas and All Americans in the World: Fellow citizens and compatriots: I am besieged, by a thousand or more of the Mexicans under Santa Anna—I have sustained a continual Bombardment and cannonade…
-
Taken directly from Brian’s page and added here so I don’t have to keep searching for this the one time a year that I need it, delete T1 from MyTable T1, MyTable T2 where T1.dupField = T2.dupField and T1.uniqueField > T2.uniqueField
-
I have be using more javascript and css than I would like recently, but the power is amazing. My most recent revelation was that “read only” is for suckers, and using “disabled” is a better way to protect elements in forms from user access. the main reason is because you can set disabled=[true|false] on any…
-
This script will backup your mysql DB using mysqldump, but because mysql dump locks the entire DB, this script only backs up one table at a time, thus only locking one table at a time. #!/bin/sh # System + MySQL backup script # Copyright (c) 2008 Marchost # This script is licensed under GNU GPL version…
-
I was shocked to discover at my new gig that the database password that Tomcat loaded up into JNDI were not encrypted on the live site. I was even more shocked that Tomcat does not provide a quick fix for this. So here’s mine. Encode the password in your text file, and figure out where…
-
Here’s my problem. I’m making the following SQL call from my application: select a.*, b.* from foo a, bar b where a.[column]= b.[column] I don’t know on the application end what fields are in what table, and I don’t know what field the join will be on — that’s all dynamic. I need to know…
-
SELECT CONCAT(TABLE_NAME,’.’,COLUMN_NAME) FROM information_schema.COLUMNS where TABLE_SCHEMA=’foo’ and TABLE_NAME like ‘USER%’
-
I’ve been thinking about the Texas School Board flap, and I’ve decided that
-
double click on a word to highlight it. Shift+F3 capitalizes the first letter. Shift+F3 again capitalizes the whole word. Shift+F3 a third time lower cases the word. Probably should make a macro for this in Intellij…