db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Re: adding a record to a table
Date Sat, 15 Feb 2014 20:05:00 GMT
Hello John

Table Specs:-
//s.execute("CREATE TABLE xxx_xxx(Trading_Date DATE NOT NULL, Trading_Time
//+ "Open_price DECIMAL(6,3), High_price DECIMAL(6,3),"
//+ "Low_price DECIMAL(6,3), Close_price DECIMAL(6,3),"
//+ "DOW_numeric INT, DOW_nominal VARCHAR(9), Hour_numeric INT,"
//+ "Hour_nominal VARCHAR(8), MA2 DECIMAL(8,7),"
//+ "MA6 DECIMAL(8,7), MA10 DECIMAL(8,7),"
//+ "Return_current DECIMAL(8,7), Class_current VARCHAR(4),"
//+ "Class1_predicted VARCHAR(4), Class2_predicted VARCHAR(4),"
//+ "Class3_predicted VARCHAR(4), Class4_predicted VARCHAR(4),"
//+ "Class5_predicted VARCHAR(4), Return6_predicted DECIMAL(8,7),"
//+ "Class6_predicted VARCHAR(4), Return7_predicted DECIMAL(8,7),"
//+ "Class7_predicted VARCHAR(4), Class_predicted VARCHAR(4),"
//+ "Trade_ID VARCHAR(30), Profilt_Loss DECIMAL(5,2),"
//+ "PRIMARY KEY (Trading_Date, Trading_Time)");

Does this help?

View this message in context: http://apache-database.10148.n7.nabble.com/adding-a-record-to-a-table-tp137120p137127.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message