#mysql
31 October 2007
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:34 <****> hmm what's the sql to select only rows that have a duplicated value? I don't want to only select rows with a specific value, but all rows which have the same value as at least one other row in this column.
04:34 <****> kimseong: it works but you have to refresh to show it removed from the previous table.. how can i send a refresh after each time its moved
04:35 <****> hey anyone interested in making money online?
04:35 <****> GENTOODUDE: moves? that copies
04:36 <****> kamue: pfft, that is sooo bourgeois
04:36 <****> well, i would like to talk about business
04:36 <****> any biz channels on this server?
04:36 <****> guid3r: psh. mysql doesn't have blue screens of death!
04:36 * guid3r looks up "bourgeois"
04:36 * guid3r blushes
04:37 <****> ToeBee, don't get me started!
04:37 <****> kimseong: i dont want it to copy, how can i move?
04:38 <****> hey, mysql handled almost 2 billion queries before some bonehead in the data center pulled the plug on my server. When windows can do *anything* 2 billion times I will be impressed :p
04:40 <****> nobody wants to make money here?
04:41 <****> hello HELPPP - I dont know what has happened and I am a newbie - I am trying to look at the database and I am getting an error that I really am afraid of MySQL is telling me that the table is "marked as crashed and should be repaired"
04:41 <****> what do I do please help
04:41 <****> 1); but I want to display all the rows which are duplicated, not just one of the duplicates. How should I change the SQL?
04:43 <****> anyone want to help me here please is there something that will fix this?
04:43 <****> klotho: would count(email) be 0 ?
04:44 <****> SiliconG: repair
04:44 <****> 1);
04:44 <****> how?
04:44 <****> !m SiliconG repair table
04:44 <****> SiliconG: (REPAIR TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/repair-table.html
04:44 <****> what I want is wherever there's two or more rows with the same email, to display all those rows, and not to display any rows that don't have a duplicate email
04:45 <****> this statement is just displaying one of each of the sets which have duplicates
04:45 <****> klotho: if you have multiple rows with email = NULL, you want to see it?
04:45 <****> no, I don't have any of those
04:46 <****> what if 1 day it have
04:46 <****> I have many rows with unique emails and some with emails the same as some others
04:46 <****> so I want to select all those rows which have an email the same as some other row
04:47 <****> this is just a little ad-hoc extraction, not an application!
04:47 <****> klotho: self join
04:47 <****> hmm... any examples for that kimseong?
04:47 <****> from table1 a join table1 b
04:47 <****> hi all, can somebody what is the syntax for having a new user for some database? With all rights
04:47 <****> !m shirish grant
04:47 <****> shirish: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
04:48 <****> shirish: grant all on db.* to username@localhost identified by 'password'
04:48 <****> no
04:48 <****> Hi! I need to insert values into a view that is based on several joined tables. How do I do it? Is there an equivalent of SQL Server's "INSTEAD OF INSERT"? Thank you.
04:48 <****> create view
04:48 <****> kimseong: hmm... I think I get the general idea but not sure how to do it specifically...
04:49 <****> klotho: subquery is easier to understand if you want that
04:49 <****> okay, how about that one then?
04:50 <****> klotho: where email in (select email from your statement just now)
04:50 <****> kimseong: I may be slow, but I'm not getting it...
04:51 <****> kimseong: I ran "$mysqlcheck -u admin -p nhmc_dev"
04:51 <****> and it said eveything was ok
04:52 <****> then what says need to repair?
04:52 <****> if I change to the db in question
04:52 <****> SHOW INDEX FROM jos_wrk_frm;
04:52 <****> ERROR 145 (HY000): Table './nhmc_dev/jos_wrk_frm' is marked as crashed and should be repaired
04:53 <****> I have never seen this before
04:53 <****> SiliconG: innodb ?
04:54 <****> I dont know what that means my friend - I am a newbie - if there is away to check I will and then tell you - but I will say there is nothing about that in my.cnf
04:54 <****> kimseong: I did a self-join but it gives me duplicates
04:54 <****> someone please msg me to talk about ecommerce
04:55 <****> SiliconG: try check table jos_wrk_frm;
04:55 <****> kimseong: based on what I have just read I really hope that it is innoDB
04:56 <****> kamue: no?
04:56 <****> why not?
04:56 <****> $check table jos_wrk_frm; - worked fine
04:56 <****> if you have a question, ask it here
04:57 <****> kimseong: what does that mean?
04:57 <****> I have a question; when is it the US will invade Iran?
04:57 <****> jsoftw: it already happened
04:58 <****> thumbs: eh?
04:58 <****> not $
04:59 <****> ok
04:59 <****> b.order_date; but it creates duplicate records... how would I eliminate that problem?
04:59 <****> in mysql "not equals" is != ?
04:59 <****>, Shai_Tan
04:59 <****> ahh, thanks
04:59 <****> I find it's more portable
04:59 <****> != also can
05:00 <****> check table jos_wrk_frm; - that worked so what does that mean?
05:00 <****> SiliconG: work?
05:00 <****> SiliconG: show create table jos_wrk_frm;
05:00 <****> check table jos_wrk_frm;
05:00 <****> +----------------------+-------+----------+----------------------------------------------------------------------------+
05:00 <****> | Table | Op | Msg_type | Msg_text |
05:00 <****> +----------------------+-------+----------+----------------------------------------------------------------------------+
05:00 <****> | nhmc_dev.jos_wrk_frm | check | error | Table './nhmc_dev/jos_wrk_frm' is marked as crashed and should be repaired |
05:00 <****> SiliconG: see what engine at the end
05:00 <****> +----------------------+-------+----------+----------------------------------------------------------------------------+
05:00 <****> 1 row in set (0.00 sec)
05:01 <****> SiliconG: don;t do this again
05:01 <****> SiliconG: got error you said ok
05:01 <****> sorry
05:01 <****> repair it
05:05 <****> how do I see if other things need to be repaired? I ran mysqlcheck -u admin -p nhmc_dev and it gave me OK on all tables please advise.
05:08 <****> thumbs
05:08 <****> chadmaynard
05:09 <****> thumbs: how are you?
05:09 <****> chadmaynard: not so good.
05:10 <****> thumbs: why is that?
05:10 <****> because I work 20 hours a day
05:10 <****> wtf.
05:10 <****> why?
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last