Tagged Questions
0
votes
1answer
192 views
MySQL INSERT-SELECT multiple rows from versioned table
I've got 2 versioned tables like this:
Items:
ID
rev_id
name
deleted
Subitems:
ID
rev_id
name
parent_id
deleted
What i understand from http://kristiannielsen.livejournal.com/6745.html that ...
0
votes
1answer
48 views
search for only the newest version of each record in a mysql table using date as version field
I have searched and I am unable to find an answer to this. Other links here exist, but they do not seem to be relevant as they reference only one or two tables, a statically known date that will be ...
1
vote
0answers
39 views
MySQL conditional database structure change
The problem is: I would like to create a conditional CREATE/ALTER scripts (the condition would be an integer value of database version). How to do it? Seems that MySQL IF won't help. Neither ALTER nor ...
0
votes
0answers
26 views
Query associated entries, dependent by time
lets assume I have two different database tables (tbl1, tbl2) and a third table which associates multiple entries from tbl2 to one entry on tbl1.
The entries of tbl1 and tbl2 are revisioned, which ...
