|specialunderwear||_syphilis_: is that enough to make the database show up in mysql?|
|_syphilis_||i think so, but i don't use myisam much|
|specialunderwear||ait let's try ^^|
|_syphilis_||it's not a very clever engine, if the files are there it'll probably accept it|
|tdd1984||hey guys how do I change my mysql password, username, or at least add one, so I can connect to it through my php scripts?|
|tdd1984||nice I'm there, I guess I can do the same stuff with windows under the cmd as what I can linux, but linux is still more in that direction, or in that way I don't know.|
What about ssh, and all that for windows?
|tcom||_syphilis_ : thanks for that code. how would I only display the total?|
you guys use putty much
|_syphilis_||tcom: i don't think you can do that with ROLLUP (http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html)|
tcom: what exactly do you want to do? # of rows where product_id like '%beetroot%'?
just the total
_syphilis_: do you use a *nix, or windows?
|_syphilis_||tcom: why can't you do: select count(*) from invoice_items where product_id like "%Beetroot Dip%"; ?|
|tcom||thanks! that's it.. Read largish 'L' plate :)|
|_syphilis_||heh, usually you would learn that before grouping and aggregates :)|
|tcom||i'm a disjointed learner ;)|
|tdd1984||Now windowws don't really have a shell does it, like linux?|
I like windows, but then again I like linux.
I'd like to make windows more linux like :)
I guess its got putty, and etc
|js_||explorer is windows' shell|
so when I access the cmd
like for example I'm installing winrar
it asked if i want to integrate it into the shell, now I could use it through the cmd, but then again cmd is just a command prompt I guess its not considere a shell
but it seems like linux gives you more access to your shell through the terminal
|Auris-||tdd1984, doesn't windows refer to explorer as shell?|
ah, I'm copying js_.
Auris-: I know that, but its different, like linux most things can be done through the terminal.
I don't think you understand what im saying
Now I guess the windows cmd would be considered a terminal in one saying
|Auris-||I don't know why m$ thinks explorer is a shell.|
|tdd1984||becuase you can control the main system, but then again lots of applications have to be ran directly out of windows.|