Ms sql vs my sql

Question

Ms sql and my sql both use transact sql language, what's the biggest difference between them？

Answer 1

MySQL using Transact-SQL? I didn't know that. Transact-SQL is an SQL dialect that origins from Sybase, and also used my Microsoft SQL Server, since SQL Server originates from Sybase. MySQL has a completely different background, and I would expect that there are plenty of differences between the two.

For instance, I believe semicolons to terminate statements is mandatory in MySQL, but this is not the case in MySQL. MySQL seems favour backticks to quote identifiers whereas SQL Server prefers brackets. And so on.

Answer 2

AFAIK, MySQL doesn't name it's implementation of the SQL Language. SQL Servers uses Transact-SQL or T-SQL.

My SQL has different syntax elements than SQL Server. Their DDL: https://dev.mysql.com/doc/refman/8.2/en/sql-data-definition-statements.html and DML: https://dev.mysql.com/doc/refman/8.2/en/sql-data-manipulation-statements.html

There are different functions, like for length, LEN (T-SQL) and CHARACTER_LENGTH (MySQL), and as Erland noted, semicolons are needed. T-SQL uses GO (configurable) as a batch delimeter in most tools whereas MySQL just uses the semicolon

Answer 3

Besides details of function names, and control flow statement names, the big difference is sql server allows flow control statements in a sql batch while MySQL only allows in a stored procedure function definition.