alter

ALTER/CREATE

Alter a table or create a new one

WARNING! All the modifications of the table will be done permanently by pressing "Save" button. It is recommended to perform as fewer actions per time as possible, using 'Preview' option as well in order to avoid unrecoverable errors. Refer to Mysql online documentation: http://www.mysql.com/doc/en/ALTER_TABLE.html

CREATE NEW TABLE page appears when you hit the button "Create" on the Main Page:

Create a new table

Fill in 'Table Name' field, new column attribute fields and optional table type, Comment, create options if needed. See MySQL online manual for more details: http://www.mysql.com/doc/en/CREATE_TABLE.html

When you change column type or table type, the page will be reloaded by itself if your browser supports JavaScript. Depending on selected column type some column options will be disabled or enabled. For example BLOB or TEXT types allow only Not Null option, thus only Not Null checkbox will remain enabled. If your browser does not support JavaScript hit PROOF button.

Before you SAVE changes it is recommended to hit PROOF button first in order to disable options which are not allowed by current selection. This way you will avoid undesirable errors.

Once the table with the first column is created, the ALTER table page will be displayed, prompting to create and edit columns.

Please check MySQL online manual for details on ALTER syntax: http://www.mysql.com/doc/en/ALTER_TABLE.html

Alter existing table

It is recommended to create all the columns one by one, and then start to create the keys. To change any column attribute, or name of the table, make changes in the correspondent forms and press submit. To add column, type its name, type, attribute and state whether or not it must be placed FIRST or AFTER a particular column

When you change column types or table type, the page will be reloaded. Depending on selected column type some column options will be disabled or enabled. For example BLOB or TEXT types allow only Not Null option, thus only Not Null checkbox will remain enabled.

The field ORDER BY is used to reorder the table rows. See Mysql online documentation for more details.

To drop a column(s) hit the button X beside the column name. The column(s) will not be dropped until you hit SAVE button. In order to restore this column hit O button.

If new key consists of more then one column, the column names must be comma separated and typed in the order you want them to appear in the key.

Checkboxes on the left of key names are used to select keys to be dropped.

If one of the columns must assigned as AUTO_INCREMENT, you need to create the Primary Key first. Then checkboxes 'Auto_increment' will appear against each column composing Primary Key, only if the column is of an appropriate type and is able to become 'Autoincremented'. Selecting one of these checkboxes, we create 'Autoincremented' column. Only one Auto column is allowed in Mysql.

If you need to reload the table and discard all changes hit RELOAD button.

Before you hit SAVE button it is recommended to hit PROOF button first in order to disable options which are not allowed by current selection. This way you will avoid undesirable errors.

It is recommended also to check “Preview SQL query” checkbox in order to preview the generated query.

If you change the name of the table and hit SAVE AS button, then a new empty table with the same structure will be created.

Previous

TOC

Next

[Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]