Re: [JUG-Indonesia] Error ketika insert tabel..

[sm96]

lupakan saja wonderingnya, masalah udah solve kan?


On Sun, Dec 27, 2009 at 11:48 AM, Hadi <kd_kur...@yahoo.com> wrote:

>
>
> saya coba perintah
> > show create table t_shoppingcart;
> muncul
>
> | t_shoppingcart | CREATE TABLE `t_shoppingcart` (
>   `id` bigint(20) NOT NULL AUTO_INCREMENT,
>   `customer_id` bigint(20) DEFAULT NULL,
>   PRIMARY KEY (`id`),
>   KEY `FK7D0FB293ECC4492E` (`customer_id`),
>   CONSTRAINT `FK7D0FB293ECC4492E` FOREIGN KEY (`customer_id`) REFERENCES
> `t_cust
> omer` (`id`)
> ) ENGINE=InnoDB
>
> customer_id sudah didefault null dari awal..
> tp saya coba aj perintah
> > alter table t_shoppingcart modify customer_id varhcar(20) default null;
>
> saya tes insert table ordernya, dan bisa..
> just wondering, knp bisa begitu ya? Padahal customer_id sudah ter set
> default null dari awal..
>
> Anyway, makasih mas ifnu..
>
>
>
>
>
>
>
>  
>



-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com <gtalk%3asyaiful.mukh...@gmail.com>