Contents:
Logging in
back to contents
|
Go to https://andromeda.rutgers.edu/phpmyadmin/ and login MYSQL username and password. |
Phpmyadmin Home
back to contents
|
This is the main page. The tab on the far left shows you listing of current databases and existing tables which will be indented under its parent database. Note: Tables haven't been created in picture thereby there are no indented "tables" listing. |
Using Databases
back to contents
|
On the home page click on "databases" to view existing databases on right window. You should select one database to "use" ( i.e let mysql know that you tend to read, write or manipulate tables on that database ). |
Creating Tables
|
If you have no existing tables created, you will be prompted to create a table once you "use" a database. The "Name" indicates the name of table while the "Fields" indicates number of columns for that particular table. You will then be prompted to declare variables and variable lenghts for each fields including comments. See below. Notice the mysql commands at the top of page once these variables are declared. |
back to contents
Inserting Entries
back to contents
|
Click on "insert" tab and you be prompted to assign values to your variables in the "value" field. In this case F_NAME=>"Foo", L_NAME=>"Bar", PHONENUM=>"00000000". Click on the "browse" tab to view your entries. |
Editing Entries
|
Click on the edit "notepad and pen" icon next to the entries to edit that particular entry. You will prompted, similar to page above, to enter new value of variable. See below Click on "browse" tab to view your edits. |
back to contents
Deleting Entries
|
Click on the delete "trashcan" icon next to the entries to delete that particular entry. You will prompted to verify delete. See below Click on "browse" tab to view your edits. |
back to contents
Searching Entries
|
Click on the "search" tab then select at least one field to search for entry. Then enter value to query in then "value" input field. If successful, results are displayed as in below |
back to contents
Exporting Data
|
Users can export data in other formats that can be used by other database managers. In picture, data was exported to "CSV" format, used by Ms Excel. Click on "export" tab, choose format type in the "Export" table, then select "Windows" version in the "Excel edition" field in the "Excel options" table. The results can be copied and pasted in a test format and later opened with "Ms Excel". |
back to contents
Emptying Table
back to contents
|
Click on empty tab to empty table of all entries. You will be prompted to confirm empty |
Dropping Table
back to contents
|
Click on drop tab to delete table. You will be prompted to confirm drop |
Print View
back to contents
|
The "Printview" link at the bottom of the browse page offers the option of printing data from selected tables. |