Rehmaanali

The SQL NULL value means a field with no value present in it. What is a SQL NULL Value? If a field in a table is optional in other words if it’s not mandatory, it is possible to insert a new record or update a record without adding a value to this field. Then, the […]

The SQL INSERT INTO statement is used to insert new records in a table. SQL INSERT INTO Statement There are two possible ways to insert data into the table using The INSERT INTO statement. Syntax Specifying both the column names and the values to be inserted: INSERT INTO table_name (column_1, column_2, column_3) VALUES (value_1, value_2, […]

The SQL AUTO INCREMENT keyword allows a unique number to be generated automatically whenever a new record is inserted into a table. SQL AUTO INCREMENT Field This is often the primary key field that we would like to create automatically every time a new record is inserted. Syntax for MySQL The following SQL statement defines […]

The SQL ORDER BY keyword is used to sort the result-set in ascending or descending order. SQL ORDER BY Keyword The ORDER BY keyword is used to sorts the records by default it sorts in ascending order. To sort the records in descending order, use the DESC keyword. To sort the records in ascending order, […]

Code and Demo This tutorial will see how we can Easily Translate the Angular 12 App Using the library Angular 12 with ngx-translate The internationalization (i18n) library for Angular ngx-translate: It is an internationalization library for Angular. It will let you define translations for your content in different languages and you can switch languages easily. […]

The SQL AND, OR & NOT Operators can be combined with the WHERE clause and used. These operators are usually used if you have multiple conditions to be checked for filtering out the data. The SQL AND, OR and NOT Operators The AND and OR operators are used to filter records based on more than […]

The SQL WHERE Clause is used to filter out the records. This Query allows you to add a condition that will return a resultset with that matching condition. SQL WHERE Clause You can use the WHERE clause not only in SELECT statements but also you can use in UPDATE, DELETE, etc. Syntax SELECT column_1, column_2 […]

The SQL data types are divided into five categories and that five categories have multiple properties to define a value for a table field. SQL Data Types Character/String Data Types Numeric Data Types Date/Time Data Types Binary Data Types Miscellaneous Data Types Character/String Character/Strings are used to store strings like names, locations, etc., and even […]

The SQL Select Distinct Statement is also used to select the data from the database the difference here is it will return only distinct (different) values. SQL Select Distinct Statement Inside a database table, a column may contain duplicate values, and some time you want to list down the different (distinct) values. Example: The scenario […]