ONE Active Server Pages Product Home Page Developer Site Version


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 icon 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