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.
|
|
|
|
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 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 |
|
|
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-2009 Mike
Murach & Associates, Inc. All rights reserved.
|