nuk3 — Thu, 10 Apr 2003 05:49:01 +0000

Quote: Originally posted by mairving
Varchar is a variable character field. Which means that the field can contain letters and/or numbers and it is variable in size so it saves some database space.
Char is similar except that it doesn't save database space.
Int is for Integer or a whole number.
Null means that the field doesn't have to have a value.
Not Null means that the field must contain a value.

Here is a whole list of column types.

Thanks for that

brady.k — Wed, 09 Apr 2003 15:40:19 +0000

i figured it out...thanks

mairving — Wed, 09 Apr 2003 12:00:08 +0000

Varchar is a variable character field. Which means that the field can contain letters and/or numbers and it is variable in size so it saves some database space.
Char is similar except that it doesn't save database space.
Int is for Integer or a whole number.
Null means that the field doesn't have to have a value.
Not Null means that the field must contain a value.

Here is a whole list of column types.

nuk3 — Wed, 09 Apr 2003 08:52:45 +0000

While this topic is here, what is null, not-null, varchar, int and all this other stuff? What exactly does each one mean? Thanks..

Busy — Tue, 08 Apr 2003 23:59:16 +0000

u_id - small int 4 auto increment primary index (adds to bottom of list) 4 can go up to 9999 if you want more make it 5 or 6
u_name - varchar 15 (not many names are longer than 15 but can be whatever)
u_email - varchar 20 (agin not many over 20 but can be anything)

there are some reserved words so if it says something like it wasn't acceptable add a extra letter or underscore.

many ways to do it

brady.k — Tue, 08 Apr 2003 15:26:49 +0000

everything...i dont know what type or how to name...like i put in "name" as the name for the first one, and it said it wasnt acceptable...

they are plain text...2 fields: 1 name, 1 email address...i want each different entry to add itself to the db, and not overwrite the previous ones...so what are the different things i need to change for each field...thanks

mairving — Tue, 08 Apr 2003 12:09:20 +0000

How to name the fields? I think everyone has different methods. I usually name them by the tablename_fieldname. An id field would be tablename_id.

Is this what you are talking about or are you also talking about what type of field, text, varchar, date, int, etc, to name them. Anything greater than 255 characters should be a text field. Some common mistakes are making fields like phone numbers and zip codes int fields. This doesn't work if you try to put the - in phone or zip fields.