Bug #3500 update syntax
| Submitted: | 18 Apr 2004 23:49 | Modified: | 19 Apr 2004 7:03 |
|---|---|---|---|
| Reporter: | Nhat Le | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | OS: | ||
| Assigned to: | CPU Architecture: | Any |
[18 Apr 2004 23:49]
Nhat Le
[18 Apr 2004 23:51]
Nhat Le
update 'char' set money=0 where login>100; update char set money=0 where login>100; typos!!! should be: update 'char' set login=0 where login>100; update char set login=0 where login>100;
[19 Apr 2004 0:03]
Nhat Le
Never mind i'm an idiot, i used the wrong chars to enclose the table names.... I used '' rather than ``. I'm very new to the SQL language sorry for this stupid bug post. =/
[19 Apr 2004 0:04]
Nhat Le
please delete... it's not a bug post!
[19 Apr 2004 7:03]
Sergei Golubchik
closed as "not a bug"
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.