#mysql
10 October 2007
Total 18 pages. You are browsing page 4/18.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
07:05 <****> hmm, today's xkcd is highly sql relevant
07:05 <****> CharlieSu: I believe you can tell by doing a "show table status" and looking at the data_free column in the result
07:10 <****> progolferyo: maybe you want to use UNION instead!
07:10 <****> progolferyo: what you are doing in that thing you pasted certainly does not make any sense
07:11 <****> litheum: did you see my question above about what I am trying to do?
07:20 <****> hello
07:21 <****> how can I search in a sql db for a name ?
07:21 <****> select * from * where NAME='lion';
07:21 <****> what is wrong with this?
07:23 <****> JonkoPa: SELECT * FROM atable WHERE NAME = 'lion';
07:24 <****> the second * is where you should put the name of the table in which the records are stored
07:39 <****> I have the following SQL statement
07:39 <****> SELECT s.`nsnaam`
07:39 <****> FROM soort s
07:39 <****> WHERE nsnaam='leeuw'
07:39 <****> now I want to grab from another tabel name, how do I do that?
07:39 <****> some kind of innerjoin?
07:40 <****> hello????????
07:41 <****> ne1 help plz????
07:53 <****> How can I do this with a join or subselect?
07:53 <****> SELECT dier.rnaam, soort.nsnaam
07:53 <****> FROM dier, soort
07:53 <****> WHERE nsnaam='leeuw';
08:24 <****> http://xkcd.com/327/
08:29 <****> if any body here has ever had to open a 1GB+ text file - please tell me what program you used...
08:29 <****> it needs to be a text editor that can do regex finds as well
08:30 <****> it's *almost* on topic, as it is a text file that needs to be imported into mysql :P
08:31 <****> there is just some cleanup to do...
08:31 <****> soulfreshner: UtraEdit ?
08:31 <****> UltraEdit t hat is..
08:32 <****> can UltraEdit open such large files?
08:33 <****> worked for me
08:33 <****> vi :D
08:35 <****> cool downloading now...
08:37 <****> soulfreshner: you can configure it to not support undo-s and such, and thus improving the performance with huge files. check out the configuration pane
08:38 <****> I remember ditching ultraedit a while back for PSPad, then notepad++
08:39 <****> weird how this type of thin repeats itself
08:43 <****> Urgleflogue, ta - it seems UltraEdit does the job :)
08:46 <****> moin
08:56 <****> is it possible to do selects from diffrent databases in the same query?
08:56 <****> Yes
08:57 <****> fraggeln, yes - just prefix your collumd name with your db name
08:57 <****> soulfreshner: ie, database.table.column?
08:58 <****> select * from db.table1, db.table2
08:58 <****> where blabla
09:00 <****> fraggeln: db.tbl.col from db.tbl should work, yes
09:01 <****> soulfreshner: super, thanks.
09:08 <****> How do I get a list of active connections to a MySQL server? Google can't seem to find the answer.
09:12 <****> rjc: show processlist;
09:14 <****> hmmm... ok - it seems even ultraedit chokes if there are more than 2million lines or so...
09:14 <****> Use a better editor, like Notepad
09:16 <****> ok - so it didn't choke... it was more of a hiccup, I'm impressed
09:16 <****> andrew__, seekwill , I hope you are joking
09:16 <****> and seekwill* i hope you are joking
09:18 <****> vaq: Thanks.
09:36 <****> getting problem when downloading mysql ... i was trying to donwload like "wget wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-community-5.0.45-0.rhel4.i386.rpm/from/http://mysql.he.net/
09:36 <****> --12:36:58-- http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-community-5.0.45-0.rhel4.i386.rpm/from/http://mysql.he.net/
09:36 <****> `index.html'
09:36 <****> Resolving dev.mysql.com... failed: Temporary failure in name resolution.
09:36 <****> " ?
09:39 <****> zeeesh, ping? telnet? lynx?
09:40 <****> zeeesh, insted of wget i would suggest to use lynx and press d for download etc, the wrapper scripts almost dont return a propper package to wget
09:45 <****> How do I pre-pend some text to a column result in SQL? The following does almost what I want but I need '/var/mail/' pre-pended to the home value: SELECT maildir as home, 31 as uid, 31 as gid FROM mailbox WHERE username = 'whatever';
09:46 <****> rjc: concat
09:47 <****> soulfreshner: ultraedit rocks
09:48 <****> Urgleflogue, I wouldn't quite say that :P -- I like notepadd++ a bit better, ultraedit chokes on my regex
09:49 <****> but it's pretty decent
09:49 <****> and also not free :(
09:49 <****> sadly not free
09:50 <****> fortunately I do not use it 'coz I do not use windows :)
09:50 <****> Urgleflogue, have you tried geany?
09:50 <****> no, I do not think so
09:50 <****> Urgleflogue: Thanks. I'm not a SQL person. One thing I'm working on is a sys-admin cheat-sheet for people like me who have to run MySQL servers and need a minimum knowledge of how to do it.
09:51 <****> I don't use windows at home either - so I was looking for another scintilla editor like notpad++
09:51 <****> scite and geany are nice
09:51 <****> just googled it, looks pretty good
09:51 <****> is it superior to kate?
09:52 <****> i've never liked kate - I suppose it's a matter of taste
09:52 <****> the highlighting is the best i've seen
09:52 <****> rjc: it will look something like: SELECT concat('/var/mail',maildir) as home, 31 as uid, 31 as gid FROM mailbox WHERE username = 'whatever';
09:52 <****> rjc: I didn't test it though..
09:53 <****> soulfreshner: I will definitely try geany
09:53 <****> that's scintilla's job though so there are a few editors with the same highligting stuff - but it handles anything *I* can throw at it
09:53 <****> :)
09:54 <****> Urgleflogue: I've got it sorted out. Once you gave me the tip Google found the rest easily. The fact that you can't have a space between "CONCAT" and "(" confused me for a minute though.
09:57 <****> hmm, i like scite too... now which one should it be..
10:02 <****> good morning!
10:06 <****> morning
10:07 <****> moinmoin
10:08 <****> i begin to like mysql, im not sure, but i like it more and more *g
10:10 <****> do you want to love it long time?
10:10 <****> one question: if i add --err-log=/home/LOGS/mysql4_error.log to my startscript for safe_mysqld in mysql 4, it will not log the errors, but --log works fine. logs all querys, but if i send a query with errors, its not logged , why?
10:20 <****> Hi, I need connections from the outside to my server, is it enough to set the bind parameter to the servers ip address?
10:20 <****> or do I have to do it, over permissions set, via the GRANT PRIVILEGES command?
10:23 <****> both
10:23 <****> server must listen on ip and user have permission to connect from outside
10:25 <****> i am going to setup replication, i had previously setup replication but later disabled it
10:25 <****> Can i safely remove the mysql-bin.* files
10:28 <****> yes
10:29 <****> Biolante, thank you
Total 18 pages. You are browsing page 4/18.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last