#mysql
06 November 2007
Total 30 pages. You are browsing page 3/30.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:53 <****> when I say describe mytable, the columns is still unsigned
01:53 <****> any ideas?
01:53 <****> I know that a comes before b but what about Å Ä Ö etc and the german and spanish characters...
01:55 <****> if it sorted by the character set it self then they should come after all other letters but if it's german ö comes after or as an o...
01:57 <****> Why would MySQL not alter a table, yet return no error?
01:57 <****> that's the whole point with different collations...
01:57 <****> utf8_general_ci are 3 bytes, where the ucs2_unicode_ci is 2 bytes, would this also make a difference for you?
01:57 <****> error debugging is of in config?
01:57 <****> off*
01:58 <****> Thanks lemon finally something to consider... but is there anyone who's actually tested out the collations... I'm just plain lazy to do it my self...
01:59 <****> Well, what I meant earlier, is that they are very common collations, there wouldn't be much if any difference between ordering of the characters, I can't imagine
02:02 <****> hey guys I have a quick mysqldump question
02:03 <****> does the --all-databases and --opt option do the same thing
02:03 <****> ?
02:04 <****> hi
02:04 <****> i was wondering how people managed to have passwords in the db that only the user knew about.
02:05 <****> i think it has something to do with encrypting the user's names and passwords together..
02:07 <****> Thanks Lemon! I'm just doing some tests so I'll let you know my findings... thank you again!
02:08 <****> No problem, I'm a little shady on collations, understanding not much past the basics. You asked a good question though :p
02:08 <****> anyone in here know able to answer my question? Or does anyone use mysqldump?
02:09 <****> lol that came out wrong
02:09 <****> Bryanstein: no. they don't
02:09 <****> I have an app that outputs data where fields are separated by ',' and some fields have '"x"', how should i load this?
02:10 <****> Agamemnus: do some research on "hashing algorithm"
02:10 <****> err
02:10 <****> =(
02:10 <****> dkr, then why is it that I see a lot of documentation on the use of the --opt
02:10 <****> I really had a little difficulty finding that option in the man
02:10 <****> bryanstein
02:10 <****> yes Agamemnus
02:10 <****> er.... DKR... how is it usually done?
02:11 <****> but bryanstein too
02:11 <****> if you know
02:11 <****> Bryanstein: if you type / you can search mane pages for the text you type in afterwards
02:11 <****> yes I know dkr
02:11 <****> Agamemnus: with a hashing algorithm
02:11 <****> Bryanstein: then how could i tpossibly be difficult to find the option in the man?
02:11 <****> hm..
02:12 <****> because there is a lot of stuff with opt in it and it refers to something if I remember correctly
02:12 <****> Bryanstein: maybe you were looking at the wrong man? man mysqldump is the one :)
02:12 <****> it says see blah blah
02:12 <****> of course dkr lol
02:12 <****> Agamemnus: md5($password) then when the user logs in, you do if(md5(user_input_pass) == md5_from_database)
02:12 <****> use n to find the next instance
02:13 <****> You can also add to this password hash by generating a random 10 character *salt* for each user and prefixing it to the md5 password
02:13 <****> i see
02:13 <****> Google for salting passwords in databases
02:13 <****> hmm, mixing food and db's? I don't know man.. or should i say lemon?
02:14 <****> no, you shouldn't say it. ;)
02:14 <****> _Lemon_, Ok, this seems to work...
02:14 <****> http://rafb.net/p/D8G9zC75.html
02:14 <****> Go easy, my Perl sucks :) (j/k)
02:15 <****> man i'm just lost on this password stuff... I don't want to make a terrible mistake
02:16 <****> setuid: If it works, what's the problem?!
02:16 <****> dkr, I was in such a haste to spin through all the false positiv from my search that I breezed right over it...i was a fool and put in opt and not --opt
02:16 <****> _Lemon_, No problem now, I just solved it by writing that snippt of perl
02:16 <****> which gave me option this that and the other
02:17 <****> Aga: It's about user privacy, accidents _do_ happen, a database admin who can view the database will going mental over those raw passwords
02:17 <****> gdgd :)
02:17 <****> yeah
02:17 <****> "accidents"
02:32 <****> what does this mean? ERROR 1062 (23000): Duplicate entry '41108-0-0000-00-00 00:00:00-' for key 1
02:33 <****> trying to load a .txt file into a table.
02:35 <****> !perror 1062
02:36 <****> Lemn FYI I can't find any differences between the unicode and general utf8 collations... they seems to be very similar if not exact copies...
02:37 <****> LittleMan, That's good, so it's now down to the range of the alphabet and/or size of the you want to support I suppose
02:38 <****> xuser: Is there a PRIMARY or UNIQUE index on that column? It suggests to me that you're trying to enter a .... duplicate
02:40 <****> I am having trouble with mysql query browser (on ubuntu gutsy) crashing when trying to connect to a debian unstable mysql database. can anyone suggest a different graphical query browser to try?
02:42 <****> metrix: can you use the mysql command line instead?
02:42 <****> metrix: it's much more stable.
02:42 <****> if the database server is "not stable", what does it mean? the client does not matter
02:43 <****> Please, i need comand for get next line of table?
02:43 <****> next line?
02:43 <****> yes
02:43 <****> yes, but I guess I am just used to having something like aquadata at work.
02:43 <****> I was trying to see if there were any good alternatives out there
02:43 <****> kimseong: yes, next line of order by id
02:43 <****> ThamHKI: i thought it gives you all lines
02:43 <****> I need get position 3 of de order by id
02:44 <****> line 3*
02:44 <****> use limit
02:44 <****> more a need get only line 3 not all
02:44 <****> limit 2,1
02:44 <****> !man LIMIT
02:44 <****> _Lemon_: don't know what you mean
02:44 <****> (Information Functions) : http://dev.mysql.com/doc/mysql/en/information-functions.html
02:44 <****> !m ThamHKI select
02:44 <****> ThamHKI: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/select.html
02:45 <****> and search for limit
02:45 <****> xuser: What indexes do you have? What's your PK?
02:46 <****> metrix, use the command line
02:46 <****> _Lemon_: PK?
02:46 <****> metrix: the command line mysql client is the best alternative.
02:47 <****> PRIMARY KEY
02:47 <****> kimseong THX!
02:53 <****> can someone proofread my syntax a sec
02:53 <****> im not trying to make too many mistakes with delete
02:53 <****> sure
02:53 <****> DELETE FROM `1` WHERE id="11","10","9"
02:54 <****> i dont believe that will work
Total 30 pages. You are browsing page 3/30.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last