mysql - Add Value For Enum In SQL -
i have database use enum in it.when try insert data in table ..... nothing happen!!
here code of enum part :
alter table `question` change `status` `status` enum ( 'pending', 'publish', 'answered' ) character set utf8 collate utf8_general_ci not null default 'pending';
and it's query :
query("insert `question`(`username`, `email`, `phone`, `content`,status) values ('$name','$mail','$phone','$content','pending')");
i ignore status ( because define default value ) , , try insert data again , still nothing happen!
what must done??!
Comments
Post a Comment