Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 51: Which statements about the queries below are correct? – MySQL Question of the Day

Skip to content

By plogi in mysql questions

 

1. select now(),database() from dual;
2. select now(),database();

 
(Select all correct answers)
 
a) Query 2 is invalid.
b) Query 1 is valid only, if a table called dual exists.
c) Query 1 and 2 are valid and do exactly the same.
d) Dual is a dummy table-reference and acts like a table with 1 row.

Tags: , ,

Comment Feed

One Response

  1. plogi28. May 2010 @ 17:49:09


    c d

You must be logged in to post a comment.