List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies (Upscene Productions) Date:July 9 2014 2:04pm
Subject:Re: Cannot Update, at least not how I'm telling it to!
View as plain text  
The AND in your UPDATE clause makes this a logical operator instead
of being a SQL keyword.

Your syntax is wrong:

UPDATE ...
SET mycol = value,
mycol2 = value
[WHERE ... ]

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

-----Original Message----- 
From: Surya Savarika 
Sent: Wednesday, July 09, 2014 3:56 PM 
To: mysql@stripped 
Subject: Cannot Update, at least not how I'm telling it to! 

Hi.

mysql> describe unions_data;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| ID          | int(11)     | NO   | PRI | NULL    | auto_increment |
| Title       | varchar(70) | NO   |     | NULL    |                |
| Description | text        | YES  |     | NULL    |                |
| UsersID     | int(11)     | NO   | MUL | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+
4 rows in set (0.02 sec)

mysql> select * from unions_data;
+----+-----------+-------------+---------+
| ID | Title     | Description | UsersID |
+----+-----------+-------------+---------+
|  4 | Union One | descr one   |       2 |
|  5 | Union Two | descr two   |       2 |
+----+-----------+-------------+---------+
2 rows in set (0.00 sec)

mysql> update unions_data set Title='Dos' and Description='dos' where ID=5;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'Dos'
mysql> update unions_data set Title=2.2 and Description='dos' where ID=5;
Query OK, 1 row affected (0.33 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from unions_data;
+----+-----------+-------------+---------+
| ID | Title     | Description | UsersID |
+----+-----------+-------------+---------+
|  4 | Union One | descr one   |       2 |
|  5 | 0         | descr two   |       2 |
+----+-----------+-------------+---------+
2 rows in set (0.00 sec)

Notice that it threw an error about an incorrect DOUBLE value for a
field that is a varchar. Notice that when it did decide to update, it
updated incorrectly and it updated Title but _not_ Description, yet
issued no Warnings. Am I missing something??
TIA,
Savi

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql
Thread
Cannot Update, at least not how I'm telling it to!Surya Savarika9 Jul 2014
  • Re: Cannot Update, at least not how I'm telling it to!Upscene Productions)9 Jul 2014