Murach's Java Servlets and JSP (2nd Edition)
How to use MySQL as the database management system

This chapter shows how to use the MySQL DBMS to create a MySQL database, and it shows how to code SQL statements that work with the data in that database.
Chapter 13 How to use MySQL as the database management system
An introduction to MySQL 416
What MySQL provides 416
Two ways to interact with MySQL 418
How to connect to the MySQL database service 420
How to start and stop the MySQL database service 422
How to work with the MySQL monitor 424
How to start and stop the MySQL monitor 424
How to create, select, and delete a database 426
How to create and delete a table 428
How to insert or load data into a table 430
The SQL statements for data manipulation 432
How to select data from a single table 432
How to select data from multiple tables 434
How to insert, update, and delete data 436
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's Java Servlets and JSP

Learn more about this book

View the table of contents


More about the eBook