| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> how to skip each five records, when selecting?
<1> http://www.kfwebs.net/links/6 for SQL
<1> read up on LIMIT
<1> hmm, you said skip
<0> yes
<0> like record 1, record 6 , record 11...
<1> eh
<1> read up on modulo
<1> http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
<1> mysql> SELECT id,url,MOD(id,2) as m FROM links_links HAVING m = 1 ORDER BY id LIMIT 10;
<1> will give you every other based on the id
<1> of course, if you are referring to actual number of result you will use a local variable
<0> thanks :)
<0> freenode guys are noobs
<0> works on 4.0 ?
<0> im refering someppl to your website :])
<0> cya
<1> yeah
<1> iirc
<1> hmm, anyways, should be m=0, not m=1
<1> m=1 would give you every odd number in my example
<1> but that doesn't make sense if you increaes n
<2> id = id*mod(id,5)
<1> ?
<1> mysql> SET @a=0;SELECT id,url,MOD(@a:=@a+1,6) as m FROM links_links HAVING m=0 ORDER BY id LIMIT 10;
<1> | 6 | http://usability.gov/ | 1 |
<1> | 11 | http://www.linuxworld.com | 1 |
<1> | 16 | http://www.aspin.com | 1 |
<2> i thought to wanted to select those records, not created an id like that
<3> what is it with "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" -- ? -- i'm getting this on a clean, fresh install
<4> Hey anyone around, im experimenting with MyISAM and InnoDB
<4> and found some strange results
<4> Innodb - db (profiles) - Showing rows 0 - 29 (60,192 total, Query took 0.0033 sec)
<4> MyISam - db (profiles) Showing rows 0 - 29 (77,814 total, Query took 0.0732 sec)
<4> why is the number of total incorrect in innodb?
<5> Hello, I'm new to SQL and the book I have doesn't line up too well with the latest reference manuals online. If I need a string column bigger than CHAR but don't want to use huge amounts of disc space, what data types will allow up to the 65,535 limit but NOT pad to the full size?
<6> I've got a field named time_submitted that contains dates like '2005-06-29' for example, how can I select just the unique entries as '2005-06'
<6> so I have an array of the year-month stamps that I used
<6> ?
<7> date_format
<8> hey anyone can help me do my joins please.
<8> im trying to join 3 tables. t1, t2, t3, t2 has FK in t1 and t3 has FK in t1
<9> fernando i tried to help you out in #sql
<8> ye ok.
<10> Anyone awake mind helping me with my horrible code?
<11> select distinct nota_finala,incercari from note where nota_finala < '5' and note.id_grupa='1' and note.id_materie='1' order by incercari desc
<11> this should return only values that are smaller than 5, right ?
<12> hello
<12> i have 2 two tables logindetails(userid, username) where userid is primary key and user(userid, fname) where userid is foreign key of logindetails, i want when i delete a row from logindetails automatically deleted from user
<12> can i do that
<12> ?
<13> K_F, i finally added a small blog entry about the vacation
<1> hehe
<13> K_F, i added a comment on you superbowl post
<1> oh?
<1> ah, right
<1> I have two of them :p
<1> and no, I don't want to see that movie
<1> by choice
<13> heh
<13> this guy does a test. eats nothing but fast food for 30 days
<13> almost kills himself doing it
<1> hehe, your youngest look rather relaxed there :)
<13> heh, he's the master of chill
<1> I'd say
<1> must admit I'm not too familiar with the new mexico myself
<13> it's nice. not quite like colorado but not as far either
<1> hehe, I'm not familiar with colorado either :p
<1> but you had a nice trip?
<13> yes
<1> that is the important thing
<1> I had a trip back home to the family for a long weekend, that is about 700km drive..
<13> i think i saw something about that on your blog. ;)
<13> vacations are nice
<13> good to spend time with the family
<13> check out colorado on the web sometime. if you ever come to the us, it's a must see. especially in the winter. ;)
<1> well, only saw my father for some hours before he went skiing in the alphs :) Kitzbuhel
<1> or whatever you write it
<1> but I got the server up in place :)
<13> i bet the alps are nice
<13> cool
<1> yeah, he's coming back tomorrow
<1> they had some more snow yesterday, very nice sunday apparently
<14> kitzbhel
<1> a yearly trip, they invite the biggest clients
<1> an aggregated sum of some millions there.....
<1> grazzy: Danke :)
<13> must be nice ;)
<14> kein problem
<1> yeah, he needed to relax some
<1> not to mention some exercise :)
<13> heh, i'm trying to get back into a routine myself
<14> if you'd call skiing in the alps a "routine" ;)
<1> in his case it is..
<13> heh, i haven't been in shape enough to do any serious skiing in a long time
<13> last time i did a mogul field, i layed down at the end and gasped for air for several minutes before i could get up
<14> mogul field?
<13> a section with a bunch of moguls. i may not be spelling it right ;/
<14> http://images.mjoelkbar.net/v897 < i was in kitzbhel 2002 ;)
<14> new year 2001-2002 infact
<13> nice
<14> yup it was sweet, the pictures **** though ;)
<13> i've never used a showboard
<13> looks fun tho
<14> it is!
<14> i think the fact that you never really get very good at it is what makes it most fun ;)
<14> unless you like spend a couple of seasons
<13> ah, i don't get to go often enough to spend alot of time getting back into the hang of it so i'll probably just stick with skis
<13> as the kids get older they'll want to start skiing
<13> i'll probably get back into it then
<14> awee
<14> the horror
<14> teaching kids to ski
<14> that gotta be really frustrating ;)
<13> heh, i've heard that if you start them early, they pick it up real quick
<13> i've seen real young ones doing real good
<13> they don't even use poles
<14> heh it's easier to ski without ;)
<14> dont do that, it looks stupid :)I
<13> lol
<13> my kids are agile like me. my poor step-son has trouble with these things
<14> hehe
<14> well, you dont get better co-ordination if you dont train
<13> he works hard at the things he wants to do, like baseball
<14> ah
<13> he has had some pretty good success but has reciently given it up
<14> are you american?
<13> yes
<14> k
<13> you?
<14> we dont measure how good you are in a sport in terms of "success" ;)
<14> swedish
<13> ah
<14> has he tried any forms of martial art?
<14> a lot of space for individual goals there, and it's great for agility and learning to use your body.
<13> no, he's not very aggressive. that's always been his biggest road block to anything atheletic
<14> hehe
<14> martial arts has nothing todo with aggressivty
<13> hrm
<14> common misunderstanding
<14> heh, no seriously :)
<13> my daughter wants to do it
<14> go check it out
<13> we'll let her in another year or two
<13> she asked again the other day
<14> i mean, if you put her in k1-fight cl***es im sure it'll be aggressive
<13> maybe in a year we'll sign her up
Return to
#mysql
or
Go to some related
logs:
scorpaen (fiance
#linux
#linux
#c++
Roman flugel ft niche - Broomstick rmx geht`s noch
disable grouping gnome
#AllNiteCafe
#MissKitten
iyotiyot
London station did Brunel's Great Western Railway terminate at
|
|