[mythtv] State of play Re. DB support (MySQL versions, Postgresql etc.)
Ed W
lists at wildgooses.com
Mon May 8 16:25:14 UTC 2006
Hi
>Or is this preferred?
>INSERT INTO mytable(column,othercolumn) VALUES(value,value);
>
>
This is the syntax I have seen most commonly on other databases. I was
under the impression this was the correct "SQL" standard?
Mysql also has the very useful "UPDATE INTO" which does a replace -
often a very fast and handy function
>LAST_INSERT_ID()/MSqlQuery::lastInsertId()
>Is the above OK to use? I've seen various workarounds in code to get the
>ID back out, but not sure if this is just older techniques or not.
>
>
This is always a bug bear.... I don't know of any reasonably generic
way to do it short of using cursors and re-reading the data....
Looks very interesting!
Ed W
More information about the mythtv-dev
mailing list