I work with MySQL stored procedures in PhpStorm 2023.2 and I edit procedure in console editor I use formatting
But after I saved stored procedure or used Alt + R for automatic formatting of the code I have different formatting:
If there is a way to leave my formatting for both cases I show on the first screenshot?
PARAMETERS CHANGED :
I found and set parameters at :
It helped me with second issue, when line :
select count(*) into out_retCount from users
is in 1 line afetr.
But first issue is still with broken style in procedure defintion :
create
procedure sp_getObjectsCount(
IN in_objectType varchar(100),
OUT out_retCount bigint unsigned,
OUT out_totalCount bigint unsigned )
?
You can change routine argument alignment behavior either via
Settings | Editor | Code Style | SQL | MySQL, MariaDB - Code - Routine arguments
or
Code Style | SQL | MySQL, MariaDB - Wrapping - Keep when reformatting