)
If you are using phpMyAdmin, you can run your commands in the
SQL pop-up window or through the SQL tab.
6 creating the database
populate the tables
Finally, populate the tables in
the database by running these
two INSERT commands in the
mysql client, if you??™re using it.
(See extra bits on page 10.)
INSERT INTO departments (department) VALUES
(???Human Resources??™),
(???Accounting??™),
(???Marketing??™),
(???Redundancy Department??™);
INSERT INTO employees (department_id, first_name,
last_name, email, phone_ext) VALUES
(1, ???Laila??™, ???Smith??™, ???l.smith@thiscompany.com??™, 234),
(1, ???Laverne??™, ???Green??™, ???l.green@thiscompany.com??™, 235),
(1, ???Cal??™, ???Perez??™, ???c.perez@thiscompany.com??™, 230),
(1, ???Brian??™, ???Rogers??™, ???brianr@thiscompany.com??™, 231),
(1, ???Carla??™, ???Cox??™, ???cc@thiscompany.com??™, 233),
(2, ???Ezra??™, ???Howard??™, ???e.howard@thiscompany.com??™, 122),
(2, ???Gideon??™, ???Gray??™, ???g.gray@thiscompany.com??™, 128),
continues
creating the database 7
populate the tables (cont.)
If using phpMyAdmin, you can run your commands in the
SQL pop-up window or through the SQL tab.
Pages:
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28