> Hi,
> 
> after:
> 
> ALTER TABLE Job MODIFY COLUMN ClientId INT(11) NOT NULL
> DEFAULT '0'; 
> 
> result:
> (0 row(s) affected)
> Execution Time : 00:00:00:016
> Transfer Time  : 00:00:01:015
> Total Time     : 00:00:01:031
> 

Now, if you wonder the "0 row(s) affected" that is maybe because ALTER TABLE is 
a DDL and not a DML statement. It does not change any rows in the database.

Now, if you command

    DESC Job ;

It should show you that the default for ClientId is 0. Does it?

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users