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
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
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
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
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
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