|Tag: sql

SQL UPDATE Statement

The SQL UPDATE statement modifies the data of one or more records in a table.  It has the following syntax: UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]; Parameters: UPDATE table_name  - The name of the table to update.SET column_name  -  Indicates which columns to modify and the values they should be

2019-08-08T23:55:58+03:00By |Categories: C#|Tags: |0 Comments

SQL SELECT Statement

What is SQL SELECT statement? The SQL SELECT statement is used to fetch data from a database table which returns the data in the form of a result table. These result tables are called result sets. Basic syntax SELECT column1, column2, column3 FROM table_name; The query contains two keywords - SELECT and FROM. The SELECT

2019-07-09T22:16:28+03:00By |Categories: Explained Simply|Tags: |0 Comments

SQL INSERT Statement

The SQL INSERT INTO statement is used to add new records to a database. INSERT INTO table_name (column_name [, column_name...]) VALUES (value [, value…]); Parameters: INSERT INTO table_name  - The name of the table where a new row will be inserted.column_name  -  Indicates the column names where the data will be added. VALUES value – Specifies

2019-07-16T05:08:03+03:00By |Categories: Explained Simply|Tags: |0 Comments