Great Reviews!Need help setting up your website, installing Apache, PHP, MySQL, or RavenNuke(tm)?Need help customizing or designing scripts?Please contact us via the Contact Us option for further details and pricing.
"Structure" presents a list of the available tables in the database, with the follwing accompanying options:
Browse: shows the content of the table.
Select: is used to make SQL queries to the table.
Insert: is used to insert new data into the table.
Properties: displays the structure of the table, ie. its fields, their type, length etc.
Drop: deletes the table (be careful!).
Empty: empties the content of the table, but does not delete the table itself, it leaves it empty (be careful again!).
The most frequently asked questions in this context are:
How do I delete a single record of the table?
Select the table, click on "Browse" and select "Delete" for the record in question.
If the password is stored encrypted with MD5, how do I change it?
Select the table, click on "Browse", then on "Edit" and enter, in clear text, the desired password. Select from the drop-down "Function" menu besides the field the desired function, in our case
"MD5" (see Figure 3-9). See also Section 3.9.17.