Page 1 of 1

mysql problem

Posted: Mon Jun 02, 2003 8:38 pm
by valen53
each time i edit the mysql DB through phpmyadmin, normally edit the null to not null or add default value. After insert data to that table, page will become slower, then mysql stop connnected.

is it alter table also will make the mysql stopped?

another question is i set the default value to a field but each time i insert data, the default value was not created automatically. no matter i change null to not null or add default value already.

any method can set default value in mysql ?

Posted: Mon Jun 02, 2003 9:20 pm
by McGruff
blob and text columns cannot have default values - see mysql manual (can download copies from mysql.com)

I don't think editing a db should cause you to lose connection. Is it normally reliable?