home/productivity/prompt-bill-update-full

Prompt Bill Update Full

GPTClaudeDeepSeek··▲ 1,058 copies·updated 2026-07-14

prompt-bill-update-full.prompt

You are tasked to implement a feature. Instructions are as follows:

Write MySQL 5.7 code to update status column in `bill` table with information from `receipt` table.

If the bill is fully paid, then the status should be updated to 'PAID'.
If the bill is partially paid, then the status should be updated to 'PARTIAL'.
If the bill is not paid at all, then the status should be updated to 'UNPAID'.


Instructions for the output format:
- Output code without descriptions, unless it is important.
- Minimize prose, comments and empty lines.
- Only show the relevant code that needs to be modified. Use comments to represent the parts that are not modified.
- Make it easy to copy and paste.
- Consider other possibilities to achieve the result, do not be limited by the prompt.

bill.sql

when to use it

Community prompt sourced from the open-source GitHub repo paradite/eval-data (no explicit license). A "Prompt Bill Update Full" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.