| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> YOU CAN'T MAKE ME
<1> !kick will_
<0> :(
<1> SEE WHAT YOU MADE ME DO
<2> lol
<0> Is this how you treat me? After all these years?
<0> Renich, Stay out of this....
<0> How do people put up with us?
<2> lol
<0> Man, everything is in French... I don't know French.
<2> neither do I... spanish only
<2> just s/banco/bank/
<2> s/estado/state/
<2> will_: so, I suppose you use the query browser?
<0> What's that?
<2> query browser
<2> some mysql software
<0> Yeah? What is it?
<0> I don't use MySQL.
<2> oh
<2> then what do you use?
<0> PostgreSQL and MS SQL Server.
<2> and why are you not on one of those channels?
<0> Therion isn't there.
<0> And I make fun of MySQL newbies.
<2> lol
<0> So we're only dealing with three tables? bancos, bancos_contactos, and estados?
<0> I'm deleting the other tables.
<2> ok
<0> That wasn't a question where "ok" would have been an appriopriate answer.
<2> ok goes for "no problem, do whatever you like/it's necessary
<0> Just wanted to make sure those were the only tables. In case I missed something... :)
<2> acknowledged
<2> lol
<0> Do you have the working query in French?
<0> Or German?
<2> lol
<2> no, but i can try and translate one
<0> Well, what do you have working?
<2> I happen to have 1 in spanish, though
<0> Oh, I'll try that.
<2> ok, wait a sec
<0> You may pastebin that...
<0> CPUnerd, Are you CISC or RISC?
<3> I honestly think that MS Word was designed to slowly drive people homicidal.
<2> lol
<0> Pastebin would have been better... but oh well. That one works?
<4> na, if you kill yourself you can't give microsoft money
<3> homicidal = kill others
<3> KILL ALL HUMANS
<3> TO SERVE MAN
<0> Renich, Surprusingly, I don't get any results from that....
<2> ??
<2> really
<4> infi: yeah I read that wrong
<2> http://pastebin.com/657035
<2> it works for me
<2> the only tables you need is bancos, bancos_contactos and estados
<3> why can't I just submit my resume in LaTeX?
<2> let me dump a new copy and send it...
<0> Not again...
<2> ok
<0> KIDDING! Go ahead.
<0> I just don't want my Gmail account filling up.
<0> phpError, ##php
<6> Heh,
<0> brb
<2> will_: utf-8 or latin-1?
<7> will_?
<8> why doesn't phpmyadmin have a reload database feature anymore ? ... how do I get my database picture to refresh exactly ?
<9> need a little ***istance in old durango. it's the 'Got timeout reading communication packets' error. i've tried tuning mysqld and the apps that our using the db such as horde and freeradius.
<9> problem popped up after i upgrade horde/imp on freebsd.
<10> i have a table, containing: id ticket_id subject msg --> what if i want to make a table listing different ticket IDs (nnique/distinct ticket IDs) but only the one with the lowest "id" so that it serves as the heading
<10> i cant write the sql query
<0> !m miguel group-wise
<11> miguel: (The Rows Holding the Group-wise Maximum of a Certain Field) : http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html
<10> can you give me a link where i can study more about sub queries?
<10> SELECT article, dealer, price
<10> FROM shop s1
<10> WHERE price=(SELECT MAX(s2.price)
<10> what is "shop s1" will_ ?
<10> i found that too on the previous link
<0> shop is the original table name. 's1' is the alias.
<10> dont you need to use "AS" for aliasing?
<0> Not necessary. I wish the manual would put that in there for clarity though.
<12> miguel: nope
<10> i see
<10> can you give me a link where i can study more about sub queries?
<0> !man subquery
<11> (Subquery Syntax) : http://dev.mysql.com/doc/mysql/en/Subqueries.html
<0> Make sure you have 4.1+ though :)
<10> do i really need to use mysql_free result?
<0> Sure.
<10> i mean i've developed a lot of applications without it, what would be the disadvantages?
<12> miguel: mysql_free ??
<10> mysql_free_result()
<12> miguel: php ?
<0> EVERYONE USES PHP
<10> yepp
<10> i mean i've developed a lot of applications without mysql_free_result(), what would be the disadvantages?
<0> PHP cleans all that up.
<10> so even if i dont use it, it would be fine?
<12> miguel: you do not need to use it
<0> Correct. At the end of the script, PHP closes it all up.
<0> !php mysql_free_result
<11> mysql_free_result: http://us2.php.net/manual-lookup.php?pattern=mysql_free_result&lang=en
<0> You should ask in ##php though.
<12> why not use pear or PDO ?
<9> sql, you have a few minutes to help me with a mysql issue?
<4> heh
<4> sql is a bot :)
<9> oh
<9> sorry
<9> obvious my first time here
<9> ;)
<4> clearly
<9> just trying to find resolution for errors i'm seeing
<9> Got timeout reading communication packets
<9> they keep coming and wont stop
<4> timeout from what?
<9> in mysqld.log
<9> 060412 23:49:42 [Warning] Aborted connection 1214 to db: 'radius' user: 'radius' host: 'ns1.brainstorminternet.net' (Got timeout reading communication packets)
<4> ok
<9> radius seems to be working but worried start of bigger problem.
<4> what does your network look like?
<9> also see these errors with my horde/imp webmail server
<9> Ge between machines
<9> have dedicated db server just for mysql
<9> everything was fine until i upgrade my horde/imp install
<9> then the errors started showing up. i've tried the my-large.cnf but still see messages.
<9> just curious if you have come across this before.
<13> Hi there
<13> I am building a very large index for a db, the .MYD is more than 4 Go and it has been processing for more than 15 hours now. But when i have a look at the resource mysqld takes i found out they are very low. It is like 10% processor and maybe 2% memory.
<0> Disk
<13> My question is, is there any limitation anywhere?
<0> SHOW PROCESSLIST; will probably say "Copying to tmp table"
<13> actually says Repair with keycache
<0> oh
<4> snap
<3> will_: someone asked that earlier, too. what is that symptomatic of (the long-running "Copying to tmp table" status message)?
<3> just heavy I/O activity?
<4> loiic: did you turn up myisam_sort_buffer_size before building it?
<13> i am affraid not
Return to
#mysql
or
Go to some related
logs:
xorg.conf serial console
$ua->redirect_ok( $prospective_request, $response )
zipsplit howto
#python
#math
mp3 editor apt-get
#css
GLXUnsupportedPrivateRequest motherboard
PyDateTime_IMPORT
ubuntu which repository localpurge
|
|