phpstormjetbrains-idedatagrip

How to save my formatting of MySQL stored procedure?


I work with MySQL stored procedures in PhpStorm 2023.2 and I edit procedure in console editor I use formatting

enter image description here

But after I saved stored procedure or used Alt + R for automatic formatting of the code I have different formatting:

enter image description here

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 :

enter image description here

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 )

?

Solution

  • 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