Workshop 3: Online Taxi Booking System: MySQL and Database design

a. Create passengers table


b. Structure of the table passengers


c. Create data 1


d. Create data 2


e. Read


f. Update


g. Destroy



1. Set up the MySQL tools



2. Rails will setup a new application directory for each of your web application projects.



3. One Rails is running you at http://localhost:3000, you need to configure database access. Connect to the database is specified in the config/database.yml file.



MySQL GUI connection settings


MySQL Administror window


Run select SQL command in MySQL GUI