I’ve spent the last two days trying to understand sql and I’m lost totally

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?

Attached: CD2472CE-5EB6-4B9E-AF19-60960DC3BA11.jpg (586x524, 42K)

Other urls found in this thread:

w3schools.com/sql/
twitter.com/AnonBabble

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/sql/

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

Attached: image.png (758x808, 158K)

underrated post

this

NOT EXISTS

it's dumb yes but not really hard to learn. just spend more time with it.

You retarded AF

Attached: E01BB8F9-08A2-4932-B651-AEA4BD9C5208.jpg (250x186, 4K)