Q. What are the results of the following SQL commands if col is an integer column?
1. SELECT * FROM mytbl WHERE num_col = '4';
2. SELECT * FROM mytbl WHERE num_col = 4;
1. SELECT * FROM mytbl WHERE num_col = '4';
2. SELECT * FROM mytbl WHERE num_col = 4;
β
Correct Answer: (A)
same
Explanation: This question tests your understanding of how MySQL handles data types in comparisons. Let's break it down: