Differences

This shows you the differences between two versions of the page.

mysql-to-db2 [February 14, 2013 8:49 am]
sqlines
mysql-to-db2 [February 14, 2013 8:53 am] (current)
sqlines
Line 33: Line 33:
| | **MySQL** || **DB2** | | | **MySQL** || **DB2** |
| 1 | [[/mysql-to-db2/date_format|DATE_FORMAT(date, format)]] | Convert date to string | [[/mysql-to-db2/date_format|VARCHAR_FORMAT(date, format)]] {{:exclamation.png|}} | | 1 | [[/mysql-to-db2/date_format|DATE_FORMAT(date, format)]] | Convert date to string | [[/mysql-to-db2/date_format|VARCHAR_FORMAT(date, format)]] {{:exclamation.png|}} |
 +
 +===== SELECT Statement =====
 +
 +Converting SQL SELECT statement:
 +
 +| | **MySQL** | **DB2** |
 +| 1 | SELECT without FROM clause | FROM //sysibm.sysdummy1// is added |