| |
| |
| |
|
Comments:
<0> bah, my story only has 10 diggs
<1> Hi, I have this query "select max(sid),max(ssid),mountid,count(ip) as nbusers, count(DISTINCT ip) as nbusers_unique from stats_logdata where datetime_start >='2005-09-06 11:35:00' AND datetime_end <= '2005-09-06 11:35:00' group by mountid;" datetime_ are timestamp, what I need to put in index for the best speed? (Right now I have an index with mountid,datetime_start,datetime_end)
<2> hi all
<3> hello http://pastebin.com/647566 let me know if you can answer any of them many thanks
<3> got disconnected before ..... http://pastebin.com/647566 let me know if you can answer any questions thanks .
<4> hello i have question
<4> how do you merge two fields?
<4> from a query?
<5> hello, i have 3 tables: dirs(dirid, dirname), files(fileid, filename, filesize, dirid), comments(commentid, comment, dirid)
<5> dirs can be empty and without comments
<5> to join the comments to the dirs i do: SELECT d.dirid, d.dirname, c.comment FROM dirs d LEFT JOIN comments c ON d.dirid = c.dirid
<5> id like to select the total numbers of files, and the combined size for each dir too... how do i do this?
<5> preferrably AFTER (?) the WHERE clause (as it won't include searches on the filename)
<5> to prevent it from counting files and adding sizes
<5> i think this would be faster
<5> any ideas?
<6> Error! Unknown column 'genreicon' in 'field list'
<6> how can i add this field
<6> <jome_> Kos_Kash: You should fix your INSERT query
<6> <jome_> The fields has to correspond with what you have in your table
<6> how can i fix the insert query
<6> anyone awake?
<6> sql whores
<7> how do i drop all tables who start with a certain prefix ?
<8> hello
<8> i need some help with mysql
<9> and?
<8> i am getting this message
<8> even i am logged in a root in ss
<8> ssh
<8> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<0> and?
<8> what i have to do ?
<8> i cannot login mysql
Return to
#mysql
or
Go to some related
logs:
yum;bind-tools
#AllNiteCafe
#AllNiteCafe
#linux
#mirc
#squid
#java
#apache
St9_badalloc
#c++
|
|