As first step of this guide we will create a table in the database.

• Open any database tool of your choice
• Create a database. For example 'guide'
• To this guide database create a table named 'team'

'create_table' by J2EE Spider Tags: guide Taken on May 02, 2008

View the properties of the table:
 

'table_properties' by J2EE Spide... Tags: guide Taken on May 02, 2008

• Now add any field to this table and mark it as the primary key. For example `id_team'.  
• Set the `id_team' field as auto-increment so that it is able to hold serial and sequential data.   
• The 'id_team' gets incremented automatically whenever a new record is added.