| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> i want to store the same data in 100 columns and select only columns with prime number names, how do i do that? ;D
<1> would be fully possible if you had the proper schema
<1> he should use another table probably
<1> beside, I told him how to do it...
<0> it's funny sometimes how people will make things hard
<1> hey, if a hot chick put on a nice bikini..
<0> ;p
<1> I'm not entirely sure whether I have a GF or is single
<1> we're discussing the matter
<0> careful, you don't want to practice for devorce
<1> hehe
<1> I figured my delete script is rather slow
<1> only delete 50-100 domains a secon
<1> second
<1> (20 000 / 50) / 60 = 6.66666667
<0> of course slow is a relative term
<1> 7 minutes of deleting
<1> on my last test run..
<1> then agian, how often am I to delete 20,000 virtual hosts...
<0> if you only have to do it once...
<1> creating them are faster
<0> kind of like the difference between a microsecond and a nanosecond. if you only do it once you won't notice the differenc. but if you do it too many time, it could be substantial
<1> true enough
<2> Hey!
<0> lol, he thought changing nicks would make a difference?
<1> he changed host though
<1> --- X sets ban on *!*TheBurf@*.l4.c5.dsl.pol.co.uk
<1> --- X sets ban on *!*TheBurf@*.wfd83a.dsl.pol.co.uk
<1> anyways, banned him 3 times already, two here and once in #sql
<0> heh
<3> i am new in mysql... i have just installed it and read a little about tutorials... so sql does not contain user interface right?
<1> sure it does
<1> the command line interface
<1> best there is
<3> i can only work in command line (the black screen)
<1> you should, yes
<0> serleb, i ***ume you are looking for a gui. stick with the "black screen"
<1> you can change the color if you want to though
<0> gui's have a tendency to cripple people
<1> GUIs have a tendency to make people stupid
<1> either that or it is just stupid people that use GUIs
<1> possibly a mixture of the two.
<0> lol
<3> lol
<3> so what is the 1st step? is it to create a database?
<1> probably a good idea
<0> i thought you read the tutorial
<3> i skim in it
<1> http://www.kfwebs.net/links/6 <- skim some more
<3> lol ok
<0> well then we'll give you skim answers
<0> kinda lik skin milk
<0> s/lik/like/
<3> well... i am learning this for my senior project
<0> s/skin/skim/ shees
<3> thats why i am askin u guys
<3> i should learn all for myself
<1> and please, spell properly in here.
<1> yes, you should.
<0> ah, you want us to do your senior project for you
<3> i will make a website linked to the database
<1> any 10 year old can do that
<1> I know, I was one of them once
<0> K_F was probably doing it sinse 6 years old
<1> I had access at the time, but didn't really use it
<1> rewrite some autoexec.bat files in order to get a list of my games, and did a little basic
<1> but not really any database connectivity
<0> heh, i remember that
<3> yeah in university all they do is teach us access in database cl***
<1> I played a lot of games though, I read English manuals before I read Norwegian.
<1> serleb: and the worst part is that folks actually believe they know something afterwards.
<0> they should be teaching sql
<3> yeah
<3> is it true that apache is like mysql?
<1> beebum: it just went up to 4 by the way
<1> serleb: huh?
<1> apache has absolutely nothing to do with mysql
<0> lol
<3> for what we need it/
<1> how old are you again?
<3> 20
<0> hrm, web server/database. well i see difference. ;D
<1> any 20 year old should understand it
<3> yeah i know... but mu major doesnt really stress on those stuffs
<3> i am doing MIS
<0> those stuffs have docs
<0> i would have thought a MIS would know the dif
<1> you think too highly of people, beebum
<0> heh, a weakness of mine
<3> MIS is more business than technology
<0> well were i'm from MIS majors know the dif
<0> and can usually code quite well
<3> in USA?
<0> yes
<3> sure... i am in lebanon
<0> when i was in college the MIS guys were all over databases
<0> of course access didn't even exist back then
<0> nor did a windoze server
<3> php works better with mysql right?
<1> serleb: one more stupid statement and you are out of here, consider this your final warning
<0> learn what apache/php/mysql are
<3> alright
<0> apache/php/mysql
<0> apache/cgi/mysql
<0> apache/perl/mysql
<3> apache/asp/mysql ??
<0> i don't know asp, you tell me
<1> apache/asp is more a question than asp/mysql
<1> you have Apache::ASP, but that is PerlScript, so it is better to just write it in Perl in the first place
<1> then you have chillisoft, which doesn't really work since it doesn't have the COMs
<1> and really, if you are having a degree that is remotely related to computers you should know this
<1> hopefully you flunk
<1> would maybe restore my belief in the system
<0> serleb, you aren't using windoze are you?
<3> ok, all what i should do is the following, make my own website in my PC, i dont want to host it anywhere, it is just a prototype for my senior... so do i still need apache/php/mysql?
<3> yes i am
<0> then don't put in on the D
<0> aw man
<0> too late
<1> hehe
<4> if ive got 2 fields in a table, pid, id, pid contains values 1-10, and id contains any numeric value. Often repeated. a typical entry for id would contain: 1,2,2,3,1,1,1,1 Im trying to work out what id is shown the most times, in this case its obviously 1
<4> ive got a way so that ive found out how many times its being shown, but cant get the actual number
<4> so far doing: SELECT MAX(COUNT(a.id) FROM table GROUP BY a.id;
<4> in this case, that would show: 5, as the id 1 is shown 5 times
<1> missing a )
<4> K_F very true :p
<4> keep missing that out
<1> anyways, do an order by count(a.id) DESC LIMIT 1
<1> you want to show the pid as well
<1> right?
<1> http://www.kfwebs.net/links/6 for SQL
<4> K_F well, now that its worked out that its shown 5 times, i want it to show 1. i.e id1 is shown 5 times
<4> K_F yea, im on there at the moment, from a link you gave to someone else
<1> <1> anyways, do an order by count(a.id) DESC LIMIT 1
<4> ill try that, 1 second
<4> dont i need max(count ?
<1> SELECT id,COUNT(1) AS c FROM table GROUP BY id ORDER BY c DESC LIMIT1;
<1> SELECT id,COUNT(1) AS c FROM table GROUP BY id ORDER BY c DESC LIMIT 1;
<4> ok, ill just try that
<4> you know you do COUNT(1) shouldnt that be where i add the a.id? so it knows what to work out?
<1> ?
<1> you have no idea how it works, do you?
<1> there is also an intermediate / followup site
Return to
#mysql
or
Go to some related
logs:
iframedocument function
bugger buggar spelling
#linux
#chatzone
get cpuid asm
jaascript + format a string
said i like to know where you got the notion to rock the boat
#linuxhelp
html page into a string
javascript call.select
|
|