#mysql
14 October 2007
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
04:02 <****> no
04:02 <****> i installed it with bigdump
04:03 <****> the mysql acount was already setuped
04:04 <****> HEllo, so i have a form, i use to enter values such as username and all and I have this page that checks for certain things if thats all true then inserts values for the username and registers the username... and right now when i fill in the form and hit submit, it shows Query was empty -, What am i doing wrong?
04:07 <****> is it possible to take the result of a MySQL expression and have it return an INTEGER without using CAST or CONVERT? (not supported with partitioning)
04:08 <****> Is there a way to emulate variable length arguments in a store procedure?
04:15 <****> burtonator: what do you mean CAST/CONVERT are not supported with partitioning? You mean as an expression by which you partition like... PARTITION BY HASH( DAYOFWEEK(date_col)) ?
04:15 <****> burtonator: what are you trying to partition by?
04:17 <****> I'm trying to partition by a custom timestamp
04:17 <****> as a range
04:17 <****> its seconds since epoch.. and I can 't use FROM_UNIXTIME in the expression
04:17 <****> hi
04:17 <****> and converting it with TO_DAYS won't work either
04:18 <****> i've a very big problem with mysql, he seem to be ok but doen't work
04:18 <****> Forcing close of thread
04:18 <****> Oct 14 04:19:36 sql mysqld[3793]: 071014 4:19:36 [ERROR] /usr/sbin/mysqld: Forcing close of thread 15 user: ''
04:19 <****> burtonator: returns NULL because the input is not in a valid format huh?
04:23 <****> burtonator: for a range partition I figure you'd probably have to specify absolute values for the columns in the partition def.
04:31 <****> burtonator: do you know how much of a offset (in seconds) your timestamp has from UNIX epoch? If so, then you can add or subtract that number of seconds from the value to convert it to unixtime.
04:32 <****> then perhaps you can get the builtin functions to work.
04:33 <****> the problem is.. it's MUCH bigger than unixtime.
04:33 <****> it's a custom distributed time generator
04:33 <****> we wrote
04:33 <****> that has passing
04:33 <****> so that local machines can generate sequences
04:33 <****> by themselves
04:33 <****> (we're going to write a paper on it)
04:34 <****> anyway.... one way I *could* do it is have partition values just increase in value
04:34 <****> since multiplication generates integers
04:37 <****> Mr_Julien: you've got to be a lot more specific than that.
04:38 <****> how can I abort a sql search that has started in the mysql client
04:40 <****> 1/3 * 5 isn't an integer
04:41 <****> fg3: see SHOW PROCESSLIST and KILL
04:41 <****> okay - thx
04:52 <****> i installed mysql, but it starts and it stop immediatly when opened with mysqld_safe... i remember having this problem on another server a long time ago, but can't remember the fix
05:27 <****> $sqlcx="select * from customer where 1=1 order by CUSTOMER_ID LIMIT 0,$displaypg ".$cSQL." AND CUSTOMER_ID not in (select * from customer where 1=1 order by CUSTOMER_ID desc LIMIT 0, $firstcount)".$cSQL;
05:27 <****> what's wrong with this syntax?
05:30 <****> XsteelWolf: lots.
05:30 <****> like?
05:30 <****> mostly the ordering. You put ordering and limit in the middle of the WHERE
05:30 <****> you have 2 limit statements
05:30 <****> the correct syntax would be?
05:30 <****> oh nevermind
05:30 <****> that's a subq
05:31 <****> ordering and limit isn't affecting?
05:31 <****> yes
05:32 <****> but it's saying im having a syntax error
05:32 <****> Help with create table using a FOREIGN key -- I am fumbling stumbling, current try is: create table Photos (propertyID int, index propID (propertyID), foreign key (propertyid) references allproperties(i));
05:32 <****> blobaugh:
05:32 <****> ?
05:33 <****> I probably don't understanding indeces (and other stuff) well enough but would like to get several child tables created to hold detail
05:34 <****> XsteelWolf: you have to move the first limit and order to the end
05:34 <****> I have read/am reading the create table manual and foreign key pages -- even got the example from foreign key to work but when I try translating it to my table it croaks on create.
05:36 <****> chadmaynard:
05:36 <****> chadmaynard: been doing a lot of house cleaning today
05:36 <****> chadmaynard: you should see all the computer crap i threw away. half filled a 50gal trashcan
05:36 <****> blobaugh: XsteelWolf needs your help
05:36 <****> blobaugh: haha
05:37 <****> whose blobaugh
05:37 <****> XsteelWolf: whats the problem?
05:37 <****> oh
05:37 <****> XsteelWolf: i am!
05:37 <****> ha!
05:37 <****> i saw blogbaugh now
05:37 <****> Half filled? I wouldn't even get started until about 10 of them
05:37 <****> $sqlcx="select * from customer where 1=1 order by CUSTOMER_ID LIMIT 0,$displaypg ".$cSQL." AND CUSTOMER_ID not in (select * from customer where 1=1 order by CUSTOMER_ID desc LIMIT 0, $firstcount)".$cSQL;
05:37 <****> need to correct this syntax
05:37 <****> HerbM: heh, i filled it up the last time
05:38 <****> im taking a 6proc server to the dump on monday
05:38 <****> One time (when I had less stuff) I moved out of a standard office cubicle, about 8x8, and packed 22 boxes to MOVE, and 4 1/2 to throw away; even I don't know where all that stuff was in that little cubicle
05:38 <****> XsteelWolf: is there an error?
05:38 <****> wow
05:38 <****> yep
05:39 <****> hopefully the 6proc doesn't run
05:39 <****> yeah its amazing how much stuff you can accumulate. in a 10x6 room at uni i lived with a roomate and it still took my backseat and trunk, and my fathers truck filled to over the top when i came home for the summer
05:39 <****> mysql server version for the right syntax to use near ' and customer_id not in (select * from customer where 1=1 order
05:39 <****> blobaugh: help XsteelWolf
05:39 <****> HerbM: runs fine. been trying to ditch it for years but noone wants it
05:40 <****> That thing about the 22 boxes is REAL -- I was so amazed when I got them all packed for the movers (corporate hired movers came over the week-end) that I counted them all twice
05:40 <****> XsteelWolf: is that multiple queries? it looks like you have a couple php vars mixed in there
05:40 <****> Oh, come on; 6 procs cannot be all that bad. I still some 166 Mhz stuff here
05:41 <****> HerbM: sssshhhh. he's busy
05:41 <****> they are all 500mhz HerbM
05:41 <****> single query i suppose
05:41 <****> I have some dual 500s that I am still using
05:41 <****> isnt limit supposed to be the last thing onn a query?
05:41 <****> blobaugh: yes.
05:41 <****> HerbM: ssssh
05:41 <****> what's wrong with this: create table Photos (propertyID int, index propID (propertyID), foreign key (propertyid) references allproperties(i));
05:42 <****> my slowest box is a single xp2800. the next slowest is a dual 1ghz
05:42 <****> HerbM: the error tells you.
05:42 <****> blobaugh: focus
05:42 <****> i just put my dual 250 in storage tonight. keeping that for nostalgia
05:42 <****> wait, I see an actual typo in that one but I ahve been having trouble for over an hour -- let me go fix that one.
05:42 <****> chadmaynard: the query is wrong. he has stuff after the limit
05:43 <****> blobaugh: I know what's wrong .......
05:43 <****> blobaugh: XsteelWolf doesn't
05:43 <****> bleah. then why dont you tell him?
05:43 <****> HerbM: possibly it's not InnoDB
05:43 <****> chadmaynard: Yes, but what it tells me is not that helpful: ERROR 1005 (HY000): Can't create table '.\locatordb\photos.frm' (errno: 150)
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last