+ 1
Does SQL require a different language to work with it?
I'm about half way through the SQL course I haven't seen anything about creating tables or databases or anything of the sort. Also I don't see the option to use it in the code playground.
4 Respostas
+ 12
It needs a database management system to work with. Most of the DBMSs are of client-server nature, so you'd need at least a virtual SQL server for those. Some, like SQLite or MsAccess are available as standalone, "offline" SQL implementations.
SQL syntax can be implemented in most programming languages by importing adequate libraries. Take a look at Python implementation of sqlite3:
https://code.sololearn.com/csyhsIovmZJ3/?ref=app
https://code.sololearn.com/c9mosXavqJ9W/?ref=app
+ 4
sql is a language itself... you can use it alone (i. e. via shell) or through other languages (i. e. php). sql alone can create database, tables and everything else, but it's easier to use a web front-end to achieve the same result, such as phpmyadmin...
0
Creating Tables is in the 3rd section - 6th lesson, I also noticed this thing but the course is this and we can't change the order
0
pdo or mysqli