How to Edit the MySQL Table User Interface in the PHP Backend
The MySQL database software includes the "Query Browser" application that lets you change the table interface. The interface changes the PHP backend and any applications that use the tables for information and dynamic data. Use the "alter table" MySQL statement to change the interface for each table. You can add a column, change a column type or delete a column using the alter statement.
Other People Are Reading
Instructions
-
-
1
Open the Query Browser software from the program menu. Log in to your database and open a new MySQL editor window.
-
2
Create the alter table statement. For instance, the following code adds a column to the "customers" table called "address":
alter table add address varchar(50);
The "varchar(50)" indicates that you want to add a string column to the table. You must specify the data type when adding a column.
-
-
3
Click the "Execute" button. The query runs and MySQL returns a "Success" message that lets you know the changes are complete.
-
1
