MySQLi is gettng a feature to bind arrays to
execute($array) method in single call. This would apply to standard
int index based arrays and associative arrays.
New function was added to retrieve first or any other column from the result set to
MySQLi object. This follows the
fetchColumn() method from PDO and behaves in the same manner.
The default error mode for
mysqli calls is now changed from silent mode to Exception mode. This doesn’t affect
PDO object since PHP Data Object is already throwing Exception by default.
So you want to learn a SQL language and you are indeed a human? Don’t look further, this read will provide you some decent amount of the basic and those more advanced knowledge of SQL programming in no time. However be prepare for some long ass reading with this 4th edition of over nearly one thousand pages IT book.