Update & Delete | SQL | Tutorial 9

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

I'm taking a course in college on databases. Your course is the best! You really are a gifted instructor. This is from someone who has had many instructors.

williamhunt
Автор

Thanks for providing free videos you are so good man really

zahid_
Автор

Thanks for all the free courses <3 .

muhammadhariskhan
Автор

Killin' it, Mike! Are you still active on this channel?

ethanharlan
Автор

Hi Mike! Thanks for your videos. I have a question, how can I delete duplicates? I use another platform for SQL and when I started I accidentally add the values 2 times, so then I had a lot of duplicates (the guy didn’t explain about primary key in the beginning), so how could I delete what is duplicated?
Thank you

nathaliamendesdealbuquerqu
Автор

But deleting, any row didn't auto-update the auto_incremented student_id. and this can cause problems.

muhammadhariskhan
Автор

when you have used " student_id INT PRIMARY KEY AUTO_INCREMENT "
and then you DELETE a row with student_id=5

but when you INSERT a row, student_id number that gets inserted is 6 instead of five
how to make it 5 without manually updating every time ????

hoelishit
Автор

Hi Mike,
I was facing issues with deleting records which had NULL value. Can you please help?

reyd
Автор

can anybody help me solve the ' connect ECONNREFUSED 127.0.0.1:3306' problem. i faced this kind of problem when i tried to connect to mysql.

semeregr
Автор

Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.

Siddharth-uozw