2011/05/12 15:15 +0200, misiaq
h...@tbbs.net wrote:
(...)
>
> Is the optimizer so clever as to set that test outside the expression, and
> only then evaluate it when "houmuch" and "SharePrice" are not equal?
>
>
Try it yourself:
mysql > explain extended select * from table1;
and the
2011/05/13 09:46 -0500, Dan Nelson
Datediff isn't portable, either :)
What of the date arithmetic is? I looked at it, and saw beside much that it was
MySQL extension. But at least a function of fixed arguments looks like any
other function; there is hope of writing one. The IN
There absolutely is;
there is a configuration file belonging to MySQL named `my.cnf`. It can
exist in many places and there's a hierarchal order of precedense. The most
common of which is /etc/my.cnf.
Within this file you may specify the `datadir` option to identify location
you wish your data to
On Fri, May 13, 2011 at 9:21 AM, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location: /opt/mysql
>
> When creating a new database, a folder (with the name
On Fri, May 13, 2011 08:21, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a My
I have a MySQL question that I'm hoping someone can help answer.
We have a linux machine which has MySQL 5.5.8 installed.
It is currently installed in this location:/opt/mysql
When creating a new database, a folder (with the name of the databas)
gets created in this location:
/opt/mysql/da
In the last episode (May 12), HalÃsz SÃndor said:
> 2011/05/12 13:06 -0500, Dan Nelson
> In the last episode (May 12), Rocio Gomez Escribano said:
> > I found it,
> >
> > mysql> select userID from user where datediff(now(), userPaymentDate)< 365;
>
> This can be made more readable by
On Fri, May 13, 2011 at 10:21, Joerg Bruehe wrote:
> Hi everybody!
>
>
> Dotan Cohen wrote:
>> Is there a simple browser-based MySQL backup solution for
>> non-technical users. [[...]]
>> The main features needed are:
>> 1) Automatic scheduled off-site backups (via SSH or FTP)
>
> Off-site = good
- Original Message -
> From: "Gavin Towey"
>
> The server will disconnect idle connections after a while. The
> wait_timeout variable controls how many seconds it will wait. You
> can set it for your connection when you connect by issuing a query
> like:
>
> SET SESSION wait_timeout=NN
2011/05/12 13:06 -0500, Dan Nelson
In the last episode (May 12), Rocio Gomez Escribano said:
> I found it,
>
> mysql> select userID from user where datediff(now(), userPaymentDate)< 365;
This can be made more readable by using mysql's INTERVAL syntax.
And less portable
Hi everybody!
Dotan Cohen wrote:
> Is there a simple browser-based MySQL backup solution for
> non-technical users. [[...]]
> The main features needed are:
> 1) Automatic scheduled off-site backups (via SSH or FTP)
Off-site = good (for reliability purposes).
> 2) Backup multiple databases and a
12 matches
Mail list logo
