MySQL ALTER Tutorial in Hindi / Urdu
HTML-код
- Опубликовано: 16 дек 2019
- In this tutorial you will learn mysql alter command tutorial in Hindi, Urdu.You can learn how to modify database's tables with SQL Alter command. You will learn how to add column in existing table, rename column name, reposition column, change datatype of column, change auto increment value of column.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php
Your Knowledge and Experience clearly reflects in your video Lectures. Your videos are helping me a lot. Thanks and I hope you will try to solve my issues.
one of the best teacher on youtube.
Thanks :)
Hmm yrr pure youtube pr dekha yahi samajh aya thanks sir
Quality never be compromised - yahoo baba 👍
thankyou bhai for this course
Thanks sir pure youtube pr apse best sikhane wala nhi mila❤❤❤
You are great sir :)
Very Great Sir ,Sir Aap ne Dil Jit Liya
Thanks and welcome :)
❤❤❤❤ valuable contents
Thank you so much for this pretty Explanation.
You're very welcome!
It was really helpful i always wondered about how to re-arrange the auto-increment value when the data gets deleted but this video has helped a lot lot to me and really a very big thanks to you sir.
Your welcome :)
Sir, Agar hm alter command se ek new column add krte hai kisi table me then uss new column me data kis command se bhr skte hai .
Please reply Sir
You're my all time favourite 🥰
About to complete the whole playlist, it was awesome. Just had a question, how can we add values to the newly add column in a table. Please help.
Use UPDATE command or INSERT command.
Super Explained SIr
THANKYOU SIR
JAY HO YAHOO BABA THANKS TO YOU LOT MY BIG BRO JAY HIND
Your welcome :)
Sir ,
Please share real environment MYSQL database example. its very helpful for corporate environment .
thnkss baba
#Yahoobaba always good 🤗👌💝🙏
.
.
How are you sir? Thandi ky bolte apke yha ki😛
Thanks Vikas....... Thand toh kadake ki hai....😊
@@YahooBaba idhr bhi sir barish ho rhi hlki hkli🌧🌧 tc 😃
Kmalllll❤️
Amazing
So nice
while dropping the column you dont have to specify its datatypes
Sir, Char has limit of 0-255 characters which is enough for all columns you are using in your examples but why didn't you use that as any datatype. Sir, you always prefer varchar
Please specify, if some important reason, may be I am missing, please tell Sir 🙏
Pankaj some fields like name, address, city, qualification, designation, category, phone number has no more character then 255 so their is no need of other datatypes. If you give some big datatype to these fields then your database size is unnecessarily increased.
I can't run modify column query every first word is shown in red colour but modify is not may be that can be a problem??
Sir my result grid is in read only mode how do i make it editable like you did here 13:20
sir daa science ka all tools pada do power bi python all bhot help ho gai ga job bhi mil gi gi plz sir
Sir ham ne computer ko server banaliy lekin us server usi computer me run hotahe. me chataho kisi or computer me run hoo USB cabell dra. ky sir aisa hoo sakhtahy?
Jubraz USB cabel se toh pata nahi lekin aap computer networking se aisa kar sakte hain. Agar aap ke computer aapas mein connected hai through networking tab aap ek System ko Server bana ke doorse systems par access kar sakte ho Database ko.
Need WordPress theme customization tutorial plz boss
WordPress theme and plugin development videos will come after 4 months.
Sir how do we add multiple constraints using alter command
Sir WordPress ka tutorials ane me kitna time lgega
May be 4 months
Sir Aik question tha k ager hm existing table ma FORIEGN key add krna chahty ha ksi dosary table ki to ksy add kraine dy example courses wly table ki id FIREIGN key bnani student table ma. kindly syntax bta daine plz plz....
CREATE TABLE Orders (
OrderID int NOT NULL,
OrderNumber int NOT NULL,
PersonID int,
PRIMARY KEY (OrderID),
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);
PersonID is the foreign (Means it's the Primary key of Person_Table and here is used in this table as a foreign key).
Sir, but in the real world applications, if we have given S. No. as Auto Increment and continuously records being deleted by users, then how can we fix this problem. Is there any alternative for this, As I have applied this in one of my application and now getting the Issue of skipped counting on my display All page
Pankaj in real life we don't show the s.no column of database in any web application. In fact we use one variable and initialize its value with 1 and in loop we increment it with 1. for e.g. in PHP :
$a = 1;
forearch(){
echo $a;
$a++;
}
Dear sir please tell me. U use AS key for change header column name and u use in this video alter
Dear can you explain what you want to ask ?
Sir tell me deferance between AS operator and ALTER
How can i bring that new column 'email' on the place of column 'id' 6:06
Question ❓ Sir me jab table ki ander column ki data type check kar Raha apne jaise bataya magar pura bahar kar de Raha he matlab crash ho Raha he kya kare? Give me a solution
SIR EXCEL, TABLEAU,POWER BI, YE SAB KA V CALSS CHAHIE MUJHE,
Sir my result grid is in read only mode how do I make it editable like you did here.
Read this article :
stackoverflow.com/questions/10815029/mysql-workbench-edit-table-data-is-read-only
Hello sir Kisi column se hum constraint ko kaise remove karenge.
Please Help
ALTER TABLE TABLE_NAME
DROP INDEX COLUMN_NAME; // On which you have apply the constraint.
SIR if i want to give value in email column how can i do that??
you tell how to create a column but dont tell us how to gives or alter values in that.
I think you didn't see the full playlist of MySQL course. :
ruclips.net/p/PL0b6OzIxLPbzf12lu5etX_vjN-eUxgxnr
Their are 4 main work which we perform on any Database :
1) Insert Data
2) Update Data
3) Delete Data
4) Read Data
If you want to update or alter any value then use have to use "UPDATE" command of SQL.
ruclips.net/video/8j250rfweyc/видео.html&pp=gAQBiAQB
thanks sir😇😇😇😇😇🙂🙂🙂🙂🙃🙃🙃🙃🙃😊😊😊😊😊😊😋😋😋😋😉
what is query for change the datbase name?
ALTER DATABASE old-name MODIFY NAME = Example
Bhai MySQL me total kitne part he matalab ke ye part 35 he
39 videos total hai. Kuch advance topic ki bhi 5 videos aur aayeinge next month.
@@YahooBaba ok thanks bhai
Sir ager hume column ka size change karna hai toh uske liye kya query lagayenge please batayiye
Uske li : ALTER TABLE "table_name" ALTER COLUMN "column_name" "New Data Type" "New Length";
thank you sir
hi sir
i am not able to update data in Id by update command
Is Id column is PRIMARY KEY ?
How to change data inside columns
Use UPDATE command
Column or colunm
sir colum tw add ho raha hai row nh ho rahi h alter command sy row kaisay add hogi
Dear Alter command ka use Database ke Tables ka structure change karne ke liye hota hai na ki row ke data add karne ke liye.
@@YahooBaba sir mainy update if case say rows krli add
Mi na modify Likh raha hu to mere me error aa rha h
show me your SQL command.
Kisi ke paas MySQL note book hai Hindi mein please mujhe de dijiye bahut bahut meharbani hogi
Share code
See our website for code