Chapter 3: Creating A Database

To create a database table (p. 49)

CREATE TABLE guestbook (guest_name varchar(24), guest_email varchar(32), guest_time 
  timestamp(12), guest_entry text);

To fill the table with information (p. 50)

(Note: This table creation code includes notations for you, the user, to press <tab> and <Return> while typing. If you are cutting and pasting this information, copy one field at a time rather than copying the entries including those characters.)

  Fred Jones
  <tab>fred@homemaker.org<tab>\n
  <tab>I love this site!<Return>

  Samantha Jones
  <tab>s_jones@company.com
  <tab>\n
  <tab>My husband Fred told me about this site, and I'm glad he did<Return>

  Suzy Jones
  <tab>suzy@middleschool.edu
  <tab>\n
  <tab>My parents 
  don't do anything but surf this site! Help!!!<Return>

  Fred Jones
  <tab>fred@homemaker.org
  <tab>\n
  <tab>I still love this site!<Return>

To set up a Web user name and password (p. 53)

GRANT ALL ON quickpro.* TO webber IDENTIFIED BY 'dreamweaver';

and

GRANT ALL ON quickpro.* TO webber@localhost IDENTIFIED BY 'dreamweaver';