August, 2024 Baeldung on SQL

Learn the difference between GROUP BY and DISTINCT in SQL. >>>

Learn how to store decimal values in SQL. >>>

Learn how to retrieve a table’s primary key with SQL queries in MySQL, PostgreSQL, and SQL Server. >>>

An introduction to trimming strings in MySQL, PostgreSQL, and SQL Server. >>>

Learn which DDL and DML statements require an explicit COMMIT in MySQL. >>>

Learn about the differences between DATETIME2 and DATETIME in SQL Server. >>>

Explore two ways of storing images in a MySQL database. >>>

Learn about the autocommit mode and how it affects commits and transactions in MySQL. >>>

Explore various methods of retrieving table sizes in PostgreSQL, MySQL, and SQL Server. >>>

Learn to modify the data type of a column of an existing table in an SQL database. >>>

Monthly Archives: August 2024