SQL Lecture 1

A few Commands that I learned.

1. create database nxm301

2. drop database nxm301

3. queries are case-insensitive

while creating a table, we have to create a schema

Insert a value in a table

Reading data from the database Command

selecting specific data

Creating a table SQL using constraints, primary key

If you don't want to add id from your end, you can use auto_increment

Inserting multiple values into a table at once

FILTERING

Filter those customers whose name is "Nrupul" in SQL

filter - want see those rows where first 2 letter are nr

• 

  update

• how to update in SQL table

delete in sql table

deleting and updating anything other than primary key is not allowed

SORTING

file name in vs code --> data.sql