MySQLCode https://mysqlcode.com MySQL Tutorials and Examples Fri, 31 May 2024 09:56:24 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://mysqlcode.com/wp-content/uploads/2021/02/mysql-fav.png MySQLCode https://mysqlcode.com 32 32 Autocommit, Commit, and Rollback in MySQL https://mysqlcode.com/autocommit-commit-and-rollback-in-mysql/ Fri, 31 May 2024 09:39:59 +0000 https://mysqlcode.com/?p=12262 How to Extract the Year from a Datetime Column in MySQL https://mysqlcode.com/extract-year-from-datetime-column-in-mysql/ Thu, 30 May 2024 05:35:54 +0000 https://mysqlcode.com/?p=12272 Creating Pivot Tables in PostgreSQL Using the crosstab() Function https://mysqlcode.com/creating-pivot-tables-in-postgresql-using-crosstab-function/ Thu, 30 May 2024 05:27:50 +0000 https://mysqlcode.com/?p=12104 Hierarchical Data and How to Query It in SQL https://mysqlcode.com/hierarchical-data-and-how-to-query-it-in-sql/ Tue, 30 Apr 2024 07:46:12 +0000 https://mysqlcode.com/?p=12140 PostgreSQL Standard View vs Materialized View (with Syntax and Example) https://mysqlcode.com/postgresql-standard-view-vs-materialized-view/ Tue, 30 Apr 2024 06:46:24 +0000 https://mysqlcode.com/?p=11881 Why Use ‘WHERE 1=1’ in SQL Queries? https://mysqlcode.com/why-use-where-1-1-in-sql-queries/ Mon, 29 Apr 2024 13:08:11 +0000 https://mysqlcode.com/?p=11968 How to Include Zero in a COUNT() Aggregate https://mysqlcode.com/include-zero-in-count-aggregate/ Mon, 29 Apr 2024 12:57:45 +0000 https://mysqlcode.com/?p=11943 Matching Nulls by Masking Nulls: A Detailed Guide https://mysqlcode.com/matching-nulls-by-masking-nulls/ Mon, 29 Apr 2024 10:05:47 +0000 https://mysqlcode.com/?p=11903 Difference Between Simple and Complex View in SQL https://mysqlcode.com/difference-between-simple-and-complex-view-in-sql/ Mon, 29 Apr 2024 09:47:51 +0000 https://mysqlcode.com/?p=11932 SQL Auto Increment (With Examples) https://mysqlcode.com/sql-auto-increment/ Mon, 29 Apr 2024 04:16:42 +0000 https://mysqlcode.com/?p=11934