MySQL basics
24
WAMP server AppServer phpMyAdmin DB creation with phpMyAdmin
description
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 - PowerPoint PPT Presentation
Transcript of MySQL basics
WAMP serverAppServerphpMyAdminDB creation with phpMyAdmin
Browser
Apache server
PHPPHPDBMS DBDB
HTTP/HTMLHTTP/HTML SQLSQL
MySQL
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
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
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.)
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
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
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 [email protected]
