3 ms·
further, afaik there's no assignment nor iteration in SQL. it's not a programming language at all. It's a.. query language.
by chasd00 7y ago
further, afaik there's no assignment nor iteration in SQL. it's not a programming language at all. It's a.. query language.
- yellowapple 7y agoI'd consider INSERTs and UPDATEs to technically be "assignment", even if they're very different from how other languages do it. Some SQL dialects do support both traditional variable assignment and iteration for those cases where an iterative/imperative approach makes more sense than trying to shoehorn the problem into something set-based / declarative. Some limit them to stored procedures (e.g. Postgres, and AFAICT Db2), while others allow them pretty much anywhere (e.g. SQL Server / T-SQL).
- SAI_Peregrinus 7y agoI tend to lump it in as a "logic programming" language, along with Prolog and Datalog.
- taffer 7y ago> further, afaik there's no assignment nor iteration in SQL That was until CTEs were introduced in SQL:1999 > it's not a programming language at all. It's a.. query language. The two are not mutually exclusive. SQL is used to tell a computer what to do, and it is very powerful at it: https://www.youtube.com/watch?v=wTPGW1PNy_Y https://www.youtube.com/watch?v=wTPGW1PNy_Y