#mysql
29 September 2007
Total 14 pages. You are browsing page 1/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sat Sep 29 00:00:06 2007
--- Day changed Sat Sep 29 2007
00:00 <****> ki77a77: i don't think that would work for an order by
00:00 <****> oh.. nevermind.. it would
00:00 <****> DDustin: indeed.
00:00 <****> but not exactly how you'd want it to
00:12 <****> is there a function to take a result set and 'join' it into a newline delimited list?
00:13 <****> !man group_concat
00:13 <****> see http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
00:16 <****> sick, thanks archivist
00:21 <****> can i put newlines into single quote strings?
00:21 <****> yes
00:21 <****> SEPARATOR '\n' <- will this work?
00:21 <****> no
00:22 <****> nils_: now i'm just conufsed DX
00:22 <****> DDustin: just use a real newline
00:22 <****> oh okay great idea
00:22 <****> oh hey... i actually was using a real newline w/o realizing it
00:22 <****> \n gets escaped to a newline
00:22 <****> I know
00:22 <****> cool.
00:22 <****> i mean, php will escape it for me
00:23 <****> yes, it does
00:23 <****> which is cool, i accidentaly did the right thing
00:23 <****> php++
00:23 <****> karma php
00:23 <****> I have with a karma of
00:23 <****> the_wench: screw you, bitch
00:23 <****> the_wench: karma php rocks
00:24 <****> shes this query is getting pretty bizzare
00:24 <****> two selects on the same table inside of an insert
00:25 <****> sounds like a broken schema
00:26 <****> its still leaps and bounds better then other ones i've seen to do the same thing o_O
00:27 <****> piles of concated numbers in fields is often broken
00:27 <****> i think its just my requirments that are demanding
00:27 <****> I was wondering if someone might be able to assist me with a small grant problem
00:27 <****> and attempting to solve them with SQL results in some bizzare stuff
00:28 <****> Marticus: grant? what are you from nigeria?
00:28 <****> for some reason, I am unable to get rid of ' GRANT USAGE ON *.* TO ... '
00:28 <****> DDustin: nice :)
00:28 <****> hi, i have a mysql dump that i need import onto another machine but i don't know if the import will create the database, or if i need to create it manually before importing this .sql file
00:28 <****> if you can connect then you have usage
00:29 <****> so anyway, I think I need to revoke that... but I don't really know
00:29 <****> I don't like seeing it
00:31 <****> hey sey i have a column with hard drive capacities, the values will be something like 100GB, 60GB, etc, is there some way where I can strip off that GB and select rows where the capacity is between 20GB-40GB etc?
00:31 <****> whoops sey=say
00:31 <****> nevermind, I got it
00:32 <****> why would the embedded browser work if I launch eclipse from a terminal, but not from the window manager?
00:32 <****> cyth you got a virus
00:33 <****> NemesisD, use a bigint/int ,store GB in another field
00:33 <****> oops wrong chan
00:33 <****> and DDustin i doubt
00:33 <****> cyth it t'was a joke
00:33 <****> wrench: there is probably a line in the .sql that says something like 'create database if not exist'. Look with some text editor.
00:34 <****> DDustin, I would more likely think I have a problem with some sort of wierd scopping environment variable issues
00:38 <****> NemesisD: why ditch the GB? '...where col between 20GB and 40GB' ?
00:38 <****> ki77a77, is mysql smart enough to do that?
00:39 <****> NemesisD: of course, you're using text, so you'll have problems with 1, 2 and 3 digit comparisons
00:39 <****> mysqldump is a safe way to create a db backup?
00:39 <****> yes
00:39 <****> what its for
00:39 <****> right?
00:40 <****> NemesisD: even if you strip off the GB
00:40 <****> holy crap, mysql is smart
00:40 <****> it worked, thanks ki77a77
00:41 <****> that was strange
00:42 <****> my wrench- session got disconnected :(
00:42 <****> did you see my reply about the "Database" line?
00:43 <****> it doesn't explicitly say "create" anywhere in there, so i am thinking that i need to manually create the database first
00:43 <****> wrench--: if you're speaking to me, no, I did not.
00:43 <****> thought i'd ask you folks tho
00:43 <****> wrench--: go ahead, it won't hurt in any event.
00:45 <****> ok
00:45 <****> thanks for the help :)
00:53 <****> I am having problems with my MySQL server. MySQL use to work but now it was not running. When I tried to load it by "sudo /etc/init.d/mysql start" it fails. If I do "sudo mysqld &" it will load. I am not sure what is wrong. Can anyone help?
00:55 <****> Check your log
00:56 <****> seekwill: the log is empty
00:56 <****> Path to your logfile?
00:56 <****> /var/log/mysql.log and /var/log/mysql.err
00:57 <****> Distro? bsd?
00:57 <****> seekwill: Ubuntu Fiesty Desktop
00:57 <****> /var/log/daemon.log
00:57 <****> When you run mysqld &, can you connect?
00:57 <****> try that
00:58 <****> seekwill: yes that will connect.
00:58 <****> I'm going to get really drunk now
00:58 <****> nils_: Let me join you!
00:58 <****> seekwill: alright, can you come to St. Pauli?
00:58 <****> !wench beer nils_
00:58 <****> Here nils_ have a cool beer
00:58 <****> nils_: Sure!
00:59 <****> nils_: Let's meet somewhere half way though.
00:59 <****> So I can get a round trip ticket
00:59 <****> seekwill: that would be... atlantic ocean?
00:59 <****> nils_: Have a boat?
00:59 <****> I sure do
00:59 <****> Meet there then. I'll parachute on
00:59 <****> alright
01:00 <****> it's the boat that says "I'm not stolen" on the flag.
01:00 <****> ok
Total 14 pages. You are browsing page 1/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last