#-- Написать запрос, в который вместо %p1..%p5 можно подставить значения параметров или null #-- если параметр null, то у возвращенных записей этот параметр может быть любым #-- SELECT * FROM docs WHERE p1=%p1 and p2=%p2 and p3=%p3 and p4=%p4 and p5=%p5 -- p1 SET @p1 = 3; -- p2 SET @p2 = 3; -- p3 SET @p3 = 2; -- p4 SET @p4 = 1; -- p5 SET @p5 = 9; SELECT *FROM docs WHERE p1 = @p1 and p2 = @p2 and p3 = @p3 and p4 = @p4 and p5 = @p5 or (@p1 and @p2 and @p3 and @p4 and @p5) IS NULL;
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question
