Updating Existing Tables

You are here: Using Database Tools > DBMS > Working with Tables > Updating Existing Tables

Updating Existing Tables

Users with full access to the MySQL database can change table design, add and edit data, and delete the table. You cannot perform the procedures in this section unless corresponding privileges have been granted by the MySQL database administrator.

Note

TIME values in Sun ONE ASP DBMS are displayed in HH:MM:SS format ONLY. The -HHH:MM:SS to HHH:MM:SS formats supported in MySQL are not supported in DBMS. Therefore, if you are viewing a MySQL database that uses these unsupported TIME formats, the time will not display correctly in the DBMS tool. Likewise, TIME values cannot be entered in unsupported formats; HH:MM:SS must be used.

In this section:

Changing Table Design

Adding Data

Editing Data

Deleting Data