1 / 24

MySQL basics

MySQL basics. WAMP server AppServer phpMyAdmin DB creation with phpMyAdmin. MySQL. Apache server. MySQL. Browser. HTTP/HTML. DB. DBMS. SQL. PHP. Main parts of the server. Operating system Linux, Windows, Mac OS etc. HTTP server Apache, ISS, GWS, lighttpd etc. DBMS

idania
Télécharger la présentation

MySQL basics

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 basics WAMP server AppServer phpMyAdmin DB creation with phpMyAdmin

  2. MySQL Apache server MySQL Browser HTTP/HTML DB DBMS SQL PHP

  3. Main parts of the server • Operating system • Linux, Windows, Mac OS etc. • HTTP server • Apache, ISS, GWS, lighttpd etc. • DBMS • MySQL, MS SQL Server, PostgreSQL etc. • Programing language • PHP, Perl, Python

  4. WAMP server • Operating system • Linux, Windows, Mac OS etc. • HTTP server • Apache, ISS, GWS, lighttpd etc. • DBMS • MySQL, MS SQL Server, PostgreSQL etc. • Programing language • PHP, Perl, Python

  5. Why WAMP • Windows – most popular OS for personal computers • Apache – >50% of all servers on the internet • MySQL - most popular opensource DBMS (Facebook, Wikipedia etc.) • PHP – most popular programming language for web systems (Facebook, Wikipedia, Youtube etc.)

  6. AppServer • Homepage • http://www.appservnetwork.com/ • Download • http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.10.exe?download • Install instructions • http://www.appservnetwork.com/modules.php?name=Content&pa=showpage&pid=8 • For MacOS • XAMPP - http://www.apachefriends.org/en/xampp.html

  7. http://localhost

  8. phpMyAdmin (1)

  9. phpMyAdmin (2)

  10. Naujos DB kūrimas

  11. Naujos lentelės kūrimas (1)

  12. Naujos lentelės kūrimas (2)

  13. Naujos lentelės kūrimas (3)

  14. Pagrindiniai MySQL laukų tipai • VARCHAR – kintamo ilgio tekstinis laukas • Reikia nurodyti maksimalų lauko ilgį (iki 255 simb) • TEXT – laukas ilgam tekstui saugoti • INT – laukas sveikam skaičiui saugoti • FLOAT – laukas trupmeniniams skaičiams saugoti • DATETIME – data ir laikas • YYYY-MM-DD HH:MM:SS

  15. Lentelių valdymas

  16. Lentelės valdymas

  17. Naujo įrašo įterpimas

  18. Įrašų peržiūra

  19. Eksportavimas (1)

  20. Eksportavimas (2)

  21. Eksportavimas (3)

  22. Importavimas (1)

  23. Importavimas (2)

  24. Exercise • Move your database from Excel to MySQL using phpMyAdmin • DB name should start with 3 letters of your first and last ames • firlas_library • Export the DB and send the .sql file to this e-mail address arunas@tiny.lt

More Related