| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Psykick: at any point, feel free to re-read what I wrote, answer the questions I asked, and also read the manual examples for stored procs.
<0> Tainted-Wolf: #apache ?
<1> !man stored procedures
<2> (Stored Procedures and Functions) : http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html
<0> Darien: too easy ;-)
<3> arjenAU: Theyre ****in' around.
<1> wtf
<0> Tainted-Wolf: how dare they, and on their own time too.
<3> Lol
<3> I know.
<4> arjenAU: I'll put it on paste bin .... if you can suggest corrections it'd be appreciated
<3> I figured maybe someone else would be able to help in the mean time..
<1> if your car breaks down and the dealership is too busy, do you go ask at Dunkin' Donuts?
<1> Tainted-Wolf: you could try in #web
<1> as a last resort
<4> arjenAU: http://hashmysql.org/paste/viewentry.php?id=1448
<0> Darien: it's like ppl searching google if they already know it's in the mysql manual. impressive needle nonsense
<0> Psykick: sorry no time but I'm sure others will look
<4> ok thanks anyway
<1> inout?
<4> I did look at the manual ... still a little confusing
<1> neat
<1> what happens if you run the query on its own?
<4> Darien: it works fine if I supply the same string to each part
<4> Darien: just not with an input variable
<1> so wait
<1> you're doing an Uppercase function?
<4> errr .... I am
<4> yeah basically
<1> hmm
<4> if I can get this to work I'll try extending it to do uppercase (ucstring php equivalent)
<1> ?
<1> well, don't get me wrong, but uh
<1> why not do this in your application?
<1> just out of curiousity
<4> well I'm trying to experiment a little more with mysql
<1> ok
<1> that's a good reason :)
<4> :)
<5> anyone happen to catch Jim Winstead at SCALE?
<4> been using mysql for some time but only the very basic features of mysql
<4> decided it was about time I started playing a little more with it
<4> I did computer science at university last year and we got introduced to lists and haskell
<1> it works for me if I p*** it a variable
<4> strange ....
<4> did you alter it at all?
<6> Psykick: maybe you want to use a function instead of a procedure
<4> probably
<1> http://hashmysql.org/paste/viewentry.php?id=1449
<1> a function would make more sense (and be faster), but is also more hardcore
<6> udf might be even better for such functions
<7> ERROR 1148 (42000): The used command is not allowed with this MySQL version
<7> mysql> Aborted
<1> owned
<6> raden: what command?
<7> LOAD DATA LOCAL INFILE
<7> WTF ?
<1> !m raden load data
<2> raden: (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<4> Darien: ok something is weird cos it's not working for me
<1> Psykick: what version?
<4> 5.0.15-max
<1> raden: make sure MySQL wasn't started with --local-infile=0 and make sure that local_infile = 0 isn't set in my.cnf
<1> raden: are you on SuSE?
<4> hmmm ... need to upgrade I think
<7> LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table; <<< is there anyhting wrong with that ?
<8> hi everyone
<1> Psykick: I'm on 5.0.18-pro-gpl
<1> raden: dude, I just gave you your answers
<7> Darien, yeas im on POS SUSE
<1> ok
<1> I think SuSE disables it by default
<7> GRRRRR
<7> A/me throws SUSE out window
<7> back to debian
<1> <#
<7> sorry
<7> just really irritated with suse 10.0
<7> what takes me 5 min on a debian system takes me 5 hours on here
<7> great desktop though :)
<1> haha
<8> does mysql have a moving average function?
<1> well that's some comfort ;)
<1> raden: try Ubuntu :p
<7> Darien, what you run bro ?
<4> Darien: do you have a link where I can download 5.0.18 source RPM?
<0> lepine_h: where do you want to move it? ;-)
<1> Debian on servers, OS X on desktops ;)
<4> note: for glibc2.3
<0> raden: suse works fine
<8> hehe
<1> Psykick: if it's source, it doesn't matter which glibc you have ;)
<7> Darien, i was thinking of getting a G5 is it worth it ?
<0> raden: all distros will have local disabled by default, as it's a security risk.
<1> raden: depends on what you do with it
<7> arjenAU, no offense bro ive been using linux 9 years now and suse is great but it ****s for anything server related
<8> arjenAU: , i should take that as a 'no' then?
<0> reading the manual helps. it's all there
<0> raden: no offense bro but you're projecting some personal experience into generalities.
<1> Psykick: http://dev.mysql.com/downloads/mysql/5.0.html
<4> thanks
<7> its all opinion
<7> debian isnt soo bloated
<0> quite
<0> lepine_h: dunno yet, feel free to clarify your question.
<8> well
<1> ...
<7> Darien, is OSX worth spending 1500 on a G5 ?
<8> AVG(field) returns an average of field over ALL the rows ...
<1> thank you Gentoo, for deciding not to run sshd anymore
<1> raden: that's not a simple yes/no question, it really depends on what you use your systems for
<1> raden: that said, I could never not use OS X
<8> while a MAVG(field, rows) would return the average for field over the last $rows
<1> raden: using Linux and windows now is torture
<1> I'm so much more efficient with OS X, and there's a lot of stuff I don't have to do
<1> raden: my suggestion is to come to #macosx during the day when there are more people around and ask them, and they could give you a more rounded set of answers
<6> lepine_h: not likely to have such function, maybe not even feasible in sql
<6> lepine_h: do the avg in your application
<8> that is pretty much what i'm doing right now, and fear i had to keep on doing.
<7> Darien, PHP / Mysql graphics scanning and text **** i think OO has a mac port
<7> Darien, appreciate the info
<1> raden: that's basically what I do, and OS X is great for that
<9> lepine_h: SELECT AVG(field1) FROM table1 ORDER BY yourOrderField DESC LIMIT n;
<1> raden: grab a new PHP tarball, compile it up, and you're golden
<1> pick up NeoOffice/J or the X11 build of OpenOffice 2.0, and you've got that taken care
<8> XGC, yes that would be fine, but unfortunatly but i want more than one row returned ...
<9> lepine_h: Use a subquery if the engine barfs on that use of ORDER BY.
<1> I'd say it's definitely worth exploring, but I'm not prepared to say 'yes go switch now'
<8> and with the size of my tables, that is definatly NOT an option
<1> not at 2 AM anyway
<1> goodnight all
<9> lepine_h: Multiple groups or are you trying to mix aggregates and non-aggregates?
<8> (well, it can't be much worse than doing it userspace)
<7> Darien, i cringe using windows but i dont have a choice dreamweaver and mapping programming
<8> but might as well keep it all in my cl***es
<1> raden: OS X might be suitable then
<1> zz
<8> xgc, i'm almost following you, could you clarify ?
<7> local_infile = 0 isnt in my my.cnf file
<8> i believe it would be both actually ...
<9> lepine_h: When you say you want more than one row returned and you're using aggregation (like MAX, MIN, AVG), usually you're either using a GROUP BY or wanting to return an aggregate along with your non-aggregates for each row.
<8> i deal in the world of the stock market ... all aggregates would me returning the moving avg for only the last day, but, non aggregates (eg, not grouping by ticket) ... it would return me the mavg of volume by day
<8> yes, well make that a non aggregate then
<9> lepine_h: The latter is not normally allows in SQL. You usually need to use a derived table (or other subquery) to obtain the aggregate and JOIN that with your row results (non-aggregates).
<9> s/allows/allowed
<8> gah
<8> it's getting a little complicated for my skill level ...
<9> lepine_h: It's not as bad as it sounds.
<8> but hey ... i'll have to do it eventually!
Return to
#mysql
or
Go to some related
logs:
#lgp
emvs ubuntu
#web
#lisp
#physics
sane cannoscan lide 35
mywebpilot
Intel 220BG injection
#ai
#lisp
|
|