Stupid script for svn+vim

October 2nd, 2008

Opens all files that svn status shows as being new/altered…

#! /bin/bash

echo '' > tmp.diff

while (( "$#" )); do
      files=$(svn status $1 | sed 's/.      //')  $files
      svn diff $1 >> ~/tmp.diff
      shift
done

vim -p $files ~/tmp.diff

MySQL Certified DBA

October 2nd, 2008

Check.

Posted some thoughts here.

mysql.proc, wtf?

September 30th, 2008

mysql> update someTable set End = Concat (dEnd,’ ‘,tEnd);
ERROR 1146 (42S02): Table ‘mysql.proc’ doesn’t exist
mysql> update someTable set End = Concat(dEnd,’ ‘,tEnd);
Query OK, 222 rows affected (0.01 sec)
Rows matched: 246  Changed: 222  Warnings: 0

I’m pretty sure this this is an issues with grant tables not being correctly upgraded, but annoying as heck…