MySQL Forums
Forum List  »  Newbie

Need help with table set up
Posted by: David Rix
Date: August 19, 2005 04:16AM

Hi,

I am new to this...

I want to create a table in phpMyAdmin but am a little confused over the auto incre and the index, unique etc..

This is what I have so far -

regid - I want this to auto add a number to give a registration ID
regdate - The date of the first input
firstname - varchar 30
lastname - varchar 30
phone - not sure 20
email - varchar 40
comments - I want about 200 characters in this area

Am I correct? Is there anything else I should know about each of these fields before I create it?

In phpMyAdmin I am confronted with these options and not sure about them. so have left them empty or as the default.

Field Type Length/Values* Collation Attributes Null Default Extra Primary Index Unique --- Fulltext

I'd be grateful for the help in setting this up. I learn better by seeing what it is the finding out why.

Thanks

David

Options: ReplyQuote


Subject
Written By
Posted
Need help with table set up
August 19, 2005 04:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.