Monday, 15 March 2010

MySQL set No Null for all columns -



MySQL set No Null for all columns -

is there way set columns "not null" in table? on gameserver have lots of tables , oclumns "null" , need them "not null". can help me? thinking help me

update player set * = not null;

but wont work.

try that

alter table player modify your_column int(11) not null;

if int int if varchar varchar , on

mysql

No comments:

Post a Comment