Delete in MySQL | Learn MySQL in Tamil

Подписаться 5 тыс.

50% 1

In this video, we look at DELETE in SQL. We start with the basic DELETE syntax and move on to learn the importance of the WHERE clause.
Script to create and populate the cats table:
gist.github.co...
Code shown in the video:
gist.github.co...
--------------------------------------------------
🎬Subscribe to our channel 🔔
/ tamiltechg
--------------------------------------------------
📲Watch our Flutter Video Series Here🤙
• Flutter Tamil Tutorial
--------------------------------------------------
💻Watch our Python Video Series Here👨‍💻👩‍💻
• Google Colab - Python ...
--------------------------------------------------
🐘Watch Yaanai Paal Video Series(short tech tips) Here🍼
• Yaanai Paal
--------------------------------------------------
🙏தமிழ் பேசும் அனைத்து நல்ல உள்ளங்களுக்கும் நன்றி🙏🏾

Опубликовано:

12 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 4

@moorthy6495 4 месяца назад

in where condition does not supported truncate

@youtubeTamil 4 месяца назад

Correct 💯

@hemanathsurya4705 5 месяцев назад

SELECT * FROM cats2 WHERE age = 4; DELETE FROM cats2 WHERE age = 4; bro hii i dont get to run this statement its showing that safe update error what to do???

@youtubeTamil 5 месяцев назад

Hello hemanath, there is a setting in MySQL for safe updates which when enabled will not allow unsafe manipulation that is queries to delete/update without specifying primary key. Here you have to disable it by running SET SQL_SAFE_UPDATES = 0;