JavaOne 2010 Related Links

Here are some information that I found on the net about JavaOne 2010. Feel free to comment with additional resources. To start, Oracle posted some video highlights. If you have JavaOne login, you can view the full versions at On Demand site. If not, you can still see some of the contents here. Beyond that, […]

Read more "JavaOne 2010 Related Links"

MySQL to Postgres migration links

I just started looking into MySQL to Postgres migration. One of the differences between the two is LAST_INSERT_ID() for MySQL and CURRVAL(‘serial_variable’) for Postgres. Although there were many pages with examples about these, I found this page useful at explaining how to use the function. This page appears to be a good resource that lists […]

Read more "MySQL to Postgres migration links"


Today, I found a need to show all rows in a table and add associated information from another table. After reading a SQL reference manual on LEFT JOIN, I gave it a try and it met my needs. Here is the general format: SELECT field1, field2 FROM table1 LEFT JOIN table2 ON condition1 WHERE condition2 […]

Read more "SQL: LEFT JOIN tables"