1 / 19

Database Management with MySQL and PHPMyAdmin Tutorial

Learn how to manage databases with MySQL and PHPMyAdmin. Follow the step-by-step guide to create tables, import/export data, and customize fields. Practice using SQL code and enhance your database skills.

wmorrow
Download Presentation

Database Management with MySQL and PHPMyAdmin Tutorial

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL and MyPHPAdmin

  2. Go to http://gamma.lasalle.edu/phpmyadmin and log in, usual La Salle username and La Salle ID as password

  3. PMA: phpMyAdmin interface to MySQL

  4. Create a database

  5. Create a table in your database – enter the name of the table, the number of fields and click Go

  6. Enter the table fields and their types, on the left is the NorthWind database Product table shown in Microsoft Access. Click Save on lower right.

  7. Result so far. Note it shows the SQL code.

  8. Forgot to make a primary key? Just click on the Primary key button next in the desired field row

  9. Choose to edit the UnitPrice field by clicking on the pencil icon

  10. Change the Length/Values entry. Then click Save.

  11. In Access have the NorthWind Product table selected (but not open), go to External Data/Export/Text File

  12. Choose a name and location for the exported data, I chose the .csv (comma separated values) extension. Click OK.

  13. Choose Delimited. Click Next.

  14. Choose a delimiter (comma) and a qualifier (quotes). Click Next.

  15. Result viewed in Excel. (Close)

  16. Back in PMA, select Product table and click Import

  17. Browse for CSV file. Fill in CSV options: terminated (comma), enclosed (quote), escape (backslash), lines terminate (backslash n)

  18. Success import message.

  19. Click Browse to see the imported data

More Related