To modify or delete an existing table select the database that contains it by clicking on the database
name in the left column
a listing of all the tables in the database will appear with several options under the action heading
if we click the browse button.
We can browse through all the data in our table since we have no data an empty result set.
Message appears at the top.
It's not a good practice to press the back button and BHP might mean to navigate back to the table administration
area.
CLICK THE DATABASE NAME AGAIN.
This takes you right back to the beginning.
To modify the structure of our database click structure
a listing of all our columns appears
we can delete a column by clicking the drop button we can change the structure of a column by clicking
the change button
once you're finished making your changes always remember to press the save button otherwise your changes
will not be.
We can run a search in our database by pressing the search button on this page that loads you can input
this search text into the value field make sure to select the appropriate search.
OPERATOR So for example if you're looking for a first name that matches the name Ted Smith.
You would choose do you like operator and enter the value corresponding to the first named column if
you're looking for an I.D. that matches a specific value you would select the equals operator and enter
the value in the adjacent text field
once you determine your search criteria you simply press go and it'll conduct the search for you we
can insert data into our database by clicking the insert button
to insert a record enter the data
and we would click go.
Now remember we don't have to insert anything in the I.D. field because that value is automatically
assigned.
Remember it's an auto incrementing number which is our primary key in the last column date.
We don't have to enter anything either because it's going to automatically record the time this record
was created.
So I'll go ahead and click go
now to see our new record.
Click the browse button.
We can see our table now has one record first name.
Ted last name Smith email the I.D. was assigned a value of 2.
Now this is because I had a record in here previously and I deleted it so in increments from that point
forward so since I already had a record its idea was one I deleted it.
So we created this record with an I.D. of two the next record would be three and four and so on the
date was automatically time stamped in the date column.
The last two options here are empty and drop the empty button or empty all the data in the table the
drop button will permanently delete the entire table.
So be careful with these options.