| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> thank you forthat comment shabbs i had forgotten them and was wondering why it wasnt working :)
<1> how do you take a field that is stored as a timestamp and compare it to a date? eg 2002-05-06
<2> vhuren: you mean a data stored in a date field ?
<2> a datE stored in a date field ?
<1> zeitoun: well I have a field with timestamps now I want to compare a date to them? eg timestampfield < dateinput
<2> !m vhuren date time functions
<3> vhuren: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<2> see the timestamp() function
<4> when i do a show grants
<4> i see two grants
<4> how to delete one of them ?
<2> use REVOKE
<5> what pattern can i use to delete all rows where a text field contains white space?
<2> jade like '% %' ?
<5> but wild card % would match any character, no?
<5> um im looking for a pattern that matches only white space
<2> jade like one or more white space and nothing else ?
<6> jade: you could try TRIM(field) = ''
<5> thanks
<7> regexp '^ +$'
<4> mmmm i use revoke
<4> but i see the same thing :
<4> mysql> REVOKE USAGE ON *.* FROM 'devinmedia'@'curayacuserver';
<4> Query OK, 0 rows affected (0.00 sec)
<4> is ok ?
<8> can not revoke that
<8> ssue SHOW GRANTS again ;)
<8> issue *
<8> USAGE means "can connect"
<8> no point having other privileges - if you can not connect ;)
<4> i do a revoke from the last grant i do ALL PRIVILEGES and its works fine
<4> but i try to revoke the previous grant but i cant
<5> nail_, how can i use that regex in a delete statement?
<4> ohh is IDENTIFIED BY p***WORD
<5> tried delete from src_desc where description like '^ +$';
<7> jade: where description regexp '^ +$';
<4> mysql> show grants for 'devinmedia'@'curayacuserver';
<4> +-----------------------------------------------------------------------------------------------------+
<4> | Grants for devinmedia@curayacuserver |
<4> +-----------------------------------------------------------------------------------------------------+
<4> | GRANT USAGE ON *.* TO 'devinmedia'@'curayacuserver' IDENTIFIED BY P***WORD 'hexadecimal value' |
<4> +-----------------------------------------------------------------------------------------------------+
<9> The HAVING foo=MAX(foo) thing doesn't seem to work.
<4> i want my user can create tables
<4> inside mysql
<10> hi, anybody knows a good free mysql query analyzer please?
<11> quotemstr: You generally use a JOIN to handle that sort of thing. HAVING deals with aggregates. WHERE deals with non-aggregates, generally.
<9> Xgc: Right - it was just suggested before here.
<11> quotemstr: You can also use the simple subquery approach: SELECT ... FROM tbl WHERE tbl.foo = (SELECT MAX(foo) FROM tbl);
<11> quotemstr: *nod*
<11> The JOIN form may behave better in some cases.
<12> piclez: what about the built in one?
<10> jbalint: can be, which one I should download?
<12> it's built in. just use the cli: explain select * from table
<10> jbalint: but I need something to help with more complex queries, something graphical
<10> I have navicat trial but I can't connect to the mysql on port 3306
<12> What is wrong with the built-in one?
<13> oops
<14> awwwww
<13> inviso: Not even sure why I did it. ;)
<14> Therion: I was hoping for some entertainment ;)
<9> Are InnoDB tables much slower for querying than MyISAM tables?
<9> For hundreds of thousands of rows.
<13> quotemstr: "It Depends."
<9> I'm still trying to figure out why this query is slow.
<13> See what EXPLAIN has to say about it.
<14> !m quotemstr explain
<3> quotemstr: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<13> FLUSH STATUS; execute query; SHOW STATUS; and examine what the server has had to do
<13> etc
<13> !kick inviso ENTERTAINMENT!!!
<14> lol
<9> I've been using EXPLAIN, SHOW PROCESSLIST, etc.
<10> jbalint: I don't know how can I call this built-in?
<15> hi Therion
<12> piclez: Just type 'explain' and then your query
<13> Hey blue
<15> hows life ?
<13> Better than dead
<10> ok thx :)
<13> I think
<15> you'll never know unless you try
<13> alphablue: You try. I'll go on that Crossing Over show and you can contact me there and let me know how it is.
<9> Why would MySQL spend a lot of time sorting a result when I didn't ask for sorted results?
<15> i don't think they offer that in hell
<9> The table is only 117mb..
<14> sure they do. It's channel 18
<9> Shouldn't be taking so many minutes to query it.
<15> thats qvc
<14> is it? Perfect :)
<15> quote: but it is
<16> anyone run into this:
<16> #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
<15> i only run into telephone poles
<16> :) ha
<15> blahh: i've experienced that message before
<16> and any advice?
<14> quotemstr: it may be doing intermediate sorting try to get your result. Run explain select blah blah and look at the output from explain
<14> blahh: make sure your server is running
<15> check to see if the mysql server is configured properly.. and is running
<16> it is
<15> the error message gives you the advice
<9> Okay, different question. Say I have a temporary table foo, and I want to use another table to update some of the columns of the temporary table based on some key, sort of an after-the-fact JOIN,.
<15> make sure you're connecting to that server then :)
<9> What would the syntax for that be?
<15> how did you make sure that it is working ?
<16> Uptime: 40 min 48 sec
<16> mysql; status
<15> and you're connecting to that same server ?
<16> yeh
<15> what's your cmdline option to mysl ?
<15> mysql
<16> i don't follow...cmdline?
<15> what did you type to connect to mysql ?
<15> mysql -u -p ...
<16> typed just mysql
<16> then status
<16> thats it
<15> so it gave you the uptime
<15> where did you get the 2002 error ?
<16> in phpmyadmin
<15> and you're certain phpmyadmin is configured properly ?
<16> and i realized this when i could not connect with my nagios
<16> sure nothing has changed bro, only rebooted
<15> Therion: i just realized how hard your job is
<13> alphablue: which one?
<16> you know what i will reconfigure phpmyadmin just for the heck of it hold on
<15> the one that pays for your midget porn directing gig
<16> nope same ****
<16> any other directions
<6> take 2 pills and call me in the morning
<15> keep out of children ?
<16> :)
<15> it's a phpmyadmin question..
<15> i dunno why it's doing that
<16> na bro, somthing is f***kd up with mysql....can't figure it out, that is why my nagios can't connect either
<6> what does your nagios say
<16> Error: Could not connect to MySQL database 'nagios' on host 'localhost' using username 'nagios' and p***word 'XXXXXX' for comment data!
<6> did you upgrade mysql?
<15> and all you did was reboot ?
<16> i did a dist-upgrade but mysql was not in there
<16> and neither was nagios
<15> any firewall rules in place ?
<16> no firewalls
<16> shabbs: why do you think it has to do with a mysql upgrade?
<15> p***word incompatibility
<6> could be that your config file got overwritten and turned on skip-networking
<15> 4.0 to 4.1
<9> Say we have a parent-child relationship between two tables; generally, is it faster to look up information in the child table and use GROUP BY, then join it to the parent, or to select from the parent and join it to the child?
<9> msdfaasfdfasdsdfasfdafsda
Return to
#mysql
or
Go to some related
logs:
#sed
#mysql
inconviniet truth
#debian
#ubuntu
#math
#centos
how to install yanc42
grandfather solitaire ubuntu
#web
|
|