Today, I would like to show you some improvements done in SQL code completion area (thanks to our colleagues from database team!).
As you probably know, there is already SQL code completion in PHP editor available - but only for SELECT statement. But this has changed recently, now you can enjoy this great feature for INSERT, UPDATE and DELETE statements as well (please note that code completion works for other SQL keywords as well, but not for the first statement in the string - you have to type INSERT/UPDATE/DELETE yourself).
Let's have a look at some screenshots, first for INSERT statement:
Code completion for UPDATE statement works very similarly:
Last, but not leaset, the DELETE statement: