WPI Web Ware 2004 Summer
Course Documents
Assignments
Validation
                                          
Printer Friendly Version
Database

[ Intro ] [ Database.jsp.code ] [ mysql-connector-java-3.0.14-production-bin.jar ] [ mysql-connector-java-3.0.14-production.zip ]

Up: Examples ]

Table name: students
ID last_name first_name grade
2 Kelly Elizabeth 698.2

3 Kohler Michael 200.4

3 Murphy Robert 2

Please enter query



List of handy dandy SQL commands

  • INSERT INTO table_name ( column_name_1, ..., column_name_n ) VALUES ( value_1, ..., value_n )
  • SELECT column_name_1, ..., column_name_n FROM table_name WHERE condition
  • UPDATE table_name SET column_name_1 = value_1, ..., value_n WHERE condition

Notes:

  • It is not necessary to put a semi-colon (or any command terminator) into your SQL query. The JDBC driver takes care of that.
  • Remember to escape your single quotes " ' "
  • Enter only one SQL statement at a time.

by: Keith A. Pray
Last Modified: August 11, 2004 12:13 AM
© 2004 - 1975 Keith A. Pray.
All rights reserved.

Current Theme: 

Kapowee Hosted | Kapow Generated in 0.304 second | XHTML | CSS | Section 508