Alter Table (ADD and REMOVE Primary Key) | MYSQL Commands Class 12 Computer Science

Показать описание

Alter Table (ADD and REMOVE Primary Key) | MYSQL Commands Class 12 Computer Science | MYSQL Class 12

In this video, you will understand how to add and remove primary key using alter command in MYSQL.

Join this channel to get access to perks:

Click on this link to visit the online store to buy the customised products.

Functions in Python

Using Python Libraries:

Data Structures: Stack and Queue

File Handling:

Recursion

Idea of Algorithmic Efficiency

Interface Python with MYSQL:

MYSQL

Computer Networks:

Programming Corner:

Output Based Questions:

Boolean Algebra

Basics of Python

Flow of Control

String Manipulation

List Manipulation

Dictionaries

Python Modules

Sorting

Рекомендации по теме

Комментарии

one of the best teacher.very simple and easiest way of explanation acc to level of studdnts.

virusalert

finally completed SQL☺
thankyou so much mam
for quality content

divyanshxyz-dmrt

Very helpful video mam for this topic🥰👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

sanjanapuniya

Thanks a lot mam for this great grand explanation 🥰

naveenmittal

Mam 1 doubt to add a column(primary key)in table can we use Alter table the given below Synatax:
Alter table <table name>
Add column <columnname> <datatype><size> primary key;
Or only this this Syntax:
Alter table <table name>
Add Primary key(column name);

parveenparveen

mam you are so great 😍 😍 😍 😍 😍 😍 😍 😍

timeisnotenough

maam even after removing primary key why can't we add null values to rollno.

nidhilohia

At 11:00, why it do not allow null values in Name after removing primary key mam?

TunerXMusicu

ma'am can we use drop primary key instead of DROP PRIMARY KEY ?
please clear my doubt.

swetomajesty

Ma'am will you please make a detailed video on the current CBSE syllabus 2021-22 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

your.intelligence

Can we add other constraints using this command

RaviKumar-swdh

Mam what about foreign key alter and drop??

Mysticfalls

Mam I have one doubt..
After writing the desc demo1; command the type of rollno showed int(11)..
Mam I am confused that why after int the value 11 came within bracket.. In previous questions whenever we used to describe any SQL table we used to get only int printed in the type column of table.. Can you please help me out with this confusion ??

sudeshnasarkar

Mam, it is important to write rollno, name in next line

sam-yxyy

What is the query for update a field name ?

hit-aix

Didi today u have not taken live class

sardarji

Mam,
If a table can only have one Primary Key then how "" a primary key can consists of single or multiple columns (fields)"" 2:54

sabyasachidas

Mam pls upload Viva Questions for Class 12 Boards 🙏

yourdadaf

Maam why primary key not dropping I used correct syntax
it is showing : Can't DROP 'PRIMARY'; check that column/key exists

squarejock

Legends complete the playlist 30 minutes before the exam

shauryasinghparihar

Alter Table (ADD and REMOVE Primary Key) | MYSQL Commands Class 12 Computer Science

ALTER TABLE ADD AND REMOVE COLUMN ORACLE 10G SQL*PLUS

UPDATE, DELETE, ALTER - SQL Tutorial Series #2

ADD and DROP a Constraint using ALTER TABLE command in SQL || Lesson 42 || DBMS || Learning Monkey |

SQL: How to ADD and DROP PRIMARY KEY in SQL Server | Alter Table

How to DELETE COLUMN in table in SQL

SQL Tutorial - 55: The ALTER TABLE Command

MySQL Tutorial - 38 - ALTER TABLE - Add & Delete Columns

how to add, delete/drop column in MySql, SqlServer | change data type of a column | ALTER TABLE

Small Home 🏠! Pt 3: Life & Death Rags to Riches Legacy Challenge (Sims 4)

MS SQL tutorial on adding columns to existing tables. Alter table. Add Alter Drop column.

Alter Table (ADD and REMOVE Primary Key) | MYSQL Commands Class 12 Computer Science

SQL ALTER COMMAND | add, delete, modify and rename column/table in oracle

Add and Drop Constraint On an Existing Table | Oracle SQL Tutorial for beginners | Techie Creators

How To Alter Hive Tables : ALTER Statement

SQL in MS Access - Generate, Delete and Change Columns with ALTER TABLE

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

Oracle Tutorial - Add and Drop a Column using Alter Table Statement

How add and delete foreign key using alter table in Hindi - 45

MySQL: How to UPDATE and DELETE data from a TABLE

The SQL Alter Table Statement

SQL Tutorial - The ALTER TABLE Command || ALTER TABLE for Adding Constraint to Column

How to Alter Table using SQL in MS Access - Office 365

Learn SQL Commands - Create table, Insert into, Alter table, Delete table, Drop table

PostgreSQL 002 Add or remove primary key to a table