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.

Result

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

Verification of calculation criteria: · Calculation·verification principles · Report errors