| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> good call _m0O
<1> nested selects for that idea isn't that good. your calling the count() for every row
<1> not good as a select query i guess
<1> I just love joins :)
<0> well in this case i have to call the count for every row
<0> because its going to be different for every row
<0> but i could still join it to a result set with x and the generated count
<0> on tmp.x = foo.x
<1> yea
<0> it would probably be a wash efficiency wise
<0> but i'm like you, i prefer joins :)
<1> heh
<1> but joins arn't always the ideal choice
<0> just because the server will optimize it to do almost the same thing is no excuse to be lazy...plus the where clause being duplicated is irritating
<0> true, but i prefer them when both are an option
<2> Shouldn't that be a RIGHT JOIN?
<3> same thing
<3> sssssssshhhhhhhhhhhh
<4> firewire: hi
<4> firewire: it's ok - I've solved my problem ... I'm just saying hello ...
<5> do you find that that works babo ?
<4> andrewbryson: what works ?
<5> claiming to have solved your problem in order to make them all complacent :P
<4> andrewbryson: :-) ... hmmm .... sometimes .... even though in this case it's true
<3> hi babo
<4> firewire: I hope all is well ...
<3> yup
<6> any body worked on libmysqld and vb6 ??
<6> hello, anybody worked with embedded mysql and visual basic 6?
<3> aftermathmonster: try asking a more specific question
<6> firewire: i need some sample visual basic 6 code that used libmysqld ..... ? does any one have pointers?
<7> hi all
<7> while running my sql it is giving me this error
<7> ERROR 1045: Access denied for user: 'root@localhost' (Using p***word: YES)
<7> this happen when i fire this command GRANT ALL PRIVILEGES ON drupal.* TO root@localhost IDENTIFIED BY 'p***word';
<7> can anybody help me ?
<7> LoganH, hi
<6> kanhaiya_kk: try this at the linux command prompt #mysql -u root -p
<8> in a table I have a column date that stores a date type... how do I select all rows with the date being today?
<9> dampjam: try: WHERE someDate=date(now())
<7> after that what should i do ? aftermathmonster
<9> dampjam: WHERE someDate=now() -- seems to be fine.
<10> Hi! Does SELECT WHERE blabla IN(list) have some kind of limitation on 96??
<10> or can the list be longer than that?
<11> Hi all, if I have composite index (on more than one table field) can I consider each of the fields participating in the composite index - also indexed? My guesses are "no" but it does not hurt to ask
<12> .. where foo like "%$bar%"; <-this is case-sensitive by default, is it? How would i change it to non-case-sensitive
<13> hey, i have a problem with inodb
<13> searched the manual, but can't fins what i'm doing wrong, exactly
<13> inodb returns errno: 150, and something is wrong with the foreigen keys, but can't find what
<14> show innodb status
<13> faljse: what to look at?
<14> last foreign key error or so...
<13> nvm
<13> hmm
<13> can't resolve table name :s
<13> but that table exists :s
<10> forget my question....being up 24 hours and mysql'ing is not a good combination :p
<12> skogsmaskin: select sleep from bed where blanket="true";
<10> lol
<10> word
<13> faljse: what could it be any idea?
<15> hello, i have a problem with an php script (acidlab) it get's a syntax error here is the query: SELECT acid_event.sid, acid_event.cid, signature, timestamp, acid_event.ip_src, acid_event.ip_dst, acid_event.ip_proto FROM acid_event WHERE acid_event.ip_proto= '6' ORDER BY timestamp DESC LIMIT -50, 50 any ideeas ?
<16> limit -50,50 ?
<15> still error
<16> what would a negative limit do ?
<15> huh ?
<15> i don't really know.. sorry.. i am a newbie in mysql
<17> veurits: probably take the last 50
<16> let's try it :)
<15> so.. any clues ?
<16> I get a error on a limit -10,10
<16> mysql> select * from user limit -10,10;
<16> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1
<15> that's the same error i get
<16> then the -50,50 is wrong in your query
<16> I think you have a php problem , that creates a faulty sql query
<15> hmmm
<15> but LIMIT is supported by mysql
<16> yeah , but no negative numbers , at least , it's not working overhere
<18> is there some way i could know the position of a matched element? something like "select <position> from clients where id=63 and name=juan"
<14> neji: whats a position?
<18> sorry i just realized how silly was my idea
<18> =P
<19> hi
<19> how can i convert a complete database to utf8?
<20> Hi all. help me http://www.hashmysql.org/paste/viewentry.php?id=1678
<20> guyz help me please http://www.hashmysql.org/paste/viewentry.php?id=1678 ?
<21> hmm, simas2 , registered spammer?
<19> how can i convert a database from latin1_swedish_ci to utf8?
<21> I'm planning to build a site in the form ie. site.com/blog/some_userfriendly_title_goes_here.html
<22> Is there a quick howto on running a second instance of MySQL in a different directory, eg /opt/mysql5 compiled with --prefix-/opt/mysql5 ? I am having trouble getting the server running.
<21> but then (after converting the _ to ' '), I'll have to select the item with a query like .. WHERE title='some userfriendly title goes here'
<21> what problems can I expect with character encodings? like etc.. Do they give problems when querying mysql ?
<21> ok I'll just try and see if I'll need some article_id too ;)
<22> I have it running now. I had to create a copy of my.cnf in the root directory and run mysql_install_db. No instructions to tell me this.
<23> hi there. i get this message: ERROR 1145 (42000) at line 3: The host or user argument to GRANT is too long for a relative short user@host user's length is 21, host is localhost. how can i allow longer user names?
<24> i need some guidence to represent swedish characters that is outputted from mysql (latin1 i believe is the default for me) on a web page. where do I start?
<20> help me please http://www.hashmysql.org/paste/viewentry.php?id=1678
<23> anybody please?
<25> need help
<25> is there a way to load .mdb table record to oracle sql table records
<20> I want get tb1 table's all rows and tb2 table's name. tb1 table has tb2_id field. but some tb1 rows not tb2_id. what I do?
<26> hi all
<26> i have a simple query that triggers a filesort for reasons I don't understand
<25> need help
<25> is there a way to load .mdb table record to oracle sql table records
<26> please have a look at http://pastebin.com/649397
<26> why does the second query (with GROUP BY) trigger a filesort?
<27> got a slightly weird situation here - i have a table with a load of rows that i want to copy the data from into another table
<27> table A contains a bunch of news stories with some fields containing text, a story summary and the main story, plus the author (as a numeric ID), i want to copy into another table with completely different data types
<27> any way to do it purely in SQL?
<26> you can use INSERT ... SELECT syntax.
<26> conversion of data types is automatic to some extend. Be careful about character sets, convert explicitely as needed
<27> INSERT INTO table_b SELECT * FROM table_a - how do i name the fields?
<27> forgot to mention the fields have different names
<26> INSERT INTO table_b ( a, b, c, d) SELECT v, w, x, y FROM...
<27> and table B uses a text field for the author name, while table A uses a numeric ID (the author details are stored in a seperate table)
<26> http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
<26> not sure iof the fields are matched by position or by name. if by name, simple use v AS a, w AS b, etc
<27> thanks for your help
<26> the bit about text vs. id sounds like you need to join with some other table to convert. Jost do the appropriate stuff after the select
<26> n/p
<26> ugh :(
<26> anyone up to answer my question about why the self-join with group by wants to do a filesort?
<26> i'm kind of stuck...
<28> perhaps give it a useable index
<26> archivist: why wouldn't the index it has bee usable? Have you looked at http://pastebin.com/649397 ?
<28> cant see why you want the group by in the second qry as you limit it in the where
<26> archivist: I limit by L and group by B. the query collects collocations (i.e. a list of all pages that link to the same pages as a given page)
<26> but perhaps mysql gets confused by that?
<28> but L and B are the same field
<26> it's a self-join
<26> same field, yes.
<26> but the table is "squared"
<10> Hi! Is it possible to sort a result on the IN(arrray) ?
<28> exactly so 1 or 1 is allways 1
<26> archivist: no. wrong. think of L and B as being separate tables containing identical data, maybe then you'll understand.
<26> (they could contain different data, same same)
<28> I use self joins my self
<26> archivist: I don't know how to explain to you without a lengthy example. I know that the query does what I want it to, because i've run it without the group by stuff.
<26> it definitely returns several values for B.fromconcept
<10> I have a SELECT blabla WHERE blabla IN('werewr','ewrwer') - how can I get it sorted on the order of the IN(array) ?
<28> its the group by that doesnt make sense with the where
<28> as you have limited it to the 1 group by the where
<26> archivist: I have limited L, not B.
<26> they contain different values after the join
<28> but L==B in the final analysis as the join where clause ONLY allows 1 value for the group by to use
<26> no. L.to = B.to; L.from != B.from
<26> (the case L.from = B.from is in there too, but that's not relevant)
Return to
#mysql
or
Go to some related
logs:
#web
+fix Firefox too much recursion error
fglrx confict
#web
sending mail with python
newos toolchain
#asm
#perl
vmware cc1: internal compiler error: Segmentation fault
sound problem ubuntu asla
|
|