On 7/9/2010 3:04 AM, sangprabv wrote:
Dear List,
I'm developing a winner drawing application using PHP+MySQL. As we know that
MySQL has a built in function RAND() to randomize the result. But using that
function will only randomize, my goal is the player with higher point gets
higher posibilit
On 7/8/2010 10:59 AM, John Nichel wrote:
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
... snipped ...
if(
(
selec
Michael Dykman wrote:
> One problem you might be having is the column named 'call'.. It's a
> keyword, so perhaps you might get away with backticking it?ie.
> `call`
>
> Also, you shouldn't need that final semi-colon inside your statement
> string.. I have had preparedstatement interfaces gi
Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspect
> its a version syntax thing.
>
> Here is what I see:
>
> Couldn't execute statement: You have an error in your
- Original Message -
From: "Grant Peel"
To: "Michael Dykman"
Cc:
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you
Hi All,
I have downloaded mysql-workbench-oss-5.2.14-1rhel5.i386.rpm to test the
MySQL GUI tools. I've installed it with no errors. When I run the
'mysql-workbench' command, it gives me error message:
# mysql-workbench
/usr/bin/mysql-workbench-bin: symbol lookup error:
/usr/lib/mysql-workbench/li
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you sho
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you shouldn't need that final semi-colon inside your statement
string.. I have had preparedstatement interfaces give me grief about
that.
As I reca
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect its
a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL syntax; check the
manual that co
In the last episode (Jul 11), Leonardo Leonardo said:
> On Sun, Jul 11, 2010 at 7:07 PM, Leonardo Leonardo
> wrote:
> > Here is the structure of the Table T1 ( ENGINE=InnoDB ) -
> >
> > `c1` varchar(128) NOT NULL default '',
> > `c2` int(11) NOT NULL default '0',
> > `c3` varchar(32) NOT NUL
On Sun, Jul 11, 2010 at 7:07 PM, Leonardo Leonardo wrote:
>
> Here is the structure of the Table T1 ( ENGINE=InnoDB ) -
>
> `c1` varchar(128) NOT NULL default '',
> `c2` int(11) NOT NULL default '0',
> `c3` varchar(32) NOT NULL default '',
> `c4` blob,
> `c5` double default NULL,
> `c6
You you send us explain of that query.
On Sun, Jul 11, 2010 at 6:31 PM, arijit bhattacharyya
wrote:
> optimize / analyze table in each of the hosts is not a good option for me ,
> this is an in-production set-up with minimal number of boxes in rotation .
>
>
>
> On Sun, Jul 11, 2010 at 5:57 PM, a
optimize / analyze table in each of the hosts is not a good option for me ,
this is an in-production set-up with minimal number of boxes in rotation .
On Sun, Jul 11, 2010 at 5:57 PM, arijit bhattacharyya
wrote:
>
> Hi , i am running into trouble due to wrong index chosen by mysql in some
> par
Hi , i am running into trouble due to wrong index chosen by mysql in some
particular type of queries . This is happening in a critical production
environment where we have deployment in two different colocations . I am
seeing that a paticular query is using one index in one set of hosts &
another i
14 matches
Mail list logo
