SQL Tutorial Series 04: Updating Data & Adding Columns with MySQL Workbench
Welcome to our comprehensive SQL Tutorial Series!
🎥 In this specific video, 'SQL Update & Add Columns: Exploring Dynamic Capabilities,' we're diving deep into the heart of SQL. Whether you're a data enthusiast taking your first steps or a seasoned database professional, this video is tailor-made to elevate your data manipulation skills.
🔍 Uncover the hidden techniques for seamlessly modifying data and enhancing database structures, all powered by the prowess of MySQL Workbench. As you follow along with our step-by-step tutorial, you'll gain the confidence and expertise to wield these commands effectively in your own projects.
🚀 Stay tuned for more empowering tutorials in our SQL Tutorial Series playlist, designed to empower you with the skills you need to conquer the world of data manipulation. Like this video, Subscribe to our channel and let's elevate your SQL journey!
---------------------------------------
⭐ Follow us on Social Media ⭐
💻 LinkedIn/onecodecamp
🐦 Twiter/onecodecamp
📷 Instagram/onecodecamp
📱 Facebook/onecodecamp
-------------------------------------------------------
𝘋𝘈𝘛𝘈𝘉𝘈𝘚𝘌 𝘧𝘰𝘳 𝘵𝘩𝘦 𝘈𝘊𝘛𝘐𝘝𝘐𝘛𝘠
-- 𝐂𝐫𝐞𝐚𝐭𝐞 𝐭𝐡𝐞 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞
𝙲𝚁𝙴𝙰𝚃𝙴 𝙳𝙰𝚃𝙰𝙱𝙰𝚂𝙴 𝚜𝚝𝚞𝚍𝚎𝚗𝚝_𝚍𝚋;
𝚄𝚂𝙴 𝚜𝚝𝚞𝚍𝚎𝚗𝚝_𝚍𝚋;
-- 𝐂𝐫𝐞𝐚𝐭𝐞 𝐭𝐡𝐞 𝐒𝐭𝐮𝐝𝐞𝐧𝐭'𝐬 𝐓𝐚𝐛𝐥𝐞
𝙲𝚁𝙴𝙰𝚃𝙴 𝚃𝙰𝙱𝙻𝙴 𝚜𝚝𝚞𝚍𝚎𝚗𝚝𝚜 (
𝚒𝚍 𝙸𝙽𝚃 𝙿𝚁𝙸𝙼𝙰𝚁𝚈 𝙺𝙴𝚈 𝙰𝚄𝚃𝙾_𝙸𝙽𝙲𝚁𝙴𝙼𝙴𝙽𝚃,
𝚗𝚊𝚖𝚎 𝚅𝙰𝚁𝙲𝙷𝙰𝚁(𝟷𝟶𝟶),
𝚊𝚐𝚎 𝙸𝙽𝚃, 𝚐𝚎𝚗𝚍𝚎𝚛 𝚅𝙰𝚁𝙲𝙷𝙰𝚁(𝟷𝟶),
𝚌𝚘𝚞𝚛𝚜𝚎 𝚅𝙰𝚁𝙲𝙷𝙰𝚁(𝟻𝟶)
);
-- 𝐈𝐧𝐬𝐞𝐫𝐭 𝐬𝐨𝐦𝐞 𝐬𝐚𝐦𝐩𝐥𝐞 𝐝𝐚𝐭𝐚
𝙸𝙽𝚂𝙴𝚁𝚃 𝙸𝙽𝚃𝙾 𝚜𝚝𝚞𝚍𝚎𝚗𝚝𝚜 (𝚗𝚊𝚖𝚎, 𝚊𝚐𝚎, 𝚐𝚎𝚗𝚍𝚎𝚛, 𝚌𝚘𝚞𝚛𝚜𝚎)
𝚅𝙰𝙻𝚄𝙴𝚂
('𝙹𝚘𝚑𝚗 𝙳𝚘𝚎', 𝟸𝟶, '𝙼𝚊𝚕𝚎', '𝙲𝚘𝚖𝚙𝚞𝚝𝚎𝚛 𝚂𝚌𝚒𝚎𝚗𝚌𝚎'),
('𝙹𝚊𝚗𝚎 𝚂𝚖𝚒𝚝𝚑', 𝟸𝟸, '𝙵𝚎𝚖𝚊𝚕𝚎', '𝙱𝚒𝚘𝚕𝚘𝚐𝚢'),
('𝙼𝚒𝚌𝚑𝚊𝚎𝚕 𝙹𝚘𝚑𝚗𝚜𝚘𝚗', 𝟸𝟷, '𝙼𝚊𝚕𝚎', '𝙱𝚞𝚜𝚒𝚗𝚎𝚜𝚜 𝙰𝚍𝚖𝚒𝚗𝚒𝚜𝚝𝚛𝚊𝚝𝚒𝚘𝚗'),
('𝙴𝚖𝚒𝚕𝚢 𝙱𝚛𝚘𝚠𝚗', 𝟷𝟿, '𝙵𝚎𝚖𝚊𝚕𝚎', '𝙴𝚗𝚐𝚒𝚗𝚎𝚎𝚛𝚒𝚗𝚐'),
('𝚆𝚒𝚕𝚕𝚒𝚊𝚖 𝙻𝚎𝚎', 𝟸𝟹, '𝙼𝚊𝚕𝚎', '𝙿𝚜𝚢𝚌𝚑𝚘𝚕𝚘𝚐𝚢');
-------------------------------------------------------