- learn("CREATE TABLE IF NOT EXISTS " +
- "People(" +
- "PID INTEGER PRIMARY KEY AUTOINCREMENT,"+
- "nick VARCHAR(16)"+
- //TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM").
- "lastspoken CHARACTER(16),"+
- //The mode the bot was in last time speaking
- "lastmood varchar(10),"+
- "timesSpoken INTEGER NOT NULL);");
- //Answer questions
- learn("CREATE TABLE IF NOT EXISTS " +
- "Questions(" +
- "QID INTEGER PRIMARY KEY AUTOINCREMENT,"+
- //TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM").
- "why varchar(255),"+
- "what varchar(255),"+
- "how varchar(255),"+
- "are varchar(255),"+
- "who varchar(255),"+
- "where varchar(255),"+
- "subject varchar(255),"+
- "answer varchar(255));");
- //ERROR: Failed to execute: 'CREATE TABLE IF NOT EXISTS People(PID INTEGER PRIMARY KEY AUTOINCREMENT,nick VARCHAR(16)lastspoken CHARACTER(16),lastmood varchar(10),timesSpoken INTEGER NOT NULL);'
- ERROR: java.sql.SQLException: near "lastspoken": syntax error
- ERROR: Failed to execute: 'CREATE TABLE IF NOT EXISTS Questions(QID INTEGER PRIMARY KEY AUTOINCREMENT,why varchar(255),what varchar(255),how varchar(255),are varchar(255),who varchar(255),where varchar(255),subject varchar(255),answer varchar(255));'
- ERROR: java.sql.SQLException: near "where": syntax error
Undefined
By: Guest | Date: Jun 22 2010 20:25 | Format: None | Expires: never | Size: 1.59 KB | Hits: 912
Latest pastes
1 days ago
2 days ago
4 days ago
6 days ago
6 days ago