From the course: Learning MySQL Development

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

SQL, a declarative language

SQL, a declarative language - MySQL Tutorial

From the course: Learning MySQL Development

SQL, a declarative language

- [Instructor] As you might guess from the name, MySQL uses SQL, or structured query language, as the means of programmatically interacting with its databases. SQL is a declarative language, one common among relational DBMSs, but very different from procedural or object oriented languages common when working with data outside a database. In a procedural language, a program is executed step by step, and the program flow explicitly lays out each step that the programmer wants performed. A declarative language leaves the exact control flow up to the computer. A programmer just states the logic of what they want the end result to look like. In database terms, a procedural program might run a loop wherein it checks the first row of data in a table for certain contents, and then displays those contents if they match the criteria or rejecting them if they don't. Then it would loop to the next row. SQL leaves all those…

Contents