• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

I need to learn SQL in 3 days.

Chrono

Diamond Member
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
 
Yeah, I had that problem too. It's not possible, but FRICKIN GOOGLE has tons of references to quickly teach you what you need to know when you find out that you need to know it, when it comes to SQL.
 
SQL for dummies will help.

remember if you want to select something "select pussy from playboywomendatabase where pussy is red"

remember that statement and you learnt everything that is to learn.
 
Originally posted by: Chrono
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
Translated as:
"I've never used SQL, and I barely actually know what it is. Please help me as I am way over my head in a project I took on at work/school."

Have fun. 😉
 
Learning SQL is easy, the syntax is very simple and there aren't a lot of commands. Being able to use it for something, that's a whole different thing.
 
SQL is pretty damn easy. I learned by cutting my teeth on Oracle. Find a personal/academic version. Grab a book at the store. Learn these:

SELECT

INSERT
UPDATE
DELETE
MERGE

CREATE
ALTER
DROP
RENAME
TRUNCAT

COMMIT
ROLLBACK
SAVEPOINT

GRANT
REVOKE

BOOM I just taught you data retrieval, the data manipulation language (dml), data definition language (ddl), transaction control and data control language (dcl)

😀
 
Originally posted by: SampSon
Originally posted by: Chrono
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
Translated as:
"I've never used SQL, and I barely actually know what it is. Please help me as I am way over my head in a project I took on at work/school."

Have fun. 😉

Hahaha... best post of the day, bar none.
 
There are some keywords, and some tables. And indexes. And rollback stuff and logging. And ANSI-compliant something. Then there are the statements, with parentheses and special characters. There's some collating order thing that is important.

You get a lot of data, and put it in a straight line (or maybe it's called a row, I don't remember). Then you line up your keys and set them on the tables. You can't have a lot of keys, because it would jeopardize the access rights for security. They get joined together somehow.

Data goes in, and you take it back out, but it still stays there unless you change it, or not. Then you can print it but that part is hard, because you have to put brakes on the pages.

I think there's more to it than that, though.
 
Back
Top