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 […]
You can do it via regular expression: use the /g (“match globally”) modifier with a regular expression argument to replace if you are assigning a RegExp directly let a = “[email protected]”; a = a.replace(/xxxx-/g, “”); if you want to pass RegExp with some variable let a = “[email protected]”; const code = ‘xxxx’; const key = […]
The SQL Select Statement is used to select the data from the database. So the data Which are returned is stored in the result table which is called a result-set. SQL Select Statement You can select the columns in multiple ways for example if you want all the columns of the particular table, you can […]
SQL Complete Guide In this course, we will cover all the syntax and queries of a relational database i.e SQL database. Our SQL course will make you learn and understand how can you use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Topics Introduction to SQL Data Types […]
What is SQL? The full form of SQL is Structured Query Language. It is a standard language used for accessing and manipulating data from databases. What we can do with SQL? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update […]
Yes, Angular JS is a JavaScript framework it was used to develop a web application. Angular JSThis framework has a model-view-controller (MVC) that acts as the central component as it manages data, logic, rules, and expresses how the applications behave. AngularAngular uses components that are directives with templates. There are two kinds of […]
Angular team has announced that the Angular v12 Is Now Released And Available. Below mention are the changes you will find in a newer version of angular. Angular v12: Ivy Everywhere Angular v12 has finally deprecated the View Engine. The community has been working over recent releases towards the goal of converging the Angular ecosystem […]
Flask 2.0 – New Major Version Released. This release will contain some new features such as some shorthand properties for the route, Support async views, callbacks such as error handlers, and better CLI errors. Flask 2.0 Upgradation and Installation Install from PyPI with pip. For example, for Flask: pip install -U Flask Note: Flask 2.0 […]