Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

That's DML, not DQL. Still, I disagree with GP's arguments (see separate comment).


> That's DML, not DQL.

Thanks. I incorrectly assumed there were only two sublanguages. But now when you say it, I've heard both DML and DDL before, but never DQL. Curious if there were even more categories, I found this Wikipedia article:

https://en.wikipedia.org/wiki/Data_query_language

Interesting to read, what a SELECT statement is, depends on if having FROM or WHERE "data manipulators". Quote from Wikipedia:

"Although often considered part of DML, the SQL SELECT statement is strictly speaking an example of DQL. When adding FROM or WHERE data manipulators to the SELECT statement the statement is then considered part of the DML."




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: