E1 - Creating database from MySQL console

Open phpMyAdmin (see Getting Started) and enter these commands:

1. Create the Neat Treats database.
   

   CREATE DATABASE NeatTreats; 

2. Make sure you edit this database going forward.
   

   USE NeatTreats; 

3. Create the welcome message table in the new database. Don't worry about relationships yet.
   

   CREATE TABLE WelcomeMessage ( MessageID INT, Message VARCHAR(255) ); 

4. Insert a row into the table. Make sure to use ' single quote rather than " double.
   

   INSERT INTO WelcomeMessage (MessageID, Message) VALUES (1, 'Welcome'); 

Parent topic: Example 1