| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> /win 4
<1> select * from table group by zip having count(zip) > 1; returned 13000+ rows (I know...the table is zipcode, AND the field is zipcode :| )
<1> it doesn't seem like there should be that many duplicates.
<1> oops
<1> SELECT *FROM `zipcode`GROUP BY `zipcode`HAVING COUNT( `zipcode` ) >1
<1> that was the query...last time I accidentally pasted the example you gave
<2> I can't remember how to set a column length :(
<3> Aaron, try zipcode, count(*) instead
<4> Is there something wrong with this (for an UPDATE)? `due`=DATE_FORMAT(02/08/2006, '%Y-%m-%d %T')
<4> I'm not getting any errors in the mysql_query...but the due column gets NULL
<5> question - when changing the hostname of a mysql server.. should i stop it and mv the various /var/db/mysql/$hostname.* files to the new hostname manually and then start mysqld again?
<6> bbtech, select DATE_FORMAT(02/08/2006, '%Y-%m-%d %T') <-- i hope the '02/08/2006' is enclosed but try a select on it
<6> does date_format require a mysql date as the first arg? if so, that would explain it
<6> select DATE_FORMAT('2006-08-02', '%Y-%m-%d %T');
<6> +------------------------------------------+
<6> | DATE_FORMAT('2006-08-02', '%Y-%m-%d %T') |
<6> +------------------------------------------+
<6> | 2006-08-02 00:00:00 |
<4> ohhh
<7> can you turn on/off the mysql queries log (not slow query log, the ALL queries log) without restarting mysql?
<4> jeffzz: is there a way to use a non mysql formatted date?
<7> bbtech -- using a text/varchar field?
<4> no timestamp
<4> !man date
<8> (Date Calculations) : http://dev.mysql.com/doc/mysql/en/Date_calculations.html
<9> guys!
<9> when i get this:
<9> ERROR 1130: Host 'bla' is not allowed to connect to this MySQL server
<9> how do i resolve this? i am logged in with root into phpmyadmin
<9> thanks!
<2> I can't remember how to set a column length :(
<6> you can't, you can set what it displays i think
<6> i think it still takes up the normal size on disk
<2> yeah, how do you do that?
<2> when using the query browser, how do you have it return the field to a certain width?
<2> more specifically 15 chars wide
<10> vasiliyb: whats the host? an IP?
<9> _Slick_Rick: another node on the network
<9> _Slick_Rick: its actually acting very strange
<9> _Slick_Rick: there are 2 mysql servers on one box, mysql 4 and mysql 5
<9> pretty sure its all working good
<9> i can connect locally via mysql_sock
<9> tcp dont seem to work
<10> vasiliyb: you have to allow privilges to the specific IP or IP range
<11> vas: is skip-networking on?
<9> rmartinhoster: in my.cnf?
<9> please explain
<9> also, yes, its confirmed
<9> i cant connect via tcp
<9> just /tmp/mysql5.sock
<9> how about old p***words...? :)
<9> i am able to telnet to port 3307 on the server from the outside
<9> so its not networking
<4> ahh, STR_TO_DATE is what I wanted
<9> 3306 is used for 4.bla server
<9> 3307 is 5.
<9> rmartinhoster: skinetworkins is OFF
<9> and the host vaiable for my user is %
<9> could it be phpmyadmin?
<9> just using some outdated tcp_connect php function?
<9> but i want to have 2 versions of phpmyadmin on system
<9> 1 going to my 4.bla server
<9> other going to my 5.bla server
<12> Hi all, anyone know of a lightweight query monitoring tool for mysql? I need to see what queries are being executed when a php script runs.
<13> use general query log
<12> is that built into mysql?
<12> oh, duh.
<12> that's not a tool, you're talking about the query log itself. thanks =)
<14> is there a free and easy program out there that will allow me to model relations, like http://www.pui.ch/phred/modules/toxi_structure.png
<13> yes even simpler
<15> I am having trouble with a database that is 300,000 lines long
<15> mysql 4.1 is hanging when I run certain selects on the data
<15> Does anyone have any recommendations?
<13> use explain on the slow queries
<13> and make sure they use an index
<13> !man explain
<8> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<16> has anyone seen an if inside a count with a group by
<16> like count(if ) group by
<16> has anyone seen an if inside a count with a group by
<16> like count(if ) group by
<17> help
<17> oops
<18> hi there
<17> adsflkj
<17> \\
<17> `jatan
<17>
<18> how do i set if mysql should return insert_id after an insert? it seems to me that it isn't doing it now because the query browser says "1 row affected by the last command, no resultset returned" and the bigger problem is that i'm connecting to mysql through mysql api as well and the program freeses when it's supposed to use the result gotten. but the insert is completed
<19> I need help, when I try to connect to my MySQL-server I get this: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
<19> I can connect fine through the terminal
<19> mysql Ver 14.12 Distrib 5.0.18, for apple-darwin8.2.0 (powerpc) using readline 5.0
<13> !man oldclient
<8> Nothing found.
<13> !man old client
<8> (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<15> !man explain
<8> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<9> i am astonished how horrible support is :(
<9> anyways, can anyone help?
<13> dont complain we are all volunteers here
<20> help with what?
<9> i know that :) i support enough people
<9> google stinks about this too
<9> ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
<19> thanks for the help with Old_client !
<16> anyone ever used an if inside a count with a group by
<20> !m vasiliyb old cllient
<8> vasiliyb: Nothing found
<20> grr
<20> !m vasiliyb old client
<8> vasiliyb: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<9> i understand what you and the bots have to give me
<9> however, when i set to auth via socket via /tmp/mysql5.sock
<19> where can I download MySQL 4.1 ?
<9> it works
<9> no tcp
<9> and old_p***words is set in my.cnf
<20> diggehs: mysql.com
<9> Darien: you get that?
<19> I **** cause I cannot find it darien
<19> http://dev.mysql.com/downloads/mysql
<20> vasiliyb: even if old_p***words is set, you still have to reset the p***words to use the old auth scheme
<13> !man downloads
<8> Nothing found.
<13> !man download
<8> (How to Get MySQL) : http://dev.mysql.com/doc/mysql/en/Getting_MySQL.html
<9> Darien: AH high five
<9> i love you man
<9> still dont solve my tcp issue
<9> but let me set this first
<15> archivist, Thanks for the tip about explain previously
<20> diggehs: on the right, under 'Related Pages', 'MySQL 4.1 Downloads'
<20> http://dev.mysql.com/downloads/mysql/4.1.html
<15> But I do not see how it is directly helpful
<19> oooh, thanks! :
<19> :)
<20> :)
<15> The database hangs when I do this select on a huge database (300,000 rows)
<13> 300000 in smqll
<13> 300000 is smqll
<15> really?
<13> yes
<15> then what is goin on? I have a primary key
<16> anyone ever used an if inside a count with a group by
<13> but does the explain use that key
<13> albo no
<15> Not sure, I will try it with explain.
<20> gnube: pastebin the explain results
<9> Darien:
Return to
#mysql
or
Go to some related
logs:
can't install opera 8.54 to ubuntu 6.06
#linux
#web
godling yaakov
rhel4 kernel init/main.o
smtpd_require_helo
#math
#perl
#math
could not convert undefined or null to object xmlhttprequest
|
|
