I’ve spent the last two days trying to understand sql and I’m lost totally
Am I retarded or is it just a stupid language?
I’ve spent the last two days trying to understand sql and I’m lost totally
Am I retarded or is it just a stupid language?
Other urls found in this thread:
You are retarded
What is it you don't understand?
you are retarded
definitely retarded, it is simple as fuck.
sorry buddy.
Both
Yes
sql is a table end of story
Stop looking at SQL as an imperative language and start looking at it as a declarative language. You aren't telling the database what to do, you are telling it what you want. Figure out the structure and shape of what you want to get out of the system and then write a query that will produce that result. Maybe this will help.
I’m using sqlite with ruby and the return value are retarded like I’ll get a nested array for some fucking reason when I just want a single value
>ruby
Try using .NET with Dapper & SQLite. It is pretty much the best thing you can experience on a computer.
>var someUser = new SqliteConnection(blah).QueryFirst("select * from users");
>ezpz
Well that is probably because it -can- return multiple results, and with various "columns". If you are doing a simple SELECT with a condition, for example.
If you only want the first result then manipulate the array in ruby. Access the think you want like you would with any array or dictionary (don't know ruby but it can't be that different from python)
the thing** you want
sql is super easy unironically, but don't give up brother, it takes time and you will understand it
It's basically fucking English. You're retarded.
who said the syntax makes it bad?
start somewhere simple
SELECT `name`
FROM `players`
WHERE `level` = 12345
ORDER BY `name`
LIMIT 1
try to focus on just the sql and no other language
w3schools.com
fpbp
SELECT user
FROM thread
WHERE user
LIKE "retard" AND "faggot"
give it a rest for a few days, then try again with a fresh state of mind
Are you my coworkers by chance? Not knowing what keys are and why they keep getting Cartesian products all the time with millions upon millions of rows
dude sql is trivial lmao
underrated post
this
NOT EXISTS
it's dumb yes but not really hard to learn. just spend more time with it.
You retarded AF