>Description:
There is duplication in the syntax of INSERT. Last version is special case of the
second.
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
SELECT ...
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
SET col_name=expression, col_name=expression, ...
or INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name
SELECT ...
>How-To-Repeat:
See manual_Reference.html#INSERT
>Fix:
Remove the last version
>Submitter-Id: <submitter ID>
>Originator: Hans Ginzel
>Organization:
MFF UK
http://www.matfyz.cz/hans/
>
>MySQL support: none
>Synopsis: mysql-doc.thml, duplication in INSERT syntax
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: doc-bug
>Release: mysql-3.23.36 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586
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 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 59 min 3 sec
Threads: 2 Questions: 84 Slow queries: 2 Opens: 18 Flush tables: 1 Open tables:
12 Queries per second avg: 0.024
>Environment:
Debian Linux Woody
System: Linux geze 2.2.19-iiide #2 SMP Mon May 21 09:31:10 CEST 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20010319 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 kv� 27 19:46 /lib/libc.so.5 ->
libc.so.5.4.46
-rw-r--r-- 1 root root 589460 b�e 19 14:47 /lib/libc.so.5.4.46
lrwxrwxrwx 1 root root 13 srp 20 22:36 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 1155720 �ec 27 22:42 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 2579358 �ec 25 17:15 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 �ec 25 17:15 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid
--without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--with-mysqld-user=mysql --without-bench --with-extra-charsets=all
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
