cs4402 HK2 - Copy

cs4402 HK2 - Copy - mysql> select * from St;...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
mysql> select * from St; +------+--------+-------------+------+--------+------------+ | Snum | Sname | City | Dept | Degree | Major_Pnum | +------+--------+-------------+------+--------+------------+ | s1 | Andy | Baton Rouge | ECE | M.S. | p1 | | s2 | Baty | Baton Rouge | CSC | M.S. | p3 | | s3 | Cathey | Lafayette | ECE | Ph.D. | p2 | | s4 | David | Lafayette | CSC | Ph.D. | p1 | | s5 | Emily | New Orleans | CSC | Ph.D. | p4 | | s6 | Forest | New Orleans | ECE | Ph.D. | p5 | | s7 | Grace | New Orleans | EE | Ph.D. | p2 | +------+--------+-------------+------+--------+------------+ 7 rows in set (0.00 sec) mysql> select * from Prof; +------+----------+-------------+------+ | Pnum | Pname | City | Dept | +------+----------+-------------+------+ | p1 | Ada | Baton Rouge | CSC | | p2 | Basic | New Orleans | ECE | | p3 | C# | New Orleans | EE | | p4 | Database | Baton Rouge | CSC | | p5 | Fortran | Baton Rouge | ECE | +------+----------+-------------+------+ 5 rows in set (0.00 sec)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

cs4402 HK2 - Copy - mysql> select * from St;...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online