[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