FW: Q: max value?

Hi! Does anybody knows how can I check whether the max value in some database's field has been reached? For example, I have MEDIUMINT column and I want to reset its value once it reaches its maximum, that is 8388607. How can I check which is the maximum (min) value I can insert into field? Bye!

char() problem

database,sql,query Hi! I really need to know this: I have a column defined as char(2), default 'no', not null. When I create new entry into the table, I skip entering value into mentioned column because I expect to be filled with the default value, that is 'no'. But that doesn't happen! Why?

?

DROP TABLE IF EXISTS recepti; CREATE TABLE recepti ( rid smallint(6) NOT NULL auto_increment, put varchar(20), nazivStranice varchar(15), nazivRecepta varchar(60), brojOsoba varchar(15), uvod text, slika varchar(40), nacinPripreme text, savjet text NOT NULL,

?

Thanks! I have another question, though: I need to force my search engine I'm building to make matches with multiple fields and tables. I managed to make, a match throughout multiple fields but single table: SELECT rid,nazivRecepta,MATCH nazivRecepta,uvod,nacinPripreme AGAINST ('vegetine') as