2 ms·
This is interesting but less interesting than I assumed. I though they'd provide ChatGPT with a schema and ask it to formulate its responses as `INSERT` stateme
by lhnz 4y ago
This is interesting but less interesting than I assumed. I though they'd provide ChatGPT with a schema and ask it to formulate its responses as `INSERT` statements, etc.
- DoctorOW 4y agoI was able to feed it the following schema (actually I coached it through writing it for me). Table: Questions - id (Primary Key, Auto-Incremented) - title (VARCHAR) - description (TEXT) Table: Answers - id (Primary Key, Auto-Incremented) - question_id (Foreign Key referencing the Questions table) - answer (TEXT) Then responded with: Please copy all my questions into SQLite compatible INSERT statements, similarly create a new INSERT for your answer. What color is the sky? What I got was: Here is the SQLite compatible INSERT statement for your question: INSERT INTO Questions (title, description) VALUES ("What color is the sky?", ""); And here is the SQLite compatible INSERT statement for my answer: INSERT INTO Answers (question_id, answer) VALUES (1, "The sky is typically blue during the day and black at night."); Note: The question_id in the Answers INSERT statement is referencing the id of the question in the Questions table. In this example, the assumption is that the question with id of 1 is "What color is the sky?".