Hi,
Mysql select curdate() + interval 6 month - interval 6 month;
+-+
| curdate() + interval 6 month - interval 6 month |
+-+
| 2011-03-30 |
On 31.03.11 12.52, Andrew Braithwaite wrote:
Hi,
Mysql select curdate() + interval 6 month - interval 6 month;
+-+
| curdate() + interval 6 month - interval 6 month |
+-+
| 2011-03-30
Hello,
I have this field in a table from my database that contains a lot of
information and I would like to extract only a little bit of it.
I have to parse it but need to do it directly in the sql query, ¿do you
know what kind of function I have to use, or how?
This is an example of the
Thanks for your insight! But I'm still worried about the performance of
IN ( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1) If I put 200 values there, does it do 200 individual SELECTs
By the way, sorry ... I wanted to clarify one thing:
I am trying to FILTER by the unique index (fb_uid) in this case, but
JOIN on the primary key (id) and I don't need to use any other fields. I
am guessing that the MySQL indexes map indexed fields (fb_uid) to the
primary key (id) so I
- Original Message -
From: Gregory Magarshak g...@qbix.com
I am guessing that the MySQL indexes map indexed fields (fb_uid) to the
primary key (id) so I wouldn't have to touch the disk. Am I right
about that?
Correct for InnoDB, but MyISAM maps every index straight onto records.
At 07:29 AM 3/31/2011, you wrote:
Thanks for your insight! But I'm still worried about the performance of IN
( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1) If I put 200 values there, does it
In the last episode (Mar 31), Carlos Fernndez Iglesias said:
I have this field in a table from my database that contains a lot of
information and I would like to extract only a little bit of it. I have
to parse it but need to do it directly in the sql query, do you know what
kind of function
2011/03/23 16:29 -0700, Steffan A. Cline
So, this is what I have as a basis to work on assuming I am polling
article #36.
Select *, if(b.articleid=36,1,0) as checked from groups g
Left join agmap a on g.groupid=a.groupid
Left join articles b on a.articleid=b.articleid
Order by g.groupname
Why
Am 31.03.2011 17:53, schrieb S?ndor Hal?sz:
2011/03/23 16:29 -0700, Steffan A. Cline
So, this is what I have as a basis to work on assuming I am polling
article #36.
Select *, if(b.articleid=36,1,0) as checked from groups g
Left join agmap a on g.groupid=a.groupid
Left join articles b
- Original Message -
From: mos mo...@fastmail.fm
The IN() clause is very inefficient because MySQL will NOT use the
index.
It will have to traverse the entire table looking for these values.
Has that still not been remedied ?
It will get the information from the index and not
At 11:20 AM 3/31/2011, you wrote:
At 07:29 AM 3/31/2011, you wrote:
Thanks for your insight! But I'm still worried about the performance of
IN ( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1)
On Thu, March 31, 2011 12:33, mos wrote:
At 11:20 AM 3/31/2011, you wrote:
At 07:29 AM 3/31/2011, you wrote:
Thanks for your insight! But I'm still worried about the performance of
IN ( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4,
Gentle People:
Using the following startup command: /etc/init.d/mysql.server start
I get the following error:
110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
file: './mysql/host.frm' (errno: 13)
1) Where do I find or how do I create the file host.frm
2) What is the
14 matches
Mail list logo