| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> that looks more positive lol
<1> listening now!
<0> its working
<0> thank you guys
<0> u guys are great
<0> thought it was something simple
<0> hope i wasnt too much trouble ;)
<0> lastly, could someone explain the whole bind thing? Any what it is for?
<1> bind mysql to one specific port
<2> I have a select which selects from multiple tables and compares several fields....two tables goes fine but 3 tables makes wreck...will a index help me out?
<1> index on each table where the joins are
<1> and use explain
<0> ok makes perfect sense guys
<0> thanx and bye ;)
<2> tnx archivist - didn't know explain from before
<2> nice tool
<3> hi. who knows how to p*** arguments for mysqld_safe to mysqld_multi?
<3> no answer?
<4> No me ?
<4> er, not me
<2> How do I specify to use a key?
<2> I've made indexes for the fields of interest
<2> Is it uneccesary to mention the index in the select query?
<1> key=index
<1> only need to mention index if explain shows its using the wrong one
<2> explain says the right "possible_keys", but key = NULL
<5> Hi!
<5> Is it possible to have a date field have the default of current-date?
<1> timestamp type
<5> archivist: only for timestamps?
<6> instruction Google Adsense--> http://planet.nana.co.il/hartk2003/en.htm Download free Firefox --> http://planet.nana.co.il/hartk2003/Firefox.htm
<7> Does anyone know anything about using my database to store emails from the MTA ?
<4> Motor Trades ***ociation?
<4> :-)
<5> the are some howtos in the gentoo wiki
<5> Is it possible to have a date field have the default of current-date?
<8> pCarsten: can you guys read the stuff people write in the comments in the beta exam?
<8> just wondering if i should bother writing in comments when i take dev II :)
<9> lsmith: aboslutely.
<8> as i did in dev I
<9> thanks!
<8> ah ok cool
<8> i had plenty of time during the exam
<8> had to guess a few though
<9> all comments are very much appreciated and taken into account
<8> and the monitor died during the exam
<9> oops
<9> for how long?
<8> took them 5 mins to hook up a new one
<8> though the new one was flickering too
<9> was it reported?
<8> i presume the video card was broken
<8> reported?
<8> i was just happy that the computer didnt die
<9> it should have been reported upstream that you lost 5 minutes of exam time
<9> or did they give you extra time?
<8> ah .. i dont think .. but i was done almost an hour early
<9> ok ... as long as you're sure it didn't affect you in any way
<8> yeah .. i think dev II will probably be a bit tricker
<8> trickier
<8> pCarsten: i wonder where those odd errata items came from
<9> you mean the ones where you can see discussion? :-)
<8> the one from page 308 and 311
<9> oh
<8> ah that reminds me ..
<8> while doing the test questions
<8> i noticed that for some true-false/multiple choice style questions the answers did not provide the proper selection
<8> only an explanation
<8> which was kind of annoying, because when i was doing the questions i only wrote down "true" or "d)"
<8> and then i had to flipp back to the question to see if i got it right
<8> generally the questions seemed to lack some "love"
<8> some were 100% repetitions of previous questions too
<8> seemed more like a dumping ground ..
<8> but they were still helpful
<8> overall
<9> we have this position as a certification exam writer open you know ...
<9> :)
<10> hello
<2> arf...I have a where a.hash = b.hash - both tables have a index on `hash` - why isn't the key used in my query?
<9> lsmith: thanks for the feedback - I'll make sure to look into this
<11> I have a view in mysql but created with I can't remember what program ! now I can't remove it within mysql prompt or phpmyadmin
<10> I have found a bug in the mysql server, I'm not sure if it's reported but maybe there ise some kind of workaruond for my sql query
<10> when I tried to execute it server is hanged at "Copying to tmp table" message
<9> grxmrx: report the bug on bugs.mysql.com -- better five reports too many than one too few
<10> pCarsten: ok
<8> grxmrx: well you may want to search the bug database before
<8> maybe someone solved the issue already .. or has some hint
<10> my query works fine with INNER JOIN but it doesn't work with LEFT JOIN
<10> RIGHT JOIN works too
<8> heh
<8> could be some buffer setting?
<10> lsmith: I have found simillar bug
<8> something overflowing
<10> SELECT posts.*, COUNT(comments.comment_post_ID) AS sum_of_comments FROM posts LEFT JOIN comments ON posts.ID = comments.comment_post_ID WHERE 1=1 AND post_date < NOW() AND post_category > 0 GROUP BY comments.comment_post_ID ORDER BY post_date DESC LIMIT 15
<10> this is my sql query ;)
<8> which related bug did you find?
<10> I'm asking here because maybe you know workaround for this :] I know that probably it is mysql server bug that is already reported
<10> lsmith: http://forums.mysql.com/read.php?24,39066,39066#msg-39066
<10> http://bugs.mysql.com/bug.php?id=14070
<2> Can somebody please help me on this: I have "SELECT 1 FROM table1 AS a, table2 AS b WHERE a.hash = b.hash" I have a index on `hash` on both tables. Why isn't the index used in my query?
<2> Explain says possible keys are hash, but it is not used.
<12> i finally found that, call "set names 'utf8'" before any php query statements which can solve any charset convert problem.
<8> sounds tricky
<13> hi
<13> how can I get mysql to use a xml file (dump of wikipedia) i don't want to make another file
<14> is Message a reserved name that cannot be used as a mysql field name? I keep getting the error "field Message does not exist" but when I DESCRIBE my table I see that its there, of type TEXT
<8> [fields]: you would get a syntax error then
<13> (not able to give a good answer but...) probably not
<13> try chaning the name of it to message2 if it works change it to message
<13> however when you chagne it to message2 or anything
<8> paste bin describe and your query
<13> it will probably still have an error
<15> I have migrated my website from the server which is using Mysql 4.0 to a server with mysql 3.23.58. Now i facing problems with charset on my index page. Any idea??
<13> upgrade?
<14> pastebin: http://pastebin.com/641935
<15> Is there anyway to fix this issue without upgradation?
<13> yeah probably but I am not the person to ask
<16> mysqlhotcopy: I want to use this to get a copy of all db files and then rsync them to another
<16> server
<16> does this sound practical?
<14> zz1: I'm not the guy to ask either, but are you referring to your Collation Language?
<14> oh I see my error in Pastebin
<14> table names don't match...
<8> DESCRIBE ANSELLLEAD_LT_Quarantine_Log;
<8> INSERT INTO ANSELLLEAD
<17> since when is BOOL available? only 4.x?
<18> 5.0 I think
<17> ahh oke, that explains alot
<17> so i have another question, what is the difference between tinyint(1) and tinyint(2) for example?
<19> D:\>mysql -u root -p -e "use evolvingdatabase; LOAD DATA INFILE 'd:/products.sql' INTO TABLE products FIELDS TERMINATED
<19> BY ',' FIELDS ENCLOSED BY '"';"
<19> Enter p***word: *************
<19> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv
<19> er version for the right syntax to use near 'FIELDS ENCLOSED BY ''' at line 1
<17> wtf
<19> anybody? :/
<19> ms dos is a nightmare
<19> its soooo outcl***ed and primitive
<17> quote problem
<19> yeah, what do i do? :/
<19> i tried escaping it \
<17> try
<19> but no
<17> ah
<17> was about to suggest that
<19> msdos is a little bastard ;/
<17> what if you do something like set quote=" and then use %quote% ?
<20> Hi
<17> hi
<20> I have one issue
<20> I have migrated my website from the server which is using Mysql 4.0 to a server with mysql 3.23.58. Now i facing problems with charset on my index page. Any idea??
Return to
#mysql
or
Go to some related
logs:
wav.slicer
#lgp
gentoo drm Mobility M6 LY.
#math
#python
#gentoo
yumdownloader krb5
#web
Cannot MOUNTPROG RPC: RPC: Port mapper failure - RPC: Unable to receive
#javascript
|
|