+ 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.

21st Aug 2017, 8:59 PM
Keegan Robertson
Keegan Robertson - avatar
4 odpowiedzi
+ 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
21st Aug 2017, 9:12 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 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...
21st Aug 2017, 9:10 PM
Luca
Luca - avatar
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
21st Aug 2017, 10:21 PM
Alessio Giliberti
0
pdo or mysqli
23rd Aug 2017, 8:00 AM
Sam Tezel
Sam Tezel - avatar