| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> !tell us about joins
<1> will[werk] asked me to tell you this: Very basic join information: http://hashmysql.org/index.php?title=Introduction_to_Joins - For more indepth info: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
<2> Hehe very quick with that will. :)
<2> Oh wow a mysql wiki. Nice.
<0> I have a blackbelt in bot-fu
<2> Lol.
<2> Fear will.
<0> hi ya!
<3> hi all
<4> http://bugs.mysql.com/bug.php?id=16553 we need
<4> ;)~
<3> anybody on windows?
<4> yeah
<3> please anybody check me this with ie: http://syschat.hu/proba.html
<0> Window users will be banned.
<3> please check the smile's background
<3> is it transparent?
<5> windows? are there people on freenode who actually use windows??
<3> will[werk]: good idea
<4> MetaMorfoziS eh which smiley?
<6> Could anyone give me a quick hand to figure out if I understand MySQLs index useage correctly?
<6> I have an ID that's almost unique, but not entirely. I need to store it, because I'll be running queries against it. Large number of rows, so I need an index to make retrival fast. I do however also want an entirely unique ID. Would it make sense to add one column for the first ID, then augment that with more randomness in a second column, and create a single index for both of them? (usuallyUnique, alwaysUnique)?
<3> jax, http://metamorfozis.hu/p/biztosvoltam.png
<4> MetaMorfoziS give me the link to the png
<3> but in linux, i think the wine based explorer's png trasparency isn't supported
<3> http://e107.org/e107_images/emotes/MSN_Crystal/dunno.png
<4> well IE opens it in quicktime :D
<3> don't care:)
<2> Xgc: Wow that query is so much more elegant. Thanks for that. I love it.
<3> quicktime?:DD
<3> lol.
<4> works in FF, but not in IE
<4> IE->black
<3> lol
<3> ie's alphalayer support is a big big ****
<7> mmkay
<3> thank you
<7> http://pastebin.com/654354
<3> :)
<4> this Design by Contract stuff is killing me >;/
<3> fcuk fcukfcuk
<8> can anyone help me please? i need to "uninstall" mysql from my mac, i don't know how
<3> Jax it's a only a probe
<7> It seems as though, if I do run the %va_% search, then every following query that involves a wildcard in the beginning runs considerably faster
<0> Nathalas, Could be because MySQL cached all the data. Bad thing to use % in front though.
<3> ie fcuk.
<0> MetaMorfoziS, Calm down.
<7> I know, but there must be a way
<7> cant you for example reverse the indices somehow?
<0> Nathalas, What are you doing?
<7> so they work the other way? :o
<0> heh
<7> Letting people search a list of albums, they need to be able to search like %busta%rhymes% without it having to take 5 minutes
<0> Nathalas, Use a full text index.
<9> fulltext searching
<0> Either MySQL's or look up lucerne
<7> now I've let it run through with %VA_%, %VA-% took 1.4s
<7> so maybe an alternative solution is just to let it run through that once when I boot up
<2> Weird though. The old query was faster it seems marginally :(
<10> uh no
<10> you can't count on the caching like that
<10> a bad query is still a bad query
<7> Ack.
<10> all you've done is gotten the OS to cache the entire table in memory
<10> if you want that, put in in a ENGINE=MEMORY table
<10> then, wait to run out of memory :)
<0> How about just index it properly? :)
<8> can anyone help me please? i need to "uninstall" mysql from my mac, i don't know how
<10> LIKE % no usey no indexy
<7> if I use fulltext indices I need to restructure my queryes ;oP
<0> sjrussel, Fulltext :)
<7> queries*
<0> Nathalas, Start rewriting.
<7> You're killing me here.
<10> gentlement, start your editors
<0> Should have done it right the first time.
<7> Cant win every time
<0> sjrussel, .....
<10> ... unless you're Chuck Norris ?
<0> Who?
<3> anybody know a normal smile pack?
<3> that alphalayer works on ie?:)
<0> MetaMorfoziS, Ask in #web
<10> use GIF
<3> :))
<10> and get some treadmill time, you've got a double-chin growing there
<0> Are you calling me fat?
<10> pretty soon will won't find you attractive anymore
<10> no. Just shapely
<0> When did you?
<0> You mean, I'm attractive now?
<10> ???
<10> are you channelling MetaMorfoziS?
<0> I'll channel him out of here!
<3> what?
<11> Nathalas: Your reference to queries beginning with '*' or not was why your original comments didn't add up.
<3> if you think to /amsg no:)
<0> amsg?
<7> Used to * being wildcard ;oP
<7> didnt realize my mistake til you brought it up.
<0> % looks like a better wildcard.
<7> I dont really care about how it looks :P
<0> oh
<10> that's too bad. Things that work well usually look better
<0> Things that look better usually work well.
<0> Reading up on HEAP/Memory tables. Manual says "Deleted rows are put in a linked list...". What does that mean?
<0> Deleted rows are tagged deleted?
<10> it means the memory isn't freed
<10> and it's reused on the next insert
<10> MyISAM does the same thing
<0> Is there a way for it to free it? Since it doesn't seem to want to OPTIMIZE.
<10> is it wasting alot of space?
<2> Is there a quick way of dropping all stored procedures for a database?
<0> Well, I'm doing testing, so putting in several MB of data in it.
<0> Ah, I can only truncate.
<0> Interesting. "MEMORY tables use a fixed-length row storage format." From manual. "session_header HEAP Dynamic" from show table status....
<10> I think it's not true anymore
<0> Must not be.. but I'm running 4.1.16
<12> is there a way to specify a blank p***word at the command line
<12> mysql -uroot -p''
<12> will ask me for a p***word.
<11> jjb_lyceum: Blank represents no p***word.
<11> jjb_lyceum: Don't specify the -p option.
<13> don't put -p
<13> eheh
<0> Don't specify the -p option.
<12> presto!
<12> thanks...
<11> jjb_lyceum: Really. Just say no to p***words.
<12> overall?
<0> heh
<14> hello
<14> is the date field in mysql m/d/y?
<0> Y-M-D
<0> !m adamc date type
<1> adamc: (Column Type Storage Requirements) : http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
<14> how can I change this?
<0> You don't.
<14> hmm
<15> !m adamc date time functions
<1> adamc: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<15> adamc: see to_date, iirc
<3> adamc
<3> the easiest way if you use uunix timestamp
<3> time()
Return to
#mysql
or
Go to some related
logs:
stopping apache instances
845GM Fedora
#python
ubuntu what is build essential
wiki scrot 1024x768
#oe
k3b burn daa
Error fsck.ntfs
intel brookdal
#oe
|
|
