>Description:
I have been writing an update program in perl, and sought to make use of the
insert...update construct described in the insert syntax section of the manual
supplied
with the download of mysql-4.0.13-standard. However, upon using the construct in my
code,
I receive syntax error messages centered on the 'on duplicate key update..' section
of the
statement.
>How-To-Repeat:
here is my statement in a simplified form, given directly to the database:
mysql> insert into connections (taskID, deadline, user) values ('001',7,'Bob')
-> ON DUPLICATE KEY UPDATE deadline=deadline+7, user='Jane';
i even tried removing all but on ecolumn name from the statement, with the followiign
error still resulting:
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE
user='Jane'' at line 2
The column names are correct
i have noticed that this section no longer exists in the current version of the
manual, but assumed
it would still be correct given I have been working from the manual distributed with
version I'm
running. An explaination of where I'm going wrong, or a simple confirmation of the
removal of the
insert...update construct would be extremely helpful/appreciated.
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
--
Zoe Scaife - System Support Engineer Intern
==================================================================
,-_|\ Sun Services E-mail : [EMAIL PROTECTED]
/ \ Sun Microsystems Australia Direct : +61 (8) 8414 9320
\_,-*_/ Level 7, 41 Currie St Phone : +61 (8) 8414 9350
v Adelaide SA 5000 mobile : 0402 256 628
==================================================================
The optimist views the glass as half full,
The pessimist sees it as half empty -
Engineers know the glass is twice as big as it needs to be :)
>
>MySQL support: none
>Synopsis: manual description of insert...update syntax appears to be incorrect
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: doc-bug
>Release: mysql-4.0.13-standard (Official MySQL-standard binary)
>Server: ./mysqladmin Ver 8.40 Distrib 4.0.13, for sun-solaris2.8 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.13-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 22 hours 31 min 8 sec
Threads: 2 Questions: 470 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables:
5 Queries per second avg: 0.006
>C compiler: gcc (GCC) 3.2
>C++ compiler: gcc (GCC) 3.2
>Environment:
System: SunOS kwel 5.8 Generic_108528-14 sun4u sparc SUNW,Ultra-4
Architecture: sun4
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc
/usr/dist/pkgs/devpro/5.x-sparc/bin/cc
GCC: Reading specs from /opt/sfw/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS='' ASFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1768540 May 25 2002 /lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 19 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1146284 May 25 2002 /lib/libc.so.1
-rw-r--r-- 1 root bin 1768540 May 25 2002 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 19 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1146284 May 25 2002 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--with-named-z-libs=no' '--with-named-curses-libs=-lcurses'
'--disable-shared' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer'
'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
'CXX=gcc'
Perl: This is perl, version 5.005_03 built for sun4-solaris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
