| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> can someone tell me the syntax im starting like IF (SELECT id FROM radcheck WHERE id = 2 IS NULL) THEN INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2",
<0> can someone tell me the syntax im starting like IF (SELECT id FROM radcheck WHERE id <> 2) THEN INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2",
<1> ugh
<0> ok
<0> well
<1> TrippleLeaF: did you find that syntax in the man?
<0> yeah
<2> is `id` the primary key?
<1> link?
<0> yeah its primary
<2> did you think of using REPLACE?
<0> i just need something like if (id <> number) then update else insert
<2> or INSERT ... ON DUPLICATE KEY UPDATE ...
<0> well first of all i dont even know if my if statement syntax is right to start with
<0> is that even possible to do what i want to do ?
<1> lol
<0> im just so pissed ive been trying and the manuals on the site arent very helpful
<0> i use the syntax they want but the **** dont work
<3> TrippleLeaF, abandon the if and try what Codex` suggested
<3> why climb over the fence when you can walk through the gate
<0> yeah but the replace wont insert a new record if its not there
<1> are you retarded?
<1> its not a rhetorical question, are you retarded?
<0> lol
<0> ok am i wrong ?
<1> take a break
<1> go for a walk
<1> come back and rethink
<3> <2> or INSERT ... ON DUPLICATE KEY UPDATE ...
<0> yeah its almost at the point im about ready to take a **** on this whole database
<0> insert on duplicate key update ????
<0> i have no idea what the means
<3> <2> or read http://dev.mysql.com/doc/refman/5.0/en/insert.html, its on the first few
<3> lines..
<1> listen dude
<0> ok
<0> im gettng there i found the insert on duplicate key
<0> INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2", "testing", "p***word", "==", "tes") ON DUPLICATE KEY UPDATE where id = 2
<0> would something like that work
<0> ?
<1> im going to kick you
<3> what's with the 'where' ?
<0> do i not need that >
<0> ?
<0> just the on duplicate key update will work ?
<1> dude
<1> TRY IT
<1> FIGURE IT OUT
<0> i have
<1> and did it work?
<0> and that doesnt work!!! im sorry im a noob i know this u dont have to tell me i deal with customers like me all day i just need this one thing to work
<0> no it didnt
<0> INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2", "testing", "p***word", "==", "tes") ON DUPLICATE KEY UPDATE;
<0> thats what i have and it doesnt work
<0> invalid syntax
<3> where's your update expression?
<1> sorry for the bad attitude TrippleLeaF
<1> its just that ...
<1> well ...
<1> IHATEU
<0> :) its all good
<1> oh sorry, wrong window
<3> lol
<0> does the update expression go after the on duplicate key updates
<1> those manuals are good manuals, ive actually read the whole dam thing and im not really using mysql
<1> look at the syntax in the manual
<1> thats what syntax is
<0> **** i dont know
<3> LanShark, i commend you on your patience. ;)
<0> INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2", "testing", "p***word", "==", "tes") ON DUPLICATE KEY UPDATE update radcheck set value = "new test"
<0> dude
<0> i dont know where the update express goes
<0> i dont know
<0> why cant someone just take it and paste it how i should need it
<0> i know u know what it is
<1> cause we dont do the work for you
<0> im looking at the syntax i cant guess all day long
<1> http://dev.mysql.com/doc/refman/5.0/en/insert.html <= read think
<1> then i guess you fail
<3> 'UPDATE update radcheck' --> UPDATE radcheck
<3> TrippleLeaF, you've turned to mush
<1> and he escaped a kick due to my poor syntax
<1> how ironic
<3> i don't drink and i don't usually recommend that people do but in your case i'll make an exception
<3> ;)
<3> lol
<0> yeah i dont know
<0> i still cant get it
<0> **** it i guess
<0> INSERT INTO radcheck (id,username,attribute,op,value) VALUES ("2", "testing", "p***word", "==", "tes") ON DUPLICATE KEY UPDATE vale ="new test"
<0> i got it i think
<0> i normally use fileamker
<0> filemaker
<0> so when using the on duplicate key update can i use multiple fields like value = this and username = that
<3> vale --> value ?
<0> yeah
<0> figured that one out :)
<0> hey thats for all the help
<0> BTW
<0> if i use value = this and username = that
<0> that should work i think
<3> lets have a round, it's on TrippleLeaF. ;)
<0> hahahaha
<0> no ****
<0> id buy too!!
<0> so can i update more than one field with that command
<0> beebum is ur name tyson
<1> oh man you are neverending arent you
<3> heh
<0> my project that im working on right now is a radius dialup solutoin
<0> im creating a front end for it
<1> id say your project is SOL
<0> no its not
<0> better then that crappy my admin page that comes with it
<0> its all php which is nice but it freakin ****s
<1> you are a mess
<0> have u ever tried it ?
<1> tried what?
<1> php?
<0> nm man
<1> if you are referring to myadmin then yes i have used that
<1> but i prefer the cli
<2> re: that in() inconsistency http://bugs.mysql.com/bug.php?id=12612 , there is/was some kind of bug with it.
<2> only seemed to affect windows though
<3> my test was with 4.0 on openbsd
<2> the IN() delete failed with you right?
<4> hello.
<3> i didn't try to delete just select
<4> somebody speak spanish?
<0> si
<4> trippleleaf, te puedo hacer una consulta?
<3> this should be fun
<4> tengo que hacer un select de una base pero si hay registros repetidos que solo me aparesca uno de cada uno
<1> no bueno mofo
<0> I have to do a select of a base but if there are repeated registrations that alone me aparesca one of each one
<0> thats what hes saying
<3> ab34ef7
<3> ;)
<4> thanks TrippleLeaF!
<4> somebody help me with that?
<3> what is aparesca
<4> i have to do a select of a base but if there are repeted registration in a field, that alone one of each one
<4> sory for my english
<3> it sounds like you want select unique
<4> like that: "select * from Autos WHERE BAJA='0' ORDER BY MARCA SET UNIQUE"
<4> ?
<3> actually i meant select distinct. sorry
<0> Hey beebum and lanshark thanks for the help fellas
<1> dont apologize, your english is fine
Return to
#mysql
or
Go to some related
logs:
zabbab
#chatzone
#gentoo
#chatzone
#linux
#linux
#linux
boost serialization STL has no member named serialize
#MissKitten
#windows
|
|