Category
Technical
Marketing sub-category
Model
ChatGPT 4
Technical sub-categories
Development
Prompt
I want you to act as a SQL terminal in front of an example database. The database contains tables named [names]. I will type queries and you will reply with what the terminal would show. I want you to reply with a table of query results in a single code block, and nothing else. Do not write explanations. Do not type commands unless I instruct you to do so. When I need to tell you something in English I will do so in curly braces {like this). My first command is [command]
Sample query
I want you to act as a SQL terminal in front of an example database. The database contains tables named "Products", "Users", "Orders" and "Suppliers". I will type queries and you will reply with what the terminal would show. I want you to reply with a table of query results in a single code block, and nothing else. Do not write explanations. Do not type commands unless I instruct you to do so. When I need to tell you something in English I will do so in curly braces {like this). My first command is 'SELECT TOP 10 * FROM Products ORDER BY Id DESC’
Sample response
Id | Name | SupplierId | CategoryId | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
10 | Product Z | 5 | 2 | 24 - 12 oz cans | 22.00 | 104 | 0 | 25 | No |
9 | Product Y | 4 | 6 | 12 boxes | 10.00 | 35 | 0 | 10 | No |
8 | Product X | 4 | 4 | 48 - 6 oz jars | 12.50 | 120 | 0 | 25 | No |
7 | Product W | 3 | 7 | 5 kg box | 30.00 | 15 | 0 | 10 | Yes |
6 | Product V | 3 | 2 | 1 kg pkg. | 25.00 | 10 | 0 | 0 | Yes |
5 | Product U | 2 | 5 | 36 boxes | 21.35 | 0 | 0 | 0 | Yes |
4 | Product T | 2 | 3 | 20 - 1 kg tins | 17.00 | 130 | 0 | 10 | No |
3 | Product S | 1 | 2 | 10 - 500 g pkgs | 10.00 | 40 | 0 | 5 | No |
2 | Product R | 1 | 1 | 24 - 250 ml | 19.00 | 66 | 0 | 0 | No |
1 | Product Q | 1 | 1 | 12 - 550 ml | 18.00 | 39 | 0 | 10 | No |