| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> how do you like that shizzle?
<1> ok - and what if you get all zeroes?
<2> I'm a little concerned at how long this has been running ...
<1> roler: devide by zero?
<0> soulfreshner; so i'll have to put in one more if statement. :)
<0> soulfreshner; its close
<1> well done!!!
<1> roler: I'm sure you could also do the sum part as SUM(IF(rate1,0,1)+IF(rate2,0,1)...etc...)
<0> true
<3> Therion, Still here? :)
<4> still working
<4> hehe
<3> Therion, lol :) --- I have a quick question with that query you gave me to calculate the days between date 1 and date 2, but now I want to grab the left over hours as well, if possible, so when you are freed up -- if you could give me a hand :).
<4> unix_timestamp() everything so it's in seconds, subtract, divide, BEHOLD
<3> Therion, so I'd take the days calculated to seconds, subtract from the actual time.... and then .... lol
<5> oh my ...
<0> soulfreshner; check it out: http://www.iloveinns.com/innsearch2.php?city=Napa&state=CA&sortby=price
<5> Therion: what about leap seconds?
<0> soulfreshner; this is the page I was coding that for
<4> Jivedue: screw 'em
<5> Therion: hahaha, no kidding, eh? most annoying thing ever..
<4> I dunno, daylight savings time is pretty annoying :P
<5> yah, that's a huge one too
<3> Therion, also, I need to integrate that into this query :P http://pastebin.com/595055
<6> as a clockmaker, time pays my wages
<5> all I ever do is store times w/ gmtime() and do everything in GMT..
<5> archivist: haha
<7> most computer stuff ignores leap seconds entirely
<0> soulfreshner; wow, mysql is smart enough to avoid /0 too!
<3> Therion, based off of a.date and a.date_end lol
<4> CrazyTux: I'm swamped, someone else will need to help
<3> Therion, alrighty :)
<3> Anyone else in here think they are as good as Therion ? lol :)
<4> "better than" is also an option
<1> roler: noticed that
<3> Therion, I don't think thats possible :P
<1> roler: the sum didn't work for me though - I had to drop it
<4> HarrisonF to the white courtesy phone, HarrisonF to the white courtesy phone
<1> roler: select var1, var2, var3, (var1+var2+var3)/(IF(var1,1,0)+IF(var2,1,0)+IF(var3,1,0)) as ave from test;
<3> Therion, theres no way theres anyone better than you lol
<3> Therion, your the MySQL god.
<4> Nah
<4> Maybe "a", but certainly not "the"
<3> lol
<0> soulfreshner; I have one other issue... I'm trying to deal with.. ORDER BY ave... When there is a /0 it does NULL which gets listed at the top. I want it at the bottom... An ORDER BY ave=NULL,ave isn't working. heh go figure
<1> you could use a union of selects...lemme figure out quickly
<3> Therion, I got it to work by using a subselect
<3> Therion, although it dosen't recognize a.date and a.date_end ?
<4> CrazyTux: Now you are the MySQL god!
<3> Therion, naaah lol
<3> Unknown table 'a' in field list
<0> soulfreshner; i'm just pleased that this query is still a <1sec time... w00p!
<1> roler: should be waaaay less than that :)
<3> http://pastebin.com/595072 is that a beast of a query or what
<0> soulfreshner; I have a ton of joins and all kinds of stuff going on.
<0> soulfreshner did you see the website?
<1> too much joins will kill you....in the end
<0> soulfreshner; i'm actually not using joins for this query, I just looked
<1> yep - saw the website...didn't see where you use the code though
<8> holy ****
<8> CrazyTux are you carzy ?
<0> soulfreshner; there is a Price: $$$ image under each picture
<3> Apachez, slightly?
<8> you really should consider to rewrite that =)
<3> Apachez, why?
<3> Apachez, It runs fast.
<8> i mean i need to scroll even if its 8pt font :P
<8> and i have that page in full screen
<3> Apachez, lol
<0> soulfreshner; I have to go to lunch... So if you figure something out PM me, otherwise it was good talking to you. thanks for the help. :)
<1> np
<1> ok guys, bedtime for me...cheers
<3> Therion, Is it possible to grab the a.date and a.date_end inside the subselect from the main select?
<3> well, brb need to take a break.
<9> I am running OPTIMIZE TABLE and am getting an error: "commands out of sync; you can't run this command right now"
<9> any idea why?
<8> didnt you get an error number ?
<9> 2014
<8> !perror 2014
<8> perror 2014
<8> gah stupid bot
<8> illegal error code
<8> is there another number in the brackets ?
<10> Palithius: how are you running this query?
<8> somtimes it says error code 1304 (4)
<9> ahh..damn. I was reading the mysql 5.0 documentation...:(
<9> I am using mysql 4.1
<9> so there is no optimize table
<9> for innodb
<9> sorry
<11> feh
<11> one friendly word of advice...]
<11> NEVER get a lumbal puncture done...
<11> fscknut doctors
<9> no wait...*scratch head*..4.1 does support optimize table for innodb
<4> Palithius: you have executed a statement which produces a result set and have not retrieved the results
<4> Palithius: _all_ of the results
<9> oh I see
<9> ill do that and see if it helps, one sec
<12> is there an app of script for m*** editing mysql?
<12> like changing it from one format to another?
<6> sql
<12> cause I don't want to edit 3000+ lines by hand
<13> changing it from what format to what other format?
<12> I made a dump
<12> and in the broken version it's ordered one way
<12> and in the working version it's ordered another
<12> (trying to save a forum DB)
<11> smysqldump
<11> gah
<11> mysqldump
<12> I did mysqldump
<12> thats how I got .sql
<11> the chat is turned 90 degrees
<11> you want to put it back in now?
<12> no
<12> I need to make the broken version of the db look like the working version of the db without losing the information
<6> dump and import the working
<9> >Therion thank you, you've saved me a lot of time and h***el. That was the problem.
<12> the working is blank
<4> no problem
<12> the broken is from my forum, the working is from a reinstall of the forum software
<12> I need to make the tables match without losing the info
<12> working: INSERT INTO ibf_members VALUES (1,'Weedy',4,'','weedy2887@gmail.com',1141775830,'127.0.0.1',0,'Administrator',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'0',1,1,1,1,NULL,NULL,NULL,0,0,0,NULL,1141775830,1141775830,0,'-1&-1',0,'0','0','0',0,'0&0','','','','d51c828762ddb43b6d4a19e68a03dab3',0,0,'','std',1,'Weedy',0,NULL,0);
<12> broken: INSERT INTO ibf_members VALUES (1,'Weedy',4,'','animetrackercoalition@gmail.com',1110956137,'69.198.125.245',282,'Administrator',1,'-5','0',1,1,22,0,0,'en',1141695573,'0',1,1,1,1,28,1,1987,0,16,0,NULL,1141717200,1141766396,0,'-1&-1',0,'0','0','0',0,'0&1','','4','','f795737ffc58b97e4d83ca44ab1127aa',0,0,1,NULL,0,'Weedy',0,'std','','1:1:1',0);
<11> how much storage does NULL use?
<12> I don't know?
<14> 1
<11> 1 bit?
<14> well, if you got 1 bit, you need a byte
<11> ;)
<12> I need to make the table structures the same :/
<12> hand editing it would **** as I know nothing about mysql :\
<11> Therion you know whats not so good.. that stuff like DESCRIBE tasble etc isnt a valid result set.. i.e somethin you can join on
<11> i mean i see the information schema now is replacing this..
<4> Jax: It's not replacing it, but it is supplementing it and providing queryable views which can be joined against
<4> Jax: So what's the problem? :)
<11> ;)
<11> Weedy well compare the tables and add the columns
<11> actually the dump will do that for you
<12> Jax, really?
<12> how?
<11> wwell the dump includes the create table, no?
<12> http://pastebin.com/595156
<14> Jax: if not left out, it will be included
<14> meeuuhhh
<11> excuse me
<11> the spinal tap still has me bound to bed
Return to
#mysql
or
Go to some related
logs:
debian fstab _netdev
running cardserv on ubuntu
raidtab opensuse
+copy files +ubuntu +home +sudo
mplayer: error while loading shared libraries: libGL.so.1: cannot handle TLS dat
dapper drake winetools ie
#debian
#python
emerge portage + error + python
stracing ass
|
|