SQL playground

Question

Can we use SQL code coach playground as SQL code playground to write and execute SQL queries?
If yes, then the database or table created by that query will be stored permanent or temporary (as in python codes)?

Answer 1

Yes, you can write and test your code at SoloLearn SQL Try-It-Yourself Playground. You can create and drop new databases and tables, store and select data from new and initial (which are generated automatically) tables and databases. But you cannot execute first-learned here queries like "show databases" and "show tables" and backup databases (even temporary; produces syntax error). You can see examples of what you can do in this code (do not watch at the language, just copy-paste it): https://code.sololearn.com/cagb8UrvNfdl/?ref=app.

As with other SoloLearn playgrounds, the server cleans up all of what your code does after returning output, so you can imitate permanent affect of your code with third-party servers only.