In a table data is arranged into columns. A column stores data element, such as a person name, a price, or any similar type of information. When columns are created in a table, they are given a name that identifies their purpose and role, such as PersonName or Price. Usually, you must also specify additional properties, such as data type and how long the longest entry in the column will be, other properties can include the column is the table primary key.
With Database Designer for MySQL you can: