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?
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?
Top comments (0)