Tag: database

  • How to Create a MariaDB Connect in PHP for WordPress

    How to Create a MariaDB Connect in PHP for WordPress

    In this blog post, we will explore the process of creating a MariaDB connect in PHP for your WordPress website. Connecting to a MariaDB database is essential for many WordPress applications, and PHP provides robust functionalities to establish a connection. Let’s dive in!

  • MSSQL datediff in seconds

    The following command on a Microsoft SQL Server calculates the difference in seconds between two datetimes: Example query: Result: If you need the result as a text and also want to add 3 digits after the seconds you can use the following example: Result:

  • Oracle top 1 record

    To select the top 1 records from an oracle database, you filter with the where statement on rownum = 1: If you want to select top 10 records from the table you use the following statement: