Re: Autostart not working for me in 5.5.8 version

Hi Joerg, On Mon, 2010-12-20 at 18:59 +0100, Joerg Bruehe wrote: > Hi Noel, all! > > > Noel Butler wrote: > > On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote: > >> You are right. In previous version init script have a default value, now is > >> empty. > >> > >> mysql 5.1..53 - b

Re: Query Stored Index instead of Group By

Hi Johan, On Sun, Dec 19, 2010 at 7:11 PM, Johan De Meersman wrote: > You can't query the index directly, but if you select only fields that are > in the index, no table lookups will be performed - this is called a covering > index. > Great.. Thanks for the confirmation. Regards, Feris > > -

Re: Trigger?

Well, to produce this result, the first thing that we have to do is to *get rid of* the NOT NULL constraint of the column `foo`. After it, the 'null' can be sent within a INSERT statement, as below: mysql> show create table testtrigger\G *** 1. row ***

Re: Trigger?

The expression you supplied looks right enough.. how was it declared? as an on UPDATE/on INSERT trigger or just a single case? - michael dykman On Mon, Dec 20, 2010 at 5:21 PM, Jerry Schwartz wrote: > I've never used a trigger before, and I want to make one that sounds like it > should be si

Trigger?

I've never used a trigger before, and I want to make one that sounds like it should be simple. Create Table: CREATE TABLE `testtrigger` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `foo` char(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 Here's

RE: odd problem with select as statement

Yes! The "illegal double" error only happens if you do the select like you did. The only error I was getting was the generic "there's an error in your sql." Thank you! Bob From: Hank [mailto:hes...@gmail.com] Sent: Monday, December 20, 2010 11:52 AM To: Ramsey, Robert L Cc: mysql@lists.mysql

Re: Problem with WHERE .. IN

In the last episode (Dec 20), Johnny Withers said: > On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote: > > I have table post (id INT and parent VARCHAR) > > > > +--+-+ > > | id | parent | > > +--+-+ > > |1 | 0 | > > |2 | 0 |

Re: Autostart not working for me in 5.5.8 version

Hi Noel, all! Noel Butler wrote: > On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote: >> You are right. In previous version init script have a default value, now is >> empty. >> >> mysql 5.1..53 - basedir=/usr/local/mysql >> >> mysql-5.5.8 - basedir=. >> > > > /me ponders at wh

Re: Problem with WHERE .. IN

The sub-select only returns a single row, so IN(...) is only looking at a single value in the list .. it doesn't "expand" to into IN (5,7,11). On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote: > I have table post (id INT and parent VARCHAR) > > +--+-+ > | id | parent

Re: odd problem with select as statement

i.e. just try this: mysql> select 4E5664736F400E8B482EA7AA67853D13; ERROR 1367 (22007): Illegal double '4E5664736' value found during parsing -Hank On Mon, Dec 20, 2010 at 12:50 PM, Hank wrote: > > Here's my 5 second guess.. > > 4E5664736... is being interpreted as a number in scientific no

Problem with WHERE .. IN

I have table post (id INT and parent VARCHAR) +--+-+ | id | parent | +--+-+ |1 | 0 | |2 | 0 | |3 | 1 | |4 | 0 | |5 | 1 | |6 | 0 | |7 | 1,5 | |8 | 1,5 |

Re: odd problem with select as statement

Here's my 5 second guess.. 4E5664736... is being interpreted as a number in scientific notation .. i.e. 4*10^5664736 and the parser doesn't like that as a field name. -Hank On Mon, Dec 20, 2010 at 12:43 PM, Ramsey, Robert L wrote: > I am having the hardest time getting a select as statement

Re: odd problem with select as statement

I can't tell you 'why' it is occurring when the field name begins with 4E5, but you can solve your problem by enclosing all your field names in backticks ( ` ). IE: SELECT field AS `4E5664736F400E8B482EA7AA67853D13` On Mon, Dec 20, 2010 at 11:43 AM, Ramsey, Robert L wrote: > I am having the h

odd problem with select as statement

I am having the hardest time getting a select as statement right. Here is the full query: select SUM(IF(image='EE0840D00E2ED8A317E5FA9899C48C19',1,0)) as EE0840D00E2ED8A317E5FA9899C48C19, SUM(IF(image='235C7987796D5B7CEBF56FBDA2BF7815',1,0)) as 235C7987796D5B7CEBF56FBDA2BF7815, SUM(IF(image='9

Re: [NEWS]

SPAM .. Am 20.12.2010 um 17:58 schrieb "Sergey Lazurenko" : > Hello! Our team created new comprehensive solution for data analysts. Could > you place basic information about this product on your page. > > Best Regards, > Sergey Lazurenko > > > -- > MySQL General Mailing List > For list

[NEWS]

Hello! Our team created new comprehensive solution for data analysts. Could you place basic information about this product on your page. Best Regards, Sergey Lazurenko dbForge Data Studio for SQL Server 1.00.odt Description: application/vnd.oasis.opendocument.text -- MySQL General Mailing

Re: Error in mysql replication with LOAD DATA INFILE

The application is designed to work such a way that it will process the csv files daily as part of the aggregate process to calculate some metrics. it runs fine on the master, when it come to slave through replicaiton it fails with the error. i even tried upgrading the slave to latest version mys

Discontinued AUTO_INCREMENT problem....

Hi everybody ! A have a discontinued AUTO_INCREMENT sequence when i insert data in a table with a 100 (or more) items SELECT request. The problem (or situation) is reproductible, you can see an example below. Anybody could explain this to me ? Cheers XC My MySQL version : Ver 14.14 Distrib 5