What Are The Results Of The Following Sql Commands If Col Is An #413
What are the results of the following SQL commands if col is an integer column?</p> <pre><code class="language-sql"> 1. SELECT * FROM mytbl WHERE num_col = '4'; 2. SELECT * FROM mytbl WHERE num_col = 4;</code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs113 MySQL.
It can also be found in
gs gs113 Query Optimization - MySQL Query Optimizer - Quiz No.1.
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;
same
different
1 is an error
2 is an error
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes
