| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> AaronCampbell: I've thought about it... I think I had a pretty good reason against using a file, but I forgot it :-D
<0> Actually, my original reason was that all the scripts on my former webhost's servers ran as the same user...
<1> Does anyone know of any good case/uml database design tools? Or am I stuck with pencil and paper?
<0> ...so to make a file writable by my script would make it writable by every idiot on the server
<2> paper!
<3> i'm trying to add a foreign key constraint to a table but I get funny error messages
<4> like ha-ha funny?
<3> like this "alter table articles add constraint foreign key (author) references users (id) "
<1> mysql_error: You can't do that, you are a moron
<3> Darien: no like hrmm? funny
<4> like 'things that make you go hmmm
<3> "Can't create table './guanabara/#sql-6df9_1b6e.frm' (errno: 150) "
<4> !perror 150
<5> MySQL error: 150 = Foreign key constraint is incorrectly formed
<4> !
<4> re-evaluate your foreign key
<4> !m solus foreign keys
<5> solus: (Foreign Keys) : http://dev.mysql.com/doc/mysql/en/ANSI_diff_Foreign_Keys.html
<4> solus: you need to add a symbol name after 'constraint'
<4> !m solus foreign key constraints
<5> solus: (FOREIGN KEY Constraints) : http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
<4> solus: or take out 'constraint' entirely
<3> ah
<4> e.g. ALTER TABLE articles ADD FOREIGN KEY (`author`) REFERENCES `users` (`id`)
<6> I'm working with a table that is using 2 Columns in the primary key...The first is version (3, or 4), and the second is `order`(auto_inc). I want to swap the order value for 2 objects, so if I want to swap order 1&2 for version 4, I would normally do this: UPDATE `todo` SET `order`=(2-`order`)+1 WHERE `version`='4' && `order` in (2,1); it seems that this doesn't work if `order` is a primary key...I get: 'Duplicate entry '4-2' for key 1'
<6> is there any way to swap them? Or swap the data in them (basically just need to swap a 3rd column...`todo`) without having key constraint problems?
<6> or rather duplicate key problems (that's what I get for reading above comments while I type)
<3> Darien: that query gives the same error
<4> well I didn't say it would work
<7> AaronCampbell - you need to change to a placeholder value.. primary keys are, by definition, unique
<7> for example, 0
<7> but you'll have to lock the table first
<4> solus: does the 'articles' table have a column called 'author' which is the exact same format as the 'id' column in 'users' ?
<3> yes
<4> can you pastebin the SHOW CREATE TABLE foo; results of each table?
<6> sjrussel: so it needs a few queries rather than one?
<6> Something to lock the table, then to set one number to 0, then to set the second number to the first, then to set 0 to the second number? 4 queries?
<8> i tried seraching forums and wikis, but i'm having a problem with crashing in both query browser and administrator on mac 10.4 is this the case for everyone or am i just lucky?
<9> !m reserved words
<5> reserved: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<10> !m reserved words
<5> reserved: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<3> Darien: i just discovered something
<4> oh yeah?
<4> does it involve aliens?
<3> no, small dinosaurs, actually
<4> awesome
<4> do tell
<3> the tables were different types, users was myisam
<3> and then the little dinosaurs came and chewed my toes for being stupid
<7> AaronCampbell, I think that would work
<4> nice
<11> Hi Darien
<6> wow...maybe I'll have to do away with the key...that seems like a waste.
<7> why are you switching versions?
<7> that seems od
<7> but yeah, usually, primary keys are fairly static
<6> Maybe I can remove the primary key, and instead during inserts (SELECT MAX(`order`) FROM `todo`)+1
<6> hmmm, actually...I can't SELECT from the same table I INSERT to in 4.1
<10> hello.
<6> and I'm not changing versions...It's like changing priority of a 'todo'
<10> im trying to make this work:
<10> http://gwireless.sourceforge.net/GoogleMap/InsertWayPoint.php?name=Mine&id=0
<10> Error on UPDATE gps set name="Mine" where id="0" : Query was empty
<10> why do i get that?
<7> I think you're trying to do something simple in the most bizzarly complicated way
<10> you can see the code on InsertWayPoint.phps ...
<7> I recommend going back to the whiteboard
<6> sjrussel: I suppose. I was mostly trying to add functionality (the ability to adjust todo's up and down the priority list) to a system that was in place
<7> priority sounds like something that shouldn't be in a unique key
<7> generally, multiple things can have the same priority
<12> CAST(FLOOR(CAST(BT.ValutaDebit AS DECIMAL(12, 5))) AS DATETIME)))
<12> thats how it is done
<12> and now
<12> **** ya
<12> mother****ers
<7> heh
<12> mota ****ers
<12> u are such disabled beach bastard that stick its little ********
<12> **** in every slut cunt even in your niggerbitch of a motherwhore. u are
<12> such damn grizzly mota****ers that put your damn ugly face in a goats
<12> arsehole every day and let your poor dog give you a blowjob all day and
<12> night , you are such cheap wallmart morons, you cum in the cellar all the
<12> time. bah.
<7> that's another bizzarely complicated way to do something simple, BusyBeaver
<13> killfill: because it is empty... double check your execute() function
<6> sjrussel: right now, we just have an unordered list. I was simply changing it to an ordered list, and allowing us to adjust up/down. I didn't really think about letting 2 things have the same priority
<7> the 4 query thing would work
<7> why not just do that?
<10> zeitoun: yah, got it.. fool error.. :-p sorry for the flood
<14> I think that's quite possibly the funniest thing I've read all day
<15> what is tinytext and when is it used, eg what can tinytext do what varchar can't ?
<16> select if((select ps_id from prosyk where profil_id = 2 and syk_id = 2) is not null,ps_id,null) as id;
<16> how can i get to use id in a replace function?
<16> replace query
<17> Therion, where are you?
<16> how can i bind an subquery to a variable?
<16> or .. something?
<18> "or .. something"
<18> that sounds about right
<16> ...
<13> netbrain, let me try to translate what litheum says: rephrase your un-understandable question.
<18> unintelligible
<13> ty :)
<18> is a slightly more frequently used and much less awkward word
<14> Yea, and un-understandable has that double-negative that confusles people, like irregardless
<19> or, um
<19> confusing
<19> huhu
<19> unintelligable doesn't mean "hard to understand"
<19> unintelligable means "cannot make out what is being said"
<13> imcomprhensible
<19> a bad radio transmission is unintelligable
<16> i have a table with a primary key (ps_id), and 2x seconday keys (profil_id,syk_id) im trying to make an optimized sql query to replace profil_id and syk_id with updated values, or create a new row if not exists
<19> a bad question is just confusing
<14> Oh holy, now you want to get into the technical specifics :P
<20> will: In Tennessee? :)
<14> Should we all start breaking out the dictionary and 'correcting' each other? :P
<19> yes
<19> erudition is important
<16> select (select ps_id from prosyk where profil_id = 2 and syk_id = 2) as a, if (a is not null,a,null);
<14> No, the correct answer would be 'affirmative'
<19> no
<16> so i tried someting like that
<19> the correct answer is "yes"
<14> Yes, it would be
<19> affirmative means "guaranteed to be so"
<19> it is affirmed that someone who has RSVPed will be there
<19> it is affirmative that a bank will release escrow to the payant
<14> ***erting that something is true or correct, as with the answer yes: an affirmative reply.
<19> the answer to a yes or no question, however, is yes or no
<14> First definition of the word 'affirmative'
<19> huhu.
<14> :)
<19> web dictionaries are not known for their control of subtlety.
<14> Apparently neither are you :P
<19> Elshar: One might consider the case of the pot calling the kettle black. Follow through the etymology of "to affirm" and you're in for a dry shock.
<19> By the way, your grammar there is hilariously self referential.
<14> Oooh, I feel bad now. Gonna cry. Just so you know, the first comment was this thing people with humour call a joke. :P
<20> StoneCypher: "a bad question is just confusing"
<20> StoneCypher: How, pray tell, can a question be "bad"?
<14> Apparently if he disagrees with it :P
<20> StoneCypher: Does it stay out all night with its friends, breaking laws and rebelling against authority figures?
<20> Since that goes back to the beginning of this conversation, it's a good reason to drop the thing now. ;)
<19> Therion: shall I answer or drop it?
<13> wow, I didn't know a late night approximative translation of a word in my brain could lead to so much discussion :)
<20> StoneCypher: Whichever you like, I do not care. ;)
<19> I'll answer then drop it.
<20> I am aware of poor questions or incomprehensible questions and so forth, but not "bad" questions.
<19> The root of the word "bad" (baeddel / baedling) in Old High English is "inferior or defective."
<20> Sure, and family/famulus/slave
Return to
#mysql
or
Go to some related
logs:
#web
qingy freezes
#linux
#lisp
#asm
pipe into tar
#debian
crystal snd-cd4236
How do you turn cookies on
compix xgl gentoo
|
|