| |
| |
| |
|
Comments:
<0> Are MySQL p***words that are stored in the mysql table MD5ed or are they encrypted a different way?
<1> no, it is not md5
<1> no, they are not encrypted
<1> not that md5 is any encryption
<1> it is a digest algorithm
<1> hopefully you know the difference between a message digest AKA hash and encryption
<1> if not, don't use the word encryption in front of me
<2> hi
<2> i just installed mysql 5 and im trying to connect to it, i cant connect using mysql query browser or mysql administrator, however i can connect from a command window
<2> any ideas why is that?
<2> im using named pipes instead of tcp/ip
<2> but i want to use mysql query browser
<3> hy. i have a mysql table with category, name, age, ... and i wish to copy to `tblcategories` all categories from this table but only once
<3> how can i do this?
<4> hello
<4> i got a field filled with text (1000 chars) and I only want to display 100 chars, how can I do it?
<5> left(fild_name,100)
<5> select left(field_name,100) from table_name;
<4> ok :)
<4> thanks
<5> np Sadkid
<6> I am having a hard time with a query can someone take a look at it: http://pastebin.com/568983
<7> dont you get an error to say the group by cause is ambigious?
<8> what is the problem?
<8> it appears to me that it is giving you what you are asking for
<6> I want the pd table amount for the specific inv_id
<6> it is adding the sum(Amount) of the entire table
<6> Codex: no
<8> ah, i see
<6> any ideas?
<8> no, not off the top of my head. looking
<6> thanx
<8> this may be a job for a udf but i haven't gotten into that yet
<8> well, it's over my head but i know there are guys here that can do it
<6> thanx
<8> i've skimmed through udv and subquery but i still feel like it will boil down to a udf
<8> speeking of which, 250/hr may get the services of...
<8> ;)
Return to
#mysql
or
Go to some related
logs:
philippines ladymen
#linux
adaptec 2410 fdisk
#linuxhelp
spinz
apache AddHandler drupal
#linux
#AllNiteCafe
What horse carried Lester Piggott to his record breaking Derby win in 1983 ?
#gentoo
|
|