'desc' is a reserved word. If you insist on using it for a field name, enclose it in back-ticks: `desc`
[EMAIL PROTECTED] wrote: >>Description: >> > > If you create a table with a column name called 'desc' (as the command, > that is, without the '') mysql allows to create it, but then you > can't query or do any operation with it, always giving an error like: > You have an error in your SQL syntax near desc='foo' where nombre='v5' > > >>How-To-Repeat: >> > > create a table with a column called desc, then perform any operation > with that column (update, alter, etc.) > >>Fix: >> > > May be not allowing to create a column called that way or allowing > it and not giving the error :-) > >>Submitter-Id: <submitter ID> >>Originator: vinko >>Organization: >> > > >>MySQL support: none >>Synopsis: calling a column desc prevents executing any command on it >>Severity: serious >>Priority: medium >>Category: mysql >>Class: sw-bug >>Release: mysql-3.23.41 (Mandrake Linux MySQL RPM) >> > >>Environment: >> >System: Linux landsat.cprsig.cl 2.4.8-34.1mdk #1 Mon Nov 19 12:40:39 MST 2001 i686 >unknown >Architecture: i686 > >Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc >GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs >gcc version 2.96 20000731 (Mandrake Linux 8.1 2.96-0.62mdk) >Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro >-march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' CXX='g++' >CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math >-fno-strength-reduce -fno-omit-frame-pointer' LDFLAGS='' >LIBC: >lrwxrwxrwx 1 root root 13 ene 17 21:21 /lib/libc.so.6 -> >libc-2.2.4.so >-rwxr-xr-x 1 root root 1285896 dic 17 22:19 /lib/libc-2.2.4.so >-rw-r--r-- 1 root root 27470790 dic 17 21:05 /usr/lib/libc.a >-rw-r--r-- 1 root root 178 dic 17 21:05 /usr/lib/libc.so >Configure command: ./configure --enable-shared --enable-thread-safe-client >--enable-assembler --with-mysqld-user=mysql >--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ >--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin >--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql >--infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man >--with-berkeley-db --without-innobase '--with-comment=Mandrake Linux MySQL RPM' > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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