Tool bar HOME |
Define Column StructureAfter having specified the name of the table to be created or the number of fields to add to existing table, you will be prompted to define the structure of the table. The number of rows of the form will equal to the number fields you specified in the previous page. Fill the fields accordingly to specify the structure of the table and press "Create Table"/"Add Column" to create the table/add the columns. Please note that all rows must be filled, otherwise an error will occur. For more details regarding to CREATE TABLE... query, please refer to mySQL online reference at http://www.mysql.com/Manual_chapter/manual_Reference.html#CREATE_TABLE For more details regarding to ALTER TABLE... ADD [COLUMN]... query, please refer to mySQL online reference at http://www.mysql.com/Manual_chapter/manual_Reference.html#ALTER_TABLE
|
Tool bar
HOME
|
Related topics: Create table , Add fields |