Home

Design Tips For Tables / Forms

After logging into the Administrator Page, click the team1 database, then click sample_table, then click Alter table button at the top, then click Comment checkbox at the bottom. Now observe how Serial_Number is defined as Auto Incrementing Field.

For majority of your data fields, choose varchar data type, as it allows you to save Alphabets, Numbers and even Commas. For length, you can choose any number of characters. For example, choose 30 for Name fields.

For storing large amount of text, including multi line text, choose text type.

For storing numbers / integers choose int type and for storing fractions, choose decimal.

Follow my example sample_table, whenever you have a query.