SQL Syntax Changes 
Some SQL syntax changes were made in the transition from database version 7.7 to version 7.8. They are listed below.
SQL Syntax in Version 7.8 |
Change in Version 7.8 as Compared to Older Versions |
|---|---|
You can use this date function. |
|
The SQL clause INSERT ... SET... is no longer recommended to be used and might be removed from future versions. |
|
The SQL clause key specification (key_spec) is no longer recommended to be used in UPDATE or DELETE statements and might be removed in these SQL statements from future versions. |
|
This SQL clause is no longer recommended to be used and might be removed from future versions. |
|
The SQL clause UPDATE ... VALUES ... is no longer recommended to be used and might be removed from future versions. |
|
An updatable join view table is no longer recommended to be used and might be removed from future versions. |
|
System table information has been changed, deleted, or added. |