| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> (sighs) ... with the ()
<1> vlet: that said, you may not want to select using server side prepared statements, since they byp*** the query cache
<0> oh, wow: ERROR 1005 (HY000): Can't create table './projectk_irp/#sql-359_30ca7.frm' (errno: 150)
<1> i guess it didn't like the foreign key constraint:)
<0> no kidding, yo! this is working elsewhere in site, so I guess I'm kinda stymied here... (someone else coded it)
<1> i can't see why that wouldn't work
<1> there's definitely an index on user_id?
<0> absolutely
<1> heh
<1> weird.
<2> is it (and does it need to be) unique?
<0> doesn't matter that kinda field it is? (e.g., it's a tinyint(4))
<0> no, and no...
<0> basically, it's the user_id of a user who posts a message to the site... so I need to have a lookup for his or her name, e.g., for a link to the profile
<2> the types need to be the same
<2> IIRC
<0> hmm
<2> otherwise it could overflow, etc
<1> oh sorry, i lied vlet. only 5.0+ caches the execution plan
<1> both byp*** the query cache tho
<0> ok, some progress: fields the same, but still an error
<3> And the error would be...?
<0> YEAAAHHH!!
<0> well, I dunno. But there was also an error in the original write to the DB... and that seems to make the query work ... http://www.projectkir.org/ if you're bored :-)
<3> If I'm bored, I go to naughtyhousewivesfromcuba.com
<4> si
<5> i prefer desperatehousewivesfromcuba personally
<0> oh
<0> hmm
<0> I guess I try the niche appeal...
<0> you know, that thing called radio... er... I mean, does anyone remember ... radio?
<6> whats that? can you get it on the alt.binary newsgroups
<1> cuba libre
<3> newsgroups?
<0> heh
<0> oh man.... even newsgroups are on the out-n-out :-)
<7> gopher > *
<0> haha
<1> WAIS.
<1> wait no
<1> uucp.
<8> gleam_: Hey.. you helped me with some problem yesterday. Phpmyadmin wasn't able to list the tables from some 5.0.2alpha (or something) server. Just wanted to let you know that you were right, and updating to 5.1.x fixed the problem. thanks again. :)
<7> actually, there's still a modicum of gopher around, but I think wais is dead
<7> oh, you beat me to it.
<1> wait, 5.1.x?
<1> no no no :)
<3> lol, 5.1 rocks!
<1> 5.1.x is still beta:)
<8> gleam_: Yeah... but the freebsd 5.4 port for 5.0.x is alpha and was totally broken. oh noes, and all that.
<1> weird :)
<1> shoulda just used the mysql.com fbsd binaries:)
<8> hehe. Hmm, I'll keep that in mind for next time.
<6> would be entertaining to connect to mysqld via uucp
<1> haha
<6> I was thinking that yesturday when I noticed the oreally uucp book at home
<1> yareally
<6> actually yes
<1> no wai!
<9> good night
<10> someone here good with mysql query/table structure? if you got some extra time please msg me priv... :)
<3> Why msg you priv?
<3> !tell us about ask
<11> will[werk] asked me to tell you this: Don't ask if you can ask a question or ask if anyone knows about a particular topic. Just ask your specific question, then wait to see if someone will help.
<0> gleam -- thnx again! :-)
<10> cause its nothing i wanna talk in public about
<10> about in *
<1> then don't ask for help
<1> or offer to pay
<1> :)
<2> he must be having trouble with naughtyhousewivesfromcuba.com
<10> depends how much you want :>
<1> oh, i don't want your money
<1> i only help for free
<1> or for my employer
<10> lol :)
<10> then help for free :>
<1> then ask in the channel
<2> but only if I get dolphins with lasers on their heads
<10> http://pastebin.com/733909 i was wondering if its a good or bad made db ?
<3> That's a subjective question.
<3> Does it work for you? If so, it's good!
<2> it's not the size of the DB, it's how you use it
<10> yeah... but im a new beginner, so i dont really know :)
<3> Learn from your mistakes. Then you know WHY it has to be done a certain way.
<10> maybe someoen here knows what im looking for :)
<1> oh, he doesn't want us to know he's into teh warez sc3n3.
<1> :P
<10> lol
<3> haha, yeah we kickban for that stuff.
<10> :)
<3> Seriously :)
<1> why the seemingly random mixture of myisam and innodb? why do you sometimes have an id column that's a primary key but isn't auto_increment? whydo you sometimes have a varchar as a primary key? not that you can't, but why?
<10> lol
<3> lol
<1> well, i guess on some because of hte FKs
<12> Arg, I still can't figure this out. Question. I want to pull the 10 most popular tag_name's from the tags table and sort them by name. I'm doing select count(tag_name) as matches, tag_name from tags group by tag_name order by matches desc limit 10; This returns the most popular results, which is what I want, but not in alphabetical order. Any suggestions on how to get it ordered right? I've run out of ideas
<10> yeah.... thats why im a new beginner :)
<2> s/varchar/char/gi
<2> all better
<3> gleam_, Actually, that's a good reason to use MySQL. You can choose where you need InnoDB and where you need MyISAM.
<1> well i know will
<10> id should only be auto in one table
<3> NO YOU DIDN'T!
<1> but i don't understand why he's choosing myisam on some of these
<10> since thats the main table... :>
<1> e.g. why prestats is myisam
<1> i can see why dupe would be, there's a fulltext index
<10> could change it to inodb
<10> :)
<3> :)
<2> anything you want transaction support for must be InnoDB
<1> well you don't have to, you should just make sure you need myisam
<2> if you don't care, it doesn't really matter
<13> :X
<1> also i don't see dupe referenced anywhere else except in the dupe table
<2> MyISAM can be faster for raw stats/logs, etc
<13> jeap
<10> dupe is only for the full text search
<13> isn't procedures some sort of transactions?
<10> the scripts im gonna use is gonna add to dupe table
<10> after records beein created in main table
<7> Nike shoes talk to Apple's iPod in new system
<7> uh. ok.
<14> b'uh.
<14> mysqldump --opt -A blew up on information_schema as not having access
<14> the grant was:
<14> GRANT SELECT, LOCK TABLES, SHOW DATABASES, FILE, SUPER ON *.*
<14> not seeing anything missing from the manual :(
<14> er, not having lock ability for information_schema
<15> what is a good web admin that I can set up on IIS on windows for mysql?
<16> I tried around now for hours. But it seems impossible to write out the differences in days, hours and minutes of 2 timestamps. Is there a solution? And I read the whole online documentation!
<16> This is the best I found but it returns zero: SELECT CONCAT(DAYOFYEAR(date1)-DAYOFYEAR(NOW()),' days ', DATE_FORMAT(ADDTIME("2000-00-00 00:00:00",SEC_TO_TIME(TIME_TO_SEC(date1)-TIME_TO_SEC(NOW()))),'%k hours and %i minutes')) AS time FROM time_table;
<1> what version of mysql?
<17> Is there any way to specify two specific hosts to allow a user to connect from? It seems like you can only do one host or %.
<1> two grant statements
<15> anyone know a mysql web admin for IIS?
<16> gleam_: 4-0-34
<1> mmm
<1> good luck
<16> gleam_: Sorry 4-0-24
<16> gleam_: Only possible in higher versions?
<1> well, you have timediff in 4.1
<1> and a lot of other handy functions
<16> The problem with timediff is that it gives me the differences in hours including days. Means sometimes I get back 365 hours. And datediff tells me 15 days then.
<16> But its nor working that I multiply days by 24 and subtract them. Then I get negative results sometimes...
<16> Strange that nobody had that problem. Should be very common.... When I find a solution I will write it to the developers that they can include it in the docu!
<18> Anyone have a recommendation on a book for someone who knows basic SQL commands for MySQL, but wants to start learning mroe advanved queries
<18> besides the online docs...
Return to
#mysql
or
Go to some related
logs:
delete need 2 find
dapper ericsson k300i
ubuntu mounting root file system drive appears confused
evancarroll.com
forward display RHEL 4
#linux
xfs magic number coldplug
simple semirings
teenyvids night
tslib tarball
|
|