mysql basics n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
MySQL basics PowerPoint Presentation
Download Presentation
MySQL basics

Loading in 2 Seconds...

play fullscreen
1 / 24

MySQL basics - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'MySQL basics' - idania


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
mysql basics
MySQL basics

WAMP server

AppServer

phpMyAdmin

DB creation with phpMyAdmin

mysql
MySQL

Apache server

MySQL

Browser

HTTP/HTML

DB

DBMS

SQL

PHP

main parts of the server
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
wamp server
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
why wamp
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.)
appserver
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
pagrindiniai mysql lauk tipai
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
exercise
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