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 3: See the following query. Which system variable can control whether it returns an error or executes ok? – MySQL Question of the Day

Skip to content

Question 3: See the following query. Which system variable can control whether it returns an error or executes ok?

1. February 2010
By urs in mysql questions

1 Comment

mysql> select "1 apple" + "1 orange";
+------------------------+
| "1 apple" + "1 orange" |
+------------------------+
|                      2 |
+------------------------+
1 row in set, 2 warnings (0.00 sec)

a) completion_type
b) sql_mode
c) datetime_format
 

[ Client/Server Concepts (5%) - Server SQL Modes ]

 

Tags: , ,

Comment Feed

One Response

  1. urs — 4. February 2010 @ 23:37:48 —


    Answer:

    b

    The sql_mode variable can be used to control whether or not double quotes may be used as a string identifier.

You must be logged in to post a comment.