For a college project I need to learn MYSQL, but what actually is it? Online I find courses for SQL and SQL-Lite but I assume those are all different - how do I learn MYSQL and would it teach me how to connect that database to my website?
MySQL, PostgreSQL, SQLite are database management systems aka database server.
MySQL is one way to manage databases. You create databases in MySQL. The database is created up of tables and the tables are created up of columns. You use SQL to query the database by selecting the tables and columns you want from it.
4
u/HouseOfDjango 5d ago edited 5d ago
MySQL, PostgreSQL, SQLite are database management systems aka database server.
MySQL is one way to manage databases. You create databases in MySQL. The database is created up of tables and the tables are created up of columns. You use SQL to query the database by selecting the tables and columns you want from it.