Code Inspections in MySQL
This topic lists all PhpStorm code inspections available in MySQL.
You can toggle specific inspections or change their severity level on the Editor | Inspections page of the IDE settings Ctrl+Alt+S.
Reports paths that start with the tilde character in LOAD statements.
CREATE TABLE table_name (id int); LOAD DATA LOCAL INFILE '~/Documents/some_file.txt' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES;
Instead of the tilde character, use a full path to the file.
Reports invalid usages of UNION in queries.
The inspection works in MySQL versions that are earlier than 8.0.
SELECT * FROM (SELECT 1 UNION (SELECT 1 UNION SELECT 2)) a;