Simple DDL stuff, what's wrong?

#1

Hi,

Some mySQL tool created the following script with its Preview,
however, it failed to execute without clear err msg as to how. Any
idea? Thanks.

alter table `myDB`.`myTBL`
change `future` `future` bit(1) NULL ,
change `active` `active` bit(1) default '1' NOT NULL;

#2

On Nov 25, 3:18*pm, justaguy <do... (AT) yahoo (DOT) com> wrote:

Quote:

Hi,

Some mySQL tool created the following script with its Preview,
however, it failed to execute without clear err msg as to how. *Any
idea? *Thanks.

alter table `myDB`.`myTBL`
* *change `future` `future` bit(1) NULL ,
* change `active` `active` bit(1) default '1' NOT NULL;

Never mind, silly me, the tool developer would probably have to do
some parsing for the non-standard sql code, I could do it from sql
command line...

#3

On 11ÔÂ26ÈÕ, ÉÏÎç4Ê±18·Ö, justaguy <do... (AT) yahoo (DOT) com> wrote:

Quote:

Hi,

Some mySQL tool created the following script with its Preview,
however, it failed to execute without clear err msg as to how. Any
idea? Thanks.

alter table `myDB`.`myTBL`
change `future` `future` bit(1) NULL ,
change `active` `active` bit(1) default '1' NOT NULL;

you should wrote like this

Quote:

change column `future` `future` bit(1) NULL,
change column `active` `active` bit(1) default '1' NOT NULL;

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Simple DDL stuff, what's wrong?

comp.databases.mysql comp.databases.mysql

Simple DDL stuff, what's wrong? - 11-25-2011 , 02:18 PM

Re: Simple DDL stuff, what's wrong? - 11-25-2011 , 05:36 PM

Re: Simple DDL stuff, what's wrong? - 11-29-2011 , 10:06 PM