At 21:29 -0400 10/24/01, [EMAIL PROTECTED] wrote: >Greeting! I am trying to convert an application from a DB2 based >program to MySQL. We are still evaluating MySQL and learning. >We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to >create the database. The Java version of this program using this >driver is not creating some of the tables. The errors indicate a >syntax problem in the prepare statement in the Java code. The >original code ran on OS/2 and the sql was embedded something >similar to the following sample: > > EXEC SQL CREATE TABLE Patient_Info_Table > (medical_record_# CHAR(16) NOT NULL PRIMARY >KEY,
# is not a legal character in a column name unless you enclose the name in backquotes (`medical_record_#`). Maybe use medical_record_no instead? > date_of_birth CHAR(10) NOT NULL, > patient_name CHAR(48) NOT NULL, > addr_line_one CHAR(48), > addr_line_two CHAR(48), > city CHAR(24), > state CHAR(2), > country_code CHAR(3), > zip_code CHAR(10), > telephone CHAR(48), > t_and_d_stamp TIMESTAMP, > comments CHAR(128), > previous_addr INTEGER, > guardian_info INTEGER, > emergency_info INTEGER, > total_hpps INTEGER, > supp_data INTEGER, > appt_time TIME, > appt_date DATE, > appt_location CHAR(48), > office_code CHAR(16), > fsdstatus_flag INTEGER, > galaxy VARCHAR(512) Max varchar length is 255. You can use TEXT instead, perhaps. > ); > -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
