Re-use a result field into a query

2005-06-11 Thread Alvaro Cobo
Hi guys. I´ve got a low-priority, non-important newbie question: Is it possible to refer into a query to a result field from the same query?. For example: a query which uses the field name of a result (alias) to create a new field: Select a.field1, (a.field2+a.field3) AS result1, (result1*1

Named Pipe for General Query Log

2005-06-11 Thread Jake Peavy
Has anyone been able to use a named pipe for their general query log (or any of the other logfiles for that matter)? I tried the following as user mysql: rm /var/lib/mysql/myhost.log mkfifo -m 0660 /var/lib/mysql/myhost.log but the mysql server would not start. I think it would be very useful

SQL: How to update with select a spatial value ?

2005-06-11 Thread Pete Lancashire
I have an existing MyISAM table that I want to add a spatial column to. It originally had two integer columns, lat and lon, and I've added a new column "location point NOT NULL default ''" Example data: select lat, lon, astext(location) from fooloc; +--+--+--+ | lat

Re: LIMIT error

2005-06-11 Thread Gleb Paharenko
Hello. UPDATE in MySQL supports only row_count. See: http://dev.mysql.com/doc/mysql/en/update.html The same you could get from source file "sql/sql_yacc.yy". David Legault wrote: > Hello, > > I'm using the MySQL C API and I got the following error for this query: > > UPDATE

Fwd: Problem report (could not start MySQL 4.1.12)

2005-06-11 Thread Tan Chung
Tan Chung <[EMAIL PROTECTED]> wrote: Date: Fri, 10 Jun 2005 21:13:37 -0700 (PDT)From: Tan Chung <[EMAIL PROTECTED]>Subject: Problem report (could not start MySQL 4.1.12)To: mysql@lists.mysql.comHi there,Attached is my problem report.Please help.Thanks,Tan.-- MySQL General Mailing List For list arc

mysql under cygwin

2005-06-11 Thread Jan Bartholdy
Hi, has anybody any experience with mysql in cygwin (on a windows xp computer). I was able to compile the binary, apache is present in cygwin, but mysql does not work. The newest version of cygwin inc. the xserver ist installed already. Many thanks, Jan Virus checked by G DATA AntiVi