EE 495M - Lecture 3 mySQL and PHP Overview
 | Name : EE 495M - Lecture 3 mySQL and PHP Overview File Type : Size : 100 KB |
EE 495M - Lecture 3 mySQL and PHP Mustafa Kamasak September 10, 2003 Overview Database Tier (MySQL) SQL Logic Tier (PHP) Presentation Web Server Tier (Browsers) · MySQL · SQL · PHP · MySQL & PHP interface MySQL - Basics · To start mysql type mysql -u username -p and enter your password when prompted. A commandline interface will be started. $ mysql -u ims -p Starting MySQL as user IMS Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19929 to server version: 3.23.47 Type help; or \h for help. Type \c to clear the buffer. mysql> · show databases will show the list of the databases in the server. mysql> show databases; +-------------------+ | Database | +-------------------+ | test1 | | test2 | +-------------------+ 2 rows in set (0.00 sec) mysql> MySQL - Basics · To create a new database use create database dbname mysql> CREATE DATABASE ee495m; Query OK, 1 row affected (0.00 sec) Ebook Relate: mysql ebook database ebook server ebook databases ebook create ebook show databases ebook create database ebook mysql basics ebook and php ebook |
| Server | Status |
| cobweb.ecn.purdue.edu | Alive |
