Change table value and non empty value

Chrysanthus

Hi i wounder how i can change i existing and runing mysql table value

like exampel

nickname varchar(32) default NULL UNIQUE,
password varchar(32) default NULL,
firstname varchar(32) default NULL,
lastname varchar(32) default NULL,

this fealds exist and are runing but i wanna change the value into
a value that checks if the rows are empty. if the fealds are empty non value will be inserted..

I don't want php to check this row, i want mysql to check this row..

nickname varchar(32) default NULL UNIQUE, no blank
password varchar(32) default NULL, no blank
firstname varchar(32) default NULL, no blank
lastname varchar(32) default NULL, no blank

LordShryku

Couldn't this just be accomplished by an ALTER TABLE changing it to NOT NULL with a default of "something"?

Chrysanthus

i have never dun that can you give an exampel on havo to do that?

LordShryku

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ALTER_TABLE

Real simple...

ALTER TABLE tablename
MODIFY fieldname VARCHAR(30) NOT NULL DEFAULT "whatever";

Chrysanthus

thanks :p it works man, now i know how i do that to!!

Chrysanthus

humm nothing happend whene i try to insert value now...

now the table look like this

is it right

CREATE TABLE reg_info

(regid int(11) NOT NULL auto_increment,

nickname varchar(32) NOT NULL UNIQUE,
password varchar(32) NOT NULL, is the right syntax for non empty inserts value
firstname varchar(32) NOT NULL, is the right syntax for non empty inserts value
lastname varchar(32) NOT NULL, is the right syntax for non empty inserts value
birthdate varchar(8) default NULL,
gender ENUM('M','F') default NULL,
email varchar(32) default NULL UNIQUE,
country varchar(32) default NULL,
city varchar(32) default NULL,
gotmember ENUM('yes','no') default NULL,
regdate TIMESTAMP(14) default NULL,

PRIMARY KEY (regid));

LordShryku

Let's see the insert statement.
And are you inserting through PHP, or some front end?

Chrysanthus

It's is from the php

LordShryku

Can we see it? Are you using mysql_error() to try to get an error back? Are you bumping against a unique constraint maybe?