Crap. Here's the problem: (from the MySQL docs) The col_name=expression syntax is supported in MySQL 3.22.10 and later. Looks like we have 3.21.33c Think we could upgrade? I'd REALLY like to do it this way. I guess the other option is to use the insert into...(colnames) values, but that's a little harder to read IMHO.