Menu

My first SQL lesson learned the hard way
📰

My first SQL lesson learned the hard way

DEV Community: database·Dewton Osoro·3 days ago
#hpT3iyd2
#devtodatabase#devto#dev#first#forgot
Reading 0:00
15s threshold

I forgot the WHERE clause on my first UPDATE while practising and changed every row in my test table. Lesson: write the SELECT with the same WHERE first, check the rows, then run the UPDATE. What’s your beginner SQL mistake?

Anonymous readers can preview up to 1024 characters here. Log in to unlock the full article once ingest succeeds.