Questions tagged [sql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
328 views

pset7 buy - ON DUPLICATE KEY syntax question

I'm on pset7 buy, and I just need some explanation on how the ON DUPLICATE KEY syntax is supposed to look (at least I assume that's the issue). Btw, id and symbol are both unique keys in my portfolio ...
  • 147
1 vote
2 answers
4k views

Final project SQL Error: execute() takes 2 positional arguments but 3 were given

EDITED I am working on a conversion table website as my final project. I am using a base unit multiplier to convert one unit to the other. So for example centimeter to yard would look like this. ...
0 votes
1 answer
167 views

pset7 finance register sql

I've been working on the register part of the finance problem and I think I have most of it but I really don't understand how to do the SQL parts of it. I need to learn how to store the username and ...
0 votes
1 answer
35 views

Can a select return nothing without causing an error? How do I create a if condition that returns True if the database is empty?

I posted my code in another post I have made a lot of revisions. Kind of irrelevant but just thought I should mention it if someone goes through my last post. I have a select statement. Lets say my ...