Archive for March, 2007
Wednesday, March 28th, 2007
MySQL won't let you delete from a table using a subquery that references itself. Fair enough. To get around this, up till now, I've used temporary tables. However, I've never really liked it, and I've always wanted a JOIN delete. Well, apparently it exists.
I'm cleaning ...
Posted in mysql | 1 Comment »
Thursday, March 22nd, 2007
Of course, I felt like an idiot after being completely confused by this for about half an hour.
Consider this:
awk "{print $1}" somefile.txt
This does not work as I had expected. The reason is because the $1 is evaluated within double quotes, (not single quotes). Yes, it's a ...
Posted in linux | No Comments »
Friday, March 9th, 2007
Using mysql -e's feature, combined with awk and xargs, I was able to call an existing stored procedure repeatedly for a resultset. Yes, I could have written another stored procedure to do this, I realize. But I guess I like doing things the hard way. Either that, ...
Posted in linux, mysql | No Comments »