| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
<sunshine82> ericb
<sunshine82> that sudo kill sudo cat isnt workin
<Niklas_E> shouldn't the jodbc driver 3.0 and 3.1 work with openoffice2?
<sunshine82> does anyone know how to reset the root p***word
<Squee> any ideas why this doesn't work correctly... i'm trying to delete users that ahven't activated within 30 mins.... DELETE FROM cnut_phpbb.phpbb_users WHERE ((user_active='0') AND (user_regdate > (user_regdate + 108000)))
<vinicius_> Squee: it looks well, copy and paste the error message
<litheum> Squee: how could user_regdate ever be greater than itself + any constant?
<litheum> that's like writing WHERE a = a + 1
<litheum> which is like writing WHERE 1 = 1 + 1
<litheum> which is obviously insane
<Squee> ha that's a good question.. well the problem was before it delted them right away and i messeged with the signs...
<vinicius_> Squee: fully in agree, it must be some like DELETE FROM cnut_phpbb.phpbb_users WHERE user_active='0' AND (user_xxxdate > (user_regdate + 108000));
<litheum> that also makes no sense
<vinicius_> not at alla, in my mind i guess XD
<vinicius_> s/alla/all
<litheum> what about user_regdate > NOW() - 108000
<rhyek> some way i can make this work?: select COUNT(`visits`.*) from `visits`
<Squee> um.. i'll try your way litheum because this doesn't work either DELETE FROM cnut_phpbb.phpbb_users WHERE ((user_active='0') AND (user_regdate < (user_regdate + 108000)))
<rhyek> i need the COUNT(`visits`.*) for another query i'm making
<rhyek> i can't just do a COUNT(*) because i'm working with two tables...
<litheum> Squee: user_regdate + 108000 will always be great than user_regdate! does that not make sense to you?
<Squee> nope user_regdate > ($CurrentTime - 108000)) doesn'tw ork either this deltes them right away
<Kinkew> okay, no one answered earlier and there are people talking now, so I'll ask again...
<Kinkew> is there any way to lock an entire database (ie. all tables within the database) without actually doing a LOCK TABLES on every table?
<Fleck> hi all, i have problem, i upgraded from 4.0 to 4.1 (was utf8 in latin1) and now there are wrong chars displaying, how can i convert ALL DB to UTF8 now? (i found how to convert 1 column, but i have many columns :( )
<litheum> rhyek: but you're joining them together, so they turn into one table...
<litheum> Kinkew: no i don't think so
<Kinkew> okay, didn't look like it
<litheum> Fleck: did you read the upgrade notes?
<Fleck> litheum yep
<Squee> sorry i was working on this last nigth at 3am with someone and was falling alseep while doing it
<rhyek> litheum: hm, maybe. check this out: select `prospid`, `companyname`, COUNT(`visits`.*) from `prospects`, `visits` where `listid` in (14,13) and `prospects`.`prospid` = `visits`.`prospid`
<Kinkew> I wish I could at least lock a list of tables without specifying READ or WRITE for each individual one..seeing as how I want to lock them all for WRITE anyhow.. or is there a way to do this?
<rhyek> i'm trying to get the id and company name, plus the number of visits this prospect has made to a certain site
<rhyek> and there are several lists of prospects, that's why the `listid` in (14,13) is there
<Squee> ok so far this doesn't delete them right away so i'll have to wait a half hour user_regdate < ($CurrentTime - 108000)
<ducky_> what is the best way to delete data from a members table mapped to an address table?
<litheum> rhyek: you will want to use GROUP BY and then probably COUNT(visits.id) or some other column in visits
<rhyek> hm, brb.
<litheum> ducky_: what are you trying to delete? members or addresses?
<ducky_> I basically need to delete all records in members where the member_id = x and from members_addresses_map where member_id = x and from addresses where address_id = x (where you need to get x from the map table).
<rhyek> litheum: it works, thanks ;)
<rhyek> this is what i did btw: select `prospects`.`prospid`, `companyname`, COUNT(`visits`.`prospid`) from `prospects`, `visits` where `listid` in (14) and `prospects`.`prospid` = `visits`.`prospid` group by `visits`.`prospid`
<sunshine82> does anyone know hjow to reset the root p***word
<litheum> rhyek: you should probably group by company ID or something, not by visits.prospid.....
<litheum> !m sunshine82 reset root
<SQL> sunshine82: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<litheum> sunshine82: please look in the manual before asking
<rhyek> company id is the equivalent to prospid in this matter
<sunshine82> sql im on that website im stuck on the kill cat.... command
<ducky_> does something like this look right, "DELETE FROM `addresses_members_map` AS amm, `addresses` AS a WHERE a.address_id = amm.address_id AND amm.member_id = '$member_id'";
<Fleck> litheum so?
<Fleck> can you help me?
<spitalfie> hi, i've been trying to get this query to work for about 4 hours now, and just realized that my host is running 4.022, when i thought 4.1 was in place... anyone skilled at rewriting a subquery so it will work with 4.022?
<spitalfie> its located at http://hashmysql.org/paste/viewentry.php?id=885
<spitalfie> i'm really stumped here..
<spitalfie> anyone?
<Fleck> help please? i'm stuck :(
<Fleck> dunno what to do with my DB now
<Kinkew> fleck, just ask your question.
<Fleck> i upgraded from 4.0 to 4.1 (was utf8 in latin1) and now there are wrong chars displaying, how can i convert ALL DB to UTF8 now? (i found how to convert 1 column, but i have many columns :( )
<Fleck> and i have many tables :(
<Compy> In mysql, is there currently any way to make an update statement INSERT it if it doesn't exist?
<Compy> it being the data im wanting to update.
<Compy> nm
<CPUnerd_> Darien, tmrw 2h00 cine express ? :-)
<Darien> 2h00? nor 12h00?
<CPUnerd_> was a surprise ;-)
<CPUnerd_> 12h00 cine
<CPUnerd_> hehe
<litheum> !m Compy replace
<SQL> Compy: (REPLACE Syntax) : http://dev.mysql.com/doc/mysql/en/REPLACE.html
<Compy> yeah, found it.
<litheum> yay.
<ducky_> where could I find the documentation for mysql 3.2
<ducky_> ?
<Judge--> is it possible to use a filed in my table for a bitflag system? What should be the type?
<ducky_> I think I have mysql 3.2 and that's why my query isn't working... DELETE amm, a FROM addresses_members_map AS amm, addresses AS a WHERE a.address_id = amm.address_id AND amm.member_id = '891'
<Norbert> is it possible to do a REPLACE with only the first occurance?
<Darien> LIMIT 1
<Norbert> no, that's not working
<Norbert> sorry, what I mean is, replace only the first occurance in a string
<Darien> oh
<Darien> you mean a REPLACE()
<Norbert> yeah
<Norbert> I'm trying to replace only the first "ss" to "s" in "it iss less"
<Norbert> (simplified example)
<will> Why don't you show the real problem?
<Darien> CPUnerd_: I learned how to play backgammon
<Norbert> will: the text is too large
<Norbert> will: anyway, if you could help me, the example would be sufficient
<XLNC> is it possible for SCO to sue MySQL users? In the SCO press release they have said the money they have given is only to fund dev work for a commercial version for them
<XLNC> http://ir.sco.com/ReleaseDetail.cfm?ReleaseID=172037
<MHillyer> It is possible for SCO to sue my babysitter, that does not mean they will.
<Squee> why doesn't this statment work correctly... trying to delete users who haven't confirmed their account within 30mins DELETE FROM cnut_phpbb.phpbb_users WHERE ((user_active='0') AND (user_regdate < ($CurrentTime - 108000)))
<XLNC> well they have a past record of suing users of software who they funded development work for
<MHillyer> And? You worried you will get sued?
<XLNC> yes
<nicksoft____> can anyone tell me a search engine like shpinx?
<nicksoft____> 10x
<XLNC> I am thinking of migrating to postgresql
<MHillyer> Ok, postgres is good.
<MHillyer> But I would find a better reason than 'SCO might sue me'
<MHillyer> If that is your reason you better make sure you use Postgres on Windows.
<Norbert> is there any frontend which allows me to edit remote mysql tables? mysql administrator can do a lot, but it does not show any data
<ducky_> I'm getting, ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<MHillyer> Norbert: Try MySQL Query Browser.
<ducky_> when I try to run mysql
<MHillyer> ducky_: Is the server running?
<Norbert> MHillyer: ok, i'll look it up
<ducky_> Mhillyer: no
<MHillyer> ducky_: Can't connect to a non-running server.
<ducky_> Timeout error occurred trying to start MySQL Daemon.
<MHillyer> How did you try to start it?
<ducky_> /etc/init.d/mysqld start
<joce> Hi, I'll ask the same question than yesterday, perhaps someone will answer me :) I have a UNIQUE KEY on (A,B) and a UNIQUE KEY on (B). I know A and B values (let's say id1 and id2) which will return the line I want. What is the most efficient, doing the query on A=id1 AND B=id2, or B=id2 only ?
<Norbert> MHillyer: thanks, that looks cool
<MHillyer> joce: The AND query
<Squee> any idea on how to select a user who has the most points...
<ducky_> Mhillyer: got it going
<ducky_> man that was a close one
<joce> MHillyer> My next question is : why ? :)
<MHillyer> Squee: SELECT user_with_most_points();
<dodgyville> Hello
<ducky_> tried upgrading to 4.1 and almost hosed my DB!!
<dodgyville> How can I tell if my apache2 has functioning mysql support?
<MHillyer> joce: Because it will use both parts of the A,B key to get what it wants.
<MHillyer> dodgyville: Apache does not use MySQL.
<joce> MHillyer> I have also an UNIQUE index on (B) :)
<MHillyer> Yes, well what do you want? A = X and B = Y or just B = Y?
<joce> MHillyer> both will return the same result
<joce> (in my case)
<ducky_> Is there a way to make a query like, DELETE FROM addresses_members_map AS amm, addresses AS a WHERE a.address_id = amm.address_id AND amm.member_id = '$member_id' work in MySQL 3.2?
<MHillyer> Well then why have an index on A at all.
<joce> because I know if I give A=X, the X will be the valid so that the query returns the result
<MHillyer> If all you care about is B then there is no AND.
<MHillyer> The indexes server different purposes. If you care about A then specify A, if you care about B then specify B.
<joce> MHillyer> It depends on my query, sometimes I have A only
<MHillyer> Then specify A when A matters.
<joce> It was more a performance question about which is faster between a query on a UNIQUE compound index and a UNIQUE normal index. Perhaps it's the same
<ME2> hey
<ME2> im new with using LIMIT with mysql
<MHillyer> joce: It is the same if it is UNIQUE(a) and UNIQUE(a,B).
<ME2> like LIMIT x , y means start from 'row' x and give me y resulsts?
<MHillyer> Anyway, I gotta go. Night everyone, remember to tip your waitress.
<joce> MHillyer> ok thanks
<ducky_> Anyone have any idea on my delete question?
<ducky_> can you do delete joins in mysql 3.2?
<CPUnerd_> Darien, really ?!
<CPUnerd_> i'm not screwing my ramadan tomorow though :-)
Return to mysql
or
Go to some related
logs:
beginner
ERROR 1049 (42000): Unknown database
wow Pandaren
|
|