On Thu, Aug 1, 2013 at 7:53 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
It fails becauseend in , instead of ;
ALTER TABLE x
ADD COLUMN data2 VARCHAR(10) NOT NULL DEFAULT 'foo',
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?
