Diferencias entre SQL y MySQL - Prueba tus conocimientos con este quiz

Study Notes

Query Syntax

Similarities

Both MySQL and SQL Server use SQL (Structured Query Language) for querying and manipulating data
Both support standard SQL syntax for basic queries, such as SELECT, INSERT, UPDATE, and DELETE

Differences

Select Statement

MySQL:
- Supports LIMIT clause to limit the number of rows returned
- Uses AS keyword for aliasing columns
- Allows SELECT statements without FROM clause (e.g., SELECT NOW() or SELECT 1+1)
SQL Server:
- Uses TOP clause to limit the number of rows returned
- Uses = or AS keyword for aliasing columns
- Requires FROM clause in SELECT statements (e.g., SELECT GETDATE() or SELECT 1+1 FROM sys.databases)

Join Syntax

MySQL:
- Supports JOIN syntax with ON or USING clauses
- Allows joining multiple tables in a single query
SQL Server:
- Supports JOIN syntax with ON clause
- Requires explicit FROM clause for each joined table

Subqueries

MySQL:
- Supports subqueries in FROM and WHERE clauses
- Allows correlated subqueries
SQL Server:
- Supports subqueries in FROM and WHERE clauses
- Supports correlated subqueries, but with some limitations

Grouping and Aggregation

MySQL:
- Supports GROUP BY and HAVING clauses
- Allows grouping by multiple columns
SQL Server:
- Supports GROUP BY and HAVING clauses
- Requires explicit GROUP BY clause for each column

String and Date Functions

MySQL:
- Supports CONCAT function for string concatenation
- Supports DATE_FORMAT function for date formatting
SQL Server:
- Supports CONCAT function (introduced in SQL Server 2012) or + operator for string concatenation
- Supports FORMAT function for date formatting

These differences highlight the distinct syntax and features of MySQL and SQL Server, emphasizing the importance of understanding the specific query syntax for each database management system.

Sintaxis de Consultas

Similitudes

Ambas MySQL y SQL Server utilizan SQL (Lenguaje de Consultas Estructurado) para consultar y manipular datos
Ambas admiten la sintaxis SQL estándar para consultas básicas, como SELECT, INSERT, UPDATE y DELETE

Diferencias

Declaración SELECT

MySQL:
- Admite la cláusula LIMIT para limitar el número de filas devueltas
- Usa la palabra clave AS para aliasing columnas
- Permite instrucciones SELECT sin cláusula FROM (por ejemplo, SELECT NOW() o SELECT 1+1)
SQL Server:
- Usa la cláusula TOP para limitar el número de filas devueltas
- Usa la palabra clave = o AS para aliasing columnas
- Requiere la cláusula FROM en instrucciones SELECT (por ejemplo, SELECT GETDATE() o SELECT 1+1 FROM sys.databases)

Sintaxis de Join

MySQL:
- Admite la sintaxis de JOIN con cláusulas ON o USING
- Permite unir varias tablas en una sola consulta
SQL Server:
- Admite la sintaxis de JOIN con cláusula ON
- Requiere cláusula FROM explícita para cada tabla unida

Subconsultas

MySQL:
- Admite subconsultas en cláusulas FROM y WHERE
- Permite subconsultas correlacionadas
SQL Server:
- Admite subconsultas en cláusulas FROM y WHERE
- Admite subconsultas correlacionadas, pero con algunas limitaciones

Agrupación y Agregación

MySQL:
- Admite cláusulas GROUP BY y HAVING
- Permite agrupar por varias columnas
SQL Server:
- Admite cláusulas GROUP BY y HAVING
- Requiere cláusula GROUP BY explícita para cada columna

Funciones de Cadenas y Fechas

MySQL:
- Admite función CONCAT para concatenar cadenas
- Admite función DATE_FORMAT para formatear fechas
SQL Server:
- Admite función CONCAT (introducida en SQL Server 2012) o operador + para concatenar cadenas
- Admite función FORMAT para formatear fechas