SQL placeholder numbering
Number question-mark placeholders outside SQL strings and comments using PostgreSQL-style parameters.
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Instructions and example
Question marks in line comments and closed block comments remain literal. Unterminated quotes or block comments are errors.
Only the placeholders after price and stock become $1 and $2; the quoted '?' remains unchanged.
Supports single/double quotes and line/block comments. Backslashes, dollar quoting, brackets, backticks and nested comments are rejected.
Frequently asked questions
Are question marks inside comments numbered?
Question marks in line comments and closed block comments remain literal. Unterminated quotes or block comments are errors.
Are dollar quotes and nested comments supported?
Supports single/double quotes and line/block comments. Backslashes, dollar quoting, brackets, backticks and nested comments are rejected.
Calculation criteria and reference materials
- PostgreSQL — SQL Lexical Structure
Supports single/double quotes and line/block comments. Backslashes, dollar quoting, brackets, backticks and nested comments are rejected.
Verification of calculation criteria: · Calculation·verification principles · Report errors