Jump to content

Recommended Posts

Posted (edited)

"SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. ... SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s."

SQL is not a general purpose programming language. You must have code that opens the database, creates a table, inserts records, queries records, deletes records, modifies records, and closes it.

MySQL is typically used from server-side PHP, Java, Python etc. or client-side JavaScript.

SQLite is typically used from Android's Java/Kotlin/Xamarin.

It is possible to make changes to the SQL database from the db admin panel by manually typing your own SQL commands.

e.g. mysqladmin for MySQL:

https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html

Any serious web-hosting company installs such a SQL admin panel, accessible from the HTTP server, to access the database in emergency situations. It is usually used for database backups.

Edited by Sensei

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.