The following definition for the MySQL table "test" is intended to work with our JDBC servlet tutorial. You can paste this definition into your MySQL control panel to create the test table to work with.

create table test (
name char(30),
address char(30),
city char(20),
phone char(15)
)\g

insert into test values ('Michael Smith','123 Main Street','Smithville','555-1212')\g
insert into test values ('John Jones','655 Maple Ave.','Jonestown','555-1212')\g
insert into test values ('David Clark','743 Hollywood Blvd.','Hollywood','555-1212')\g

Note: MMA technical support staff cannot provide troubleshooting of problems with third-party CGI scripts including but not limited to: Perl scripts, C/C++ binaries, PHP or web/database integration unless these services are specifically contracted. For these services, please see our Quote Request Form.