×
Night mode
Sign up
Login
EXPLAIN 
EXPLAIN
provides detailed information about the query result. One of the information that 
EXPLAIN
gives us is how many rows will be affected after running the query
EXPLAIN UPDATE students SET mail = 'email@gmail.com' WHERE id > 39
Note: 
EXPLAIN
works with the following statements: 
SELECT
, 
DELETE
, 
INSERT
, 
REPLACE
, 
UPDATE
by Valeri Tandilashvili
5 years ago
MySQL
EXPLAIN
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences