mysql problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
valen53
Forum Contributor
Posts: 137
Joined: Tue Aug 27, 2002 9:29 am

mysql problem

Post 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 ?
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post 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?
Post Reply