Click here to Skip to main content
14,391,646 members
   

Database

 
QuestionMongoDB Transactions Pin
Kevin Marois13-Feb-19 15:25
professionalKevin Marois13-Feb-19 15:25 
AnswerRe: MongoDB Transactions Pin
k505414-Feb-19 7:09
Memberk505414-Feb-19 7:09 
QuestionC# MongoDB Question Pin
Kevin Marois10-Feb-19 8:58
professionalKevin Marois10-Feb-19 8:58 
AnswerRe: C# MongoDB Question Pin
k505412-Feb-19 7:07
Memberk505412-Feb-19 7:07 
AnswerRe: C# MongoDB Question Pin
jschell23-Feb-19 12:11
Memberjschell23-Feb-19 12:11 
QuestionSQLite how to delete rows in a table (C++) Pin
steve_94966138-Feb-19 6:08
professionalsteve_94966138-Feb-19 6:08 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
k50548-Feb-19 8:21
Memberk50548-Feb-19 8:21 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 22:30
professionalsteve_949661310-Feb-19 22:30 
Thank you k5054.

I have not set a PRIMARY KEY in my table but the "DataOra" column contains a timestamp in the form "YYYY/MM/DD hh:mm:ss" so I think I could use this information to select the rows to delete.

But to do this I need to read the value of row 5000 without any information about this row, I mean that I have not a PRIMARY KEY and I just know the row number, is this information enought to read row 5000?

And if I read row 5000, then I can use a command like:
"DELETE FROM EVENTI WHERE DataOra < 'YYYY/MM/DD hh:mm:ss'"

or I have to convert in some way my timestamp?

Thank you
GeneralRe: SQLite how to delete rows in a table (C++) Pin
k505413-Feb-19 8:14
Memberk505413-Feb-19 8:14 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661320-Feb-19 21:55
professionalsteve_949661320-Feb-19 21:55 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
k505421-Feb-19 8:15
Memberk505421-Feb-19 8:15 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661325-Feb-19 5:25
professionalsteve_949661325-Feb-19 5:25 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
Mycroft Holmes8-Feb-19 13:50
MemberMycroft Holmes8-Feb-19 13:50 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 22:56
professionalsteve_949661310-Feb-19 22:56 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
Mycroft Holmes11-Feb-19 11:53
MemberMycroft Holmes11-Feb-19 11:53 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
Richard MacCutchan8-Feb-19 23:44
mveRichard MacCutchan8-Feb-19 23:44 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 22:58
professionalsteve_949661310-Feb-19 22:58 
Questionfinding periods Pin
joost.versteegen8-Feb-19 5:22
Memberjoost.versteegen8-Feb-19 5:22 
AnswerRe: finding periods Pin
joost.versteegen9-Feb-19 11:40
Memberjoost.versteegen9-Feb-19 11:40 
Questionupdate temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 4:32
Memberjoost.versteegen7-Feb-19 4:32 
AnswerRe: update temp table with results from sub query (actually it is a function) Pin
ZurdoDev7-Feb-19 5:36
professionalZurdoDev7-Feb-19 5:36 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 5:45
Memberjoost.versteegen7-Feb-19 5:45 
AnswerRe: update temp table with results from sub query (actually it is a function) Pin
Richard Deeming7-Feb-19 9:34
communityengineerRichard Deeming7-Feb-19 9:34 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 12:20
Memberjoost.versteegen7-Feb-19 12:20 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 21:33
Memberjoost.versteegen7-Feb-19 21:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.