| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> any ideas on this?
<1> That makes no sense.
<0> ok say i have a field called ports
<0> and in it it h***
<0> 333 and 444
<0> so it woudl look like this
<0> 333 444
<0> i want to remove 444
<0> and keep 333
<1> What type is this column?
<1> Why does it have two numbers in it to begin with?
<2> <1> , <gleam-> I want to do a single line query ! In this way as here: http://pastebin.com/724115 work as I expect !
<0> text
<0> filed
<0> field
<2> but I am sure can be done in one query
<1> [AGS]Serialkille: I would control the input before it even entered the database...
<0> ok so liek pull the info, remove the number then update the field?
<1> At the time it was INSERTed.
<0> i didnt know if mysql had a function for it
<0> well thats the thing
<0> the field stores port information on a individual ip address
<1> And now... I don't know if it's ONE or one billion rows...
<3> tdd1984: good to hear
<3> just remember never use a default when using auto_incrment
<0> so i will have more port sometimes, less others, depends on what is running on a ip addess at any given time
<2> Can I convert the following 2 queries in a single one ? http://pastebin.com/724115 ?
<4> ace_me: it'd be great if you actually pasted the two *queries* instead of the rest of this php ****
<2> so should I remove the rest ?
<2> or can you light on ?
<4> well, first of all i don't know what you mean by converting the two queries into 1
<4> do you want to display the intersection of their results? the union?
<2> I want to select same items in one move !~
<2> is it possible ?
<2> you see that i have some items for which I am selecting ID_DOC
<4> currently you have a loop to handle items that fall into a particular group, how do you propose to handle this same thing using an enormous resultset?
<2> and than I have ID_DOC listed in a second or third table
<2> I've hoped $query = "Select * from drl, ddc, doc where (drl.ID_ART ='".$c_art."' OR drl.ID_TRE ='".$c_rel."') AND (ddc.ID_DOC = (Select ID_DOC from drl where (drl.ID_ART ='".$c_art."' or drl.ID_TRE ='".$c_rel."')) AND (doc.ID_DOC = (Select ID_DOC from drl where (drl.ID_ART ='".$c_art."' or drl.ID_TRE ='".$c_rel."'))";
<2> wioth something like that ?
<5> hi
<3> ace_me: thats a hell of a query
<5> I insert a value into a column using p***word=p***word("someword"); and when I select * from table I get something like *A672F856E0B5EIEKD873
<5> why does it put an * in front of the p***word?
<3> ingrato: yes thats encrytped value
<3> the * indicates is the new mysql4.1 style p***word
<5> but I can't do, select * from accounts where p***word=p***word("someword");
<3> so it wont be confused with any left over p***owrds using 4.0 style
<5> cause it can't match it
<3> ingrato: you should be able to do that
<3> I think
<3> but normally I cant think of any reason why you wouwl want to search for a row by its p***word
<5> I know, I'm able to do that in my mysql installation at home, but i try doing it at my web hosting provider's computer and it doesn't work
<3> normally people just compare thep***word on a username
<5> kib, I wanna do this, select * from accounts where username=$username and p***word=p***word("someword");
<3> ingrato: hold on one sec while I check something
<5> kib ok
<3> the * might indicate old style p***word...I need to check
<3> if so then the proper function is old_p***woed()
<3> I will check that out on my mysql
<5> let me try
<5> but the thing is I inserted it using p***word() and I'm gonna select it using old_p***word() ?
<4> !tell ace_me about evil
<6> Alrighty.
<7> !tell jfried about evil
<6> Alrighty.
<3> ingrato: how long is the field used to hold the p***word?
<5> kib, does the table being MyISM have anything to do this it?
<5> field is varchar(20)
<3> thats why
<5> why?
<3> new mysql p***words are 40 chars plus the *
<5> how long is it supposed to be?
<3> so you need a field size of 41
<5> ohhhhh
<3> its only storing the first 20 chars
<5> how do I modify it to be 41 chars now?
<3> so your comparing a 41 char string to a 20 char mysql field
<3> use the alter command
<3> its not unlike the syntax you used in the creat table command
<5> let me look up the alter syntax
<3> or if you se phpmyadmin use that its simplier for those who dont know mysql well yet
<3> normally Iam too lazy to do everyting on the command line so I do my table alterations in phpmyadmin
<5> hmm, still not working, although I modified the column size
<5> let me see what's going on
<3> ALTER TABLE `test` CHANGE `r` `r` CHAR( 41 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
<3> thats how phpmyadmin changed something to char(41) for me just now
<5> yay'
<3> of course the charset stuff you can probably leave off
<5> worked
<5> i was dumb
<5> yeah, thank you soooo much kib
<8> hello, is /*!...*/ statements in sql a remark?
<3> dont worry we are all dumb at some point
<5> :)
<3> just be glad your not dumb allt he time
<5> haha
<3> or maybe some people are?
<3> hmmm
<5> didn't know that though, the 41 chars
<8> for example: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
<3> yes its a change from 4.0 to 4.1
<5> well, gotta go, g'nite thanks again
<3> the p***word hashs are longer now
<8> is this a remark?
<5> kib, did it change to v.5x?
<3> nir_ai: normally /* 8? is a common comment syntax
<3> not all languages use that though
<8> kib, in MySQL?
<3> used like that I ***ume its either perl, c or similar
<3> nir_ai: honestly I never bothered to check what mysql accepts
<3> it very well could be
<3> if /* */ works then it will work across mutiple lines
<3> or // for single lines
<3> thats c style comments
<5> g'nite
<3> nir_ai: it looks like though that someone commented that line out specifically..like it might be uncommanded for certain purposes
<3> although what that 40101 part means is beyond me
<8> I am afraid its not a remark
<3> nir_ai: I just did a dump in mysql since I know it uses commands
<3> so it was using -- as a comment marker
<8> yes, I saw these too
<3> not to say that mysql also doesnt use c style comments as well though
<8> this is why I asked
<3> this is something to tak eup with the manual I guess
<3> not something I know right off hand
<3> nir_ai: was that line froma .sql file?
<8> kib, yes
<3> and the 40101 part I dont understant..some of the test seems to be mysql related but none of it like that makes any sense to me unless those @ are variables in some orther language
<9> question how can i find and replace with something else in mysql. I keep getting error: unclosed quote @ 47
<8> there are lots of lines like that one
<9> update lyrics2 set lyrics = replace(lyrics,'','\'')
<3> nir_ai: well itmight make more snese if that line had the beginning of a query ont he line bfore
<3> azuranz: for every " have a closing " and for every ' have a closing '
<3> make sure you didnt miss one
<8> I can paste first few lines from .sql
<8> If it is not rude
<3> if ' or " is part of the data your searchign for or rreplacing them escape them using \
<9> #1270 - Illegal mix of collations (latin1_general_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'replace'
<3> nir_ai: not here
<3> if anything use pastebin
<3> azuranz: sorry didnt see your second message
<9> yeah
<3> but I cant see the char your want to have replced because its not in my charset
<9> it's a special character thats the thing. Thats why i'm trying to replace it
<3> make sure your using mysql encoiding that supports it
<9> yeah i know. which is why i ***ume i'm getting the error
<8> kib, here it is http://pastebin.com/724134
<9> it probably doesn't. so is there anyway i can find & replace remove it
<3> nso you want to change that unpriuntable char to a '
<3> try this
<9> yeah
Return to
#mysql
or
Go to some related
logs:
#lisp
wget download freezes ubuntu
damn small linux cs4236b
utf8_general utf8_unicode
lasershot lbp 2900 ubuntu
qtopia4 +hx4700
#gimp
#mysql
#css
#perl
|
|