hello. I am not a coder so I aplogise for my naivety. I am using TRAC with a sqlite db called trac.db
I have the commanline sqlite3.exe in the same folder as the .db and need to now manipulate the db to manually remove a corrupt record. Once opened sqlite2 shows: sqlite> I need to know the commnad / string / line to remove remoce the effected ticket (record) from the ticket table. Can someone please help me with the terminogoly? I tried: .tables to show trables but nothing happens I tried DELETE FROM ticket WHERE 102 I think I am missing the boat here...is there an easy way to show the tables / database as text so I can manually remove problem? -- View this message in context: http://www.nabble.com/newbie-command-line-question-sqlite3-tp19098632p19098632.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
