Greetings everyone.
How superior is SQL server compared to MySQL in terms of querying?
Is there a huge difference? How applicable and relevant is MySQL in the world in terms of Data Science, BI, Machine Learning etc.
Regards,
Salim
1 Like
Hey, here are a few differences between SQL and My SQL -
SQL is a structured query language used for managing and retrieving data from the database system.
MySQL is a Relational database system that uses SQL to query data from the databases.
SQL is proprietary based software owned by Microsoft and not open to others for free.
MySQL is an open-source free platform that allows access to any and everyone.
SQL was built for WIndows, works partially for Linux, macOS with its latest versions.
MySQL is adaptable for cross-platforms, working well for Linux, macOS, Windows.
2 Likes
TLDR; SQL sucks, don’t use it.
MySql is good. Use this.
Hi,
SQL DOES NOT belong to Microsoft. Microsoft is behind SQL Server. This is different.
SQL is a standard implemented by different vendors in which Oracle made MySQL (actually Oracle has Oracle DB and bought MySQL later on).
Though they try to be as close as possible to the standard, in practice they all differ in different manners. Even between MariaDB which is a fork of MySQL made after we got to know Oracle buys MySQL. The syntax to deal with account creation differs a bit as far as I remember. In a larger view, there is no statement such as DESCRIBE I know of with Transact-SQL (SQL SERVER). We have to query system tables instead.
Each of the implementations I mentioned here are used in professional software.
Add to this PostgreSQL which is present in pro projects too.
1 Like