On Thu, Aug 1, 2013 at 7:53 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:
> It fails because > > ALTER TABLE x > ADD COLUMN data2 VARCHAR(10) NOT NULL DEFAULT 'foo', > > end in , instead of ; > > You have to add the column before you can alter it. > =/ That's the way I have it in the SQL Fiddle sample I provided. I was asking what Mr. Broersma was suggesting. I appreciate the effort by both of you, but it seems my points aren't getting across. Is there something more I can do to clarify?