6 Queries A query is a command that tells the database to retrieve, modify, add, or delete a field or record The most common database query language is sQl From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Queries •A query is a command that tells the database to retrieve, modify, add, or delete a field or record •The most common database query language is SQL 6 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved
7 Example SQL Query SELECT Z工P=V43210 Name First Address City State Zip Airport ADAMS Charles 212 Market St. ColumbusOH43210 CMH ADAMs Edward 212 Market St. Columbus OH 43210CMH CARTER Marlene 411 Elm St Columbus OH 43210 CMH CARTER Beth 411 Elm St Columbus OH 43210 CMH CARTER Ben 411 Elm st Columbus OH 43210CMH CARTER Lisabeth 411 Elm St Columbus OH 43210CMH CARTER Mary 411 Elm st Columbus OH 43210CMH From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Example SQL Query • SELECT ZIP=‘43210’ 7 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved