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,
From: Alvaro Cobo [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, June 12, 2005 8:17 AM
Subject: Re-use a result field into a query
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
From: Pete Lancashire
update fooloc set location = geomfromtext('point(lat lon)');
I have no experience with spatial tables, but from the manual I conclude
that either of these should do the job:
UPDATE `fooloc` SET `location` = GeoFromWKB(point(`lat`, `lon`));
or
UPDATE `fooloc`
Will MySQL 4.0 + bt OpenSSL 0.9.8 compliant?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I'm doing an event project and some of the events will be reccuring. For
example:
Monday, Wednesday, Friday from 10-11:30 am starting June 1 with no end date
Every third Monday at 3-4 pm starting July 1 and ending January 1 (last event
is third Monday in December)
Every other Friday
Well Alvaro,
you can use variables to re-use resultas like that :
mysql set @rs=0;
Query OK, 0 rows affected (0.02 sec)
mysql select 1, (@rs:=2+3) as result1,
- (@rs*100) as result2
- from dual;
+---+-+-+
| 1 | result1 | result2 |
+---+-+-+
| 1 | 5 |
Bob,
You should check out the Date::Manip module from CPAN, it will do what you
need to do. Here is a snippet from the docs about recurrence:
RECURRENCE
A recurrence is simply a notation for defining when a recurring event
occurs. For example, if an event occurs every other Friday or every
hi,
have you tried to hack something with week, month and weekofyear ?
there is an interesting url at
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
be aware that the week begins on sunday.
mysql select weekofyear('2005-01-02');
+--+
|
Dear All,
I am trying to tweak some server parameters to fine tune my MySQL
(4.0.15) server on a linux box (with 6GB of ram)
All my tables/databases use InnoDB. My question is : What is the InnoDB
equivalent of the server parameters Key_read_request key_reads. I
had a look at show
hi,
look at insert buffer and buffer pool. This is quite interesting :
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/InnoDB_Insert_buffering.html
mathias
Selon Manoj [EMAIL PROTECTED]:
Dear All,
I am trying to tweak some server parameters to fine tune my MySQL
(4.0.15) server
Thanks guys for your quick and clear help:
It gives me elements to research. I think I'll try the variable approach,
and the way in how to use it with PHP.
Thanks again and best regards,
Alvaro.
- Original Message -
From: [EMAIL PROTECTED]
To: Jigal van Hemert [EMAIL PROTECTED]
Cc:
Hi friends,
I'm having one doubt on NOT NULL specification for
the table field properties. That is i have created on
table-mine which contains name(Not Null) and pwd(Not
Null). Now I intended to execute the following query.
insert into mine values('','')
This means that i'm trying to insert the
Ashok Kumar wrote:
Hi friends,
I'm having one doubt on NOT NULL specification for
the table field properties. That is i have created on
table-mine which contains name(Not Null) and pwd(Not
Null). Now I intended to execute the following query.
insert into mine values('','')
This means that i'm
Hi,
'' or empty string is not a null in mysql. This is true for Oracle !
this simple test lets you understand :
* Without NULLs
mysql create table notnull (t varchar(10) NOT NULL);
Query OK, 0 rows affected (0.14 sec)
mysql insert into notnull values('test1');
Query OK, 1 row
14 matches
Mail list logo