Creating a Database is the first step, where all the specific information is stored, so it is necessary to know how to create a database in MongoDB. This beginner-level tutorial shows you how to create a database in MongoDB using two methods. As a database developer, you will usually use both the command line and … Read more >>
In this MongoDB tutorial, we will discuss and learn more about how to sort by date in MongoDB and how we can sort by date differently. MongoDB sort by date A few days back, I was working on a blog page and recognized that the post was from old to the new order, which is not … Read more >>
MongoDB has no CREATE TABLE statement, and you don’t need one. To create table in MongoDB, you create a collection: run db.createCollection(“customers”), or insert the first document and MongoDB makes the collection for you. Either line gives you a customers collection. Tested on MongoDB 9.0.4 and mongosh 2.14 on Windows; every output below is from … Read more >>
In this MariaDB tutorial, we will understand how to rename a table in MariaDB and look at several examples. MariaDB Rename Table Here, we’ll learn how to use the MariaDB rename table in this part, which is explained using syntax and examples. The ALTER TABLE statement in MariaDB is used to change, drop, or delete … Read more >>
In this MariaDB tutorial, we will look at how to use the MariaDB Not Equal operator and glance at several examples. There are lists of the topic that comes under discussion: MariaDB Not Equal MariaDB Not Equal Null MariaDB Not Equal Json Field MariaDB Not Equal Like MariaDB Not Equal Like Regex MariaDB Not Equal Primary … Read more >>
In this article, I will walk you through exactly how to drop every type of constraint in MariaDB—Primary Keys, Foreign Keys, Unique, Check, and Default constraints. I’ll share the exact syntax, common pitfalls I’ve stepped into so you don’t have to, and the best practices to follow. How to Drop Constraint in MariaDB Understanding Constraints … Read more >>
In this MariaDB tutorial, we will examine how to utilize the MariaDB Date_Format Function and several examples of its usage. MariaDB Date_format In this part, we’ll learn about the date_format function, which is described using syntax and an example. The date_format function in MariaDB formats the date according to a format filter. The date_format function in MariaDB has the … Read more >>
Say your support team looks up orders by state all day, in a table of 5,004 orders. A MariaDB index fixes it: CREATE INDEX ix_state ON orders (state); cut that lookup from a full scan to 2 rows read. Below: single, composite, unique and JSON indexes, EXPLAIN checks, renames, drops and the foreign key error … Read more >>
In this article, you will know about the error “Msg 11555 NOT NULL parameters are only supported with natively compiled modules, except for inline table-valued functions.” Also, we will discuss why this error arises and what things to do to resolve this error. Problem Recently, I was working with the SQL Server Stored Procedure Parameters. … Read more >>
This tutorial is about the try-catch in SQL Server stored procedure with examples. We will discuss some of the examples that will help you understand exception handling more deeply. Also, in the end, we will discuss the best practices of exception handling in stored procedures in SQL Server. You can also learn more about exception … Read more >>