| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> and still running the query
<1> oh, ok
<0> ah it works now
<2> firewire: IT IS R HARDED!!!
<3> firewire: It is difficult to understand when you don't want to understand, but instead insist on what you know about theory which has nothing to do with it :)
<0> thats extremely weird
<0> thanks for the help
<2> If it takes more than a single machine language op code it is not an atomic operation!!!!!!!111hike
<3> zardinuk: You better learn to learn before you start teaching :)
<1> tomh-: cool, enjoy. Perhaps a permission problem
<3> zardinuk: It's very simple with MyISAM as firewire says
<0> ye maybe from the directory it was in or so
<0> or mysql had to be the owner of the log
<4> salle: I am always ready to learn, but I wasn't getting anything intelligent until you and firewire stepped up to the plate...
<3> zardinuk: You just need to read that's all.
<3> zardinuk: Remember the hint I told you about and you will realize it all :)
<3> zardinuk: One more time: hint (HINT, HINT, HINT): With MyISAM statements that affect single rows are ALWAYS atomic
<5> is there a way of reordering columns in a table?
<3> rik: Why doyou need that?
<5> technicaly, i don't...
<1> rik: alter table, but usually what you're really looking for is an index and ORDER BY
<3> rik: You can always SELECT rows in any order you like
<6> could be handy if replication is being silly :P
<5> indeed.
<5> 'k
<3> rik: MyISAM engine can do it
<3> ah ... he left ...
<1> no one wants to learn today :(
<6> we have problems at work with people building tables on our master replication server with columns in a different order to the slaves :P
<7> SET trust += ((select trust from user where id = $user) * '.1')
<7> is that legit? should i remove the `'s from the .1 ?
<3> zardinuk: Don't you see the negation of that hint? It's so obvious :)
<3> asidjazz: SET x = x + <expression>
<3> asdb: += is not supported
<6> asidjazz: i would put the *0.1 inside the select so that it is easier to read
<1> asidjazz: update table set trust = trust * .1 where id=123
<3> zardinuk: Still here?
<6> that will do something different inviso :P
<2> blammity blammo!
<1> andrewbryson: perhaps. I can't see all of your query :)
<6> it looks like they want to update every row in the table with the same value :P
<6> lol it is not my query :P
<3> Therion: What? Who? Where??
<3> Therion: What's wrong with you today?
<2> inviso: Egads
<8> salle: thank you for your time. found out it's a problem with php<->mysql. nn
<2> salle: Worked too much this last month
<3> Therion: Last month was just training session ....
<7> SET trust = trust + ((SELECT trust FROM user WHERE id = $user) * 0.1)
<7> like that?
<3> Therion: Never!
<1> salle: bah, you should have just told him ;)
<3> inviso: Told whom what? zardinuk? :)
<1> salle: yeah, he bailed finally
<3> inviso: hehe
<3> inviso: It was his weak spot
<9> hello everyone
<2> Don't come in here talking that trash.
<9> I am trying to find some help about selecting info from multiple tables
<1> !tell juanca7777 about joins
<10> Alrighty.
<9> inviso: thanks, I know about joins, but I am having problems with the syntax
<1> juanca7777: Go ahead and post what you've got so far and where it's giving you problems
<2> SELECT o.order_number, d.item_number FROM orders o INNER JOIN order_details d ON o.order_number = d.order_number;
<2> SELECT o.order_number, d.item_number FROM orders o, order_details d WHERE o.order_number = d.order_number;
<2> HELP
<2> PLEH
<3> juanca7777: If you have problems with syntax you don't know about joins :)
<2> o/` I wanna hold your haaaaaaaaaaaaand o/`
<9> inviso: great, I will explain you the basic of the problem to give you a background
<1> Therion: lol, you need a vacation. Come on up to Washington. We've got a few homemade brownies left
<2> How about you just read the two examples given above?
<11> hmm apparantly DECLAREs can't go inside an if
<9> salle:you might have a point there :)
<2> inviso: In fact, I do need a vacation. I suspect homemade brownies are not what I need. ;)
<1> Therion: awwww, *everyone needs brownies
<2> fred87: There is a specific order in which things are allowed, yes.
<7> wehres the docs to show about mysql IF
<1> Therion: with a large gl*** of milk
<2> inviso: I really prefer girl scouts
<1> Therion: :( So didn't see that coming
<2> OMG i mean girl scout cookies Mr. FBI occifer
<9> inviso: so I have about 44 tables in my database, most of them contitute a arborescence of specialized tables, the main of these is a representation of properties
<3> juanca7777: Nobody can help you if you just say "I don't understand something" before you explain what exactly your problem is :)
<1> woah, big word alert
<12> I'm trying to create a sort of blog, and my query for adding a new post isn't working. I have "INSERT INTO posts ('title', 'content') VALUES ('test again', 'one last test');" and there is an ID field that is supposed to autoincrement that is the primary key. What am I doing wrong?
<9> the tables then "split" into two branches one for raw lands another one for built land properties
<3> juanca7777: Say "I have table1 with cols x, y and table2 with cols a, b and I want to do this and this ..."
<2> macgeek: 'title' is a string, not an identifier
<13> macgeek: column names should not be quoted
<9> then the thing branches into many others and then a third sub-branching is done
<2> macgeek: You perhaps want title, or `title` or "title", the last only if you have ANSI quotes enabled.
<12> Therion: okay
<1> juanca7777: icky, that's not going to be fun to query
<9> sale: thanks dude :) I am explaining the prob, am slow...sorry
<12> Therion: do I need to mention the ID field, since it's autoincrement?
<1> macgeek: nope
<9> inviso: indeed nope
<12> inviso: okay thanks
<9> inviso: so I wanted to query first one branch then another branch, i.e. first the raw lands then the built lands
<2> BLING BLING
<1> salle: goodness sakes. I'm betting you learned some stuff in this bug.. http://bugs.mysql.com/bug.php?id=914
<3> inviso: Who? Me? Learning?
<9> query each branch separately is done, though for the syntax I am not sure, but anyhow that is not the case, then I decided to take both queries a mix them up
<2> Salle already knows everything; he does not learn.
<9> there I have a syntax problem
<14> hi again! is there a way to check if mysql(-client) is working if it is not in verbose mode?
<7> WHERE id IN( SELECT phrase.user FROM phrase,link WHERE link.id = $link AND link.phrase = phrase.id, SELECT rule.user FROM rule,link WHERE link.id = $link AND link.rule = rule.id
<7> is this legit? or does each select need () ?
<1> juanca7777: ok, so you're using a union?
<3> Therion: Everything is same as Nothing so I can safely agree with you :)
<2> hehehe
<3> asidjazz: each subquery needs () and alias, but I'm not sure what your real question is
<13> ...only it takes longer to fetch everything...
<1> hey guys, does the mysql optimizer deal with subselects inside IN any better yet or is it still 1 execution per row?
<9> inviso: no, I am using inner joins for querying the good entries for one branch, then I use a left join to join both branches and there I get the error, Should I post the whole query?
<7> salle; just if it woul dwork
<1> juanca7777: yes please. Put it up in a pastebin
<9> sorry, this is the second time I use IRC, what's a pastebin :( ?
<3> juanca7777: Do you get syntax error?
<1> juanca7777: /topic
<9> salle: yes
<3> juanca7777: Don't worry :) If you get syntax error take a look just before the text quoted in error message
<9> salle: jungling around I get syntax errors and 1248 errors
<3> juanca7777: forget about 1248 and focus on syntax errors first
<3> juanca7777: If you rquery is not > 10 rows long you can post it here
<9> salle: select * from (select * from (select * from (select * from (select * from domains_has_property_ads as domPropAds1 inner join property_ads as propAds1 on domPropAds.domPropAd_propAd_id=propAds.propAd_id where domPropAds.domPropAd_url='http://www.onlinepropertiescr.com' and propAds.propAd_is_active='1') as adsInDom1 inner join properties on adsInDom.propAd_prop_id=properties.prop_id) as adsProps1 inner join raw_lands as rwLnds1
<9> on adsProps.prop_id=rwLnds.rawLnd_id) as adsRwLndProps left join (select * from (select * from (select * from (select * from domains_has_property_ads as domPropAds inner join property_ads as propAds on domPropAds.domPropAd_propAd_id=propAds.propAd_id where domPropAds.domPropAd_url='http://www.onlinepropertiescr.com' and propAds.propAd_is_active='1') as adsInDom inner join properties on adsInDom.propAd_prop_id=properties.prop_id) as a
<9> dsProps inner join built_lands as bltLnds on adsProps.prop_id=bltLnds.bltLnd_id) as adsBltLndProps)) as XX
<9> inviso: select * from (select * from (select * from (select * from (select * from domains_has_property_ads as domPropAds1 inner join property_ads as propAds1 on domPropAds.domPropAd_propAd_id=propAds.propAd_id where domPropAds.domPropAd_url='http://www.onlinepropertiescr.com' and propAds.propAd_is_active='1') as adsInDom1 inner join properties on adsInDom.propAd_prop_id=properties.prop_id) as adsProps1 inner join raw_lands as rwLnds1
<9> on adsProps.prop_id=rwLnds.rawLnd_id) as adsRwLndProps left join (select * from (select * from (select * from (select * from domains_has_property_ads as domPropAds inner join property_ads as propAds on domPropAds.domPropAd_propAd_id=propAds.propAd_id where domPropAds.domPropAd_url='http://www.onlinepropertiescr.com' and propAds.propAd_is_active='1') as adsInDom inner join properties on adsInDom.propAd_prop_id=properties.prop_id) as
<9> adsProps inner join built_lands as bltLnds on adsProps.prop_id=bltLnds.bltLnd_id) as adsBltLndProps)) as XX
<15> I tried reading the log without my gl***es and thought Therion said "fires". :)
<16> ok, stop THAT
<16> damnit
<3> urghhrrrrrrr
<1> lol, salle == pwned
<15> Dinner time....
<3> That's query written by someone who claims he has no idea about joins ???????????????
Return to
#mysql
or
Go to some related
logs:
emerge xfce4 circular dependencies
#ubuntu
jsvc C compiler cannot executables
sitecom wl113 problemi suse
unexpected RCODE (REFUSED)
#gentoo
can't run gnome-settings-daemon in fluxbox
#perl
how to install dansguardian with coLinux
i-lines sucks
|
|