Founder Of Geekstrick. Full-Time Software Developer, Expertise in Frontend Development. Conversant with - Angular, React, NodeJS, and MongoDB, MySQL, Postgres,HTML+CSS+JS, CypressIO.

SQL Update

geekstrick on May 28, 2021 🔥 617 views

SQL Null Values

geekstrick on May 28, 2021 🔥 534 views

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 […]


SQL Insert Into

geekstrick on May 26, 2021 🔥 730 views

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, […]


SQL Auto Increment

geekstrick on May 26, 2021 🔥 822 views

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 […]


SQL Order By

geekstrick on May 25, 2021 🔥 578 views

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, […]


Easily Translate Angular 12 App Using ngx-translate

geekstrick on May 24, 2021 🔥 113148 views

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. […]


SQL And, Or & Not

geekstrick on May 23, 2021 🔥 610 views

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 […]


SQL Where Clause

geekstrick on May 22, 2021 🔥 728 views

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 […]


SQL Data Types

geekstrick on May 22, 2021 🔥 610 views

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 […]


SQL Select Distinct

geekstrick on May 21, 2021 🔥 856 views

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 […]