Altering Table in SQL

[Guest]

I am adding a contribution called category description, and it is telling me to

 

ALTER TABLE `categories_description` ADD `categories_description` text NOT NULL ;

 

I am in my sql and am assuming I have to add another field to the "categories_description" table, but what does the text NOT NULL mean

 

Apologies if this is a stupid question!!!

 

Thanks

Colin

[natewlew]

The text part means that you can enter just about any character and enter a lot of characters in that field. The Not Null means that when you create a row something needs to be entered in that column (it can't be left blank).

[Guest]

The text part means that you can enter just about any character and enter a lot of characters in that field. The Not Null means that when you create a row something needs to be entered in that column (it can't be left blank).

 

Thanks, I was just a bit hesitant about adding the row, but once I pressed the button, I understood. I am more familiar with access and understood the values, just not in which fields I had to add them.

 

Oh well that was easier than I thought, there is bound to be a hiccup later!!!

 

Colin G.