#mysql
03 October 2007
Total 31 pages. You are browsing page 3/31.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:51 <****> I thought ENUM was SQL69 or something.
01:53 <****> I'll show you what SQL69 is
01:54 <****> gfhghgfhfg: the mysql enum is neither standard nor portable
01:54 <****> :(
01:54 <****> Dammit.
01:54 <****> How do they hold ENUMs in other databases?
01:54 <****> Paper and pen?
01:55 <****> What were they thinking?
01:55 <****> I HAVE A QUESTION
01:55 <****> as a varchar with check constraints would be sql standard
01:55 <****> CAN SOME1 HELP ME?
01:55 <****> or an int if that applied
01:55 <****> seekwill: Huh?
01:55 <****> why are there no google search results for sql69 in english? wth is sql69?
01:55 <****> gfhghgfhfg: I have sql problem. can u help?
01:55 <****> I meant the first SQL standard. I seem to recall it being 69. Maybe wrong.
01:56 <****> seekwill: Why are you acting like that?
01:56 <****> sql69 is the DBA position
01:56 <****> gfhghgfhfg: Acting like what?
01:56 <****> dba position
01:56 <****> karmasutra no 69
01:56 <****> seekwill: ...
01:56 <****> sequel was created in 1984 iirc
01:56 <****> VARCHAR with check constraints, huh? Hrm...
01:56 <****> Fuck standards in this case.
01:57 <****> SQL standard seems to be one of the worst standards out there.
01:57 <****> then you have no question.
01:57 <****> buh bye
01:58 * chadmaynard has a question
02:01 <****> chadmaynard: do you have a link some documentation on doing stuff with if's?
02:01 <****> !man condition
02:01 <****> see http://dev.mysql.com/doc/refman/5.0/en/declare-conditions.html
02:02 <****> nope
02:02 <****> !man if
02:02 <****> see http://dev.mysql.com/doc/refman/5.0/en/if-statement.html
02:02 <****> there we go
02:02 <****> thanks
02:04 <****> if is easy though, if ( condition, true, false)
02:14 <****> how do I figure out which version of mysql to install? (as in, Linux x86, Linux x86 standard, Linux AMD64, etc....) ?
02:15 <****> uname -a
02:15 <****> yeah, I did that
02:15 <****> paste the line here
02:15 <****> Linux ip-68-178-145-157.ip.secureserver.net 2.6.9-023stab043.1-enterprise #1 SMP Mon Mar 5 16:58:09 MSK 2007 i686 i686 i386 GNU/Linux
02:16 <****> So pick an x86
02:16 <****> great, thanks
02:16 <****> does it matter between the x86 and the x86 glibc-2.2 standard?
02:18 <****> just stay with the x86, it's your best bet
02:18 <****> ok thanks
02:19 <****> skatona: is there a reason you aren't using the built in package manager?
02:19 <****> my clueless-ness
02:20 <****> don't know what that is
02:21 <****> Does: cat /etc/*release* output anything?
02:22 <****> yeah
02:22 <****> What?
02:22 <****> fedora core 4 release 4
02:23 <****> er, fedora core release 4
02:23 <****> try "yum search mysql"
02:24 <****> what's that do
02:25 <****> k, well it just output a bunch of stuff
02:26 <****> so do a yum install whichever version seems right
02:27 <****> skatona: might want to read http://docs.fedoraproject.org/yum/en/ to learn how to use yum a little better
02:27 <****> ToeBee: thanks
02:27 <****> package managers are a very integral part of linux these days... it is good to know about them :)
02:27 <****> or just try yum install mysql* (kidding)
02:28 <****> dampjam: it doesn't look like the current mysql version is listed as updates-released....mysql-server.i386 4.1.20 is the only update for mysql-server I see
02:29 <****> Fedora Core 4 is very old
02:29 <****> 7 is out already
02:29 <****> try to find yum backports repositories
02:29 <****> does that mean I can't use yum to update mysql to 5.0 ?
02:30 <****> Fedora is not an OS to run servers on
02:30 <****> O RLY?
02:30 <****> YA RLY
02:30 <****> NO WAI!
02:30 <****> YA WAI!
02:30 <****> Fedora rocks!
02:30 <****> U SEE?
02:30 * seekwill uses Fedora!
02:31 <****> If you want to use a redhat distro for a server use centos
02:31 <****> fedora core is a better desktop
02:31 <****> IM IN UR FEDORA
02:31 <****> I was considering a fedora since my hairline is receding
02:31 <****> Well I got into your mom's fedora
02:31 <****> Or RHEL
02:32 <****> Use Solaris
02:33 <****> hey there
02:33 <****> from the command line how do I drop/backup the mysql db
02:33 <****> I have multi db tables
02:34 <****> drop/backup?
02:34 <****> If you drop it, how will you back it up?
02:34 <****> Meh, BSD for the win :)
02:34 <****> BSD sucks.
02:34 <****> Fedora for the lose, hard.
02:34 <****> you suck.
02:34 <****>
02:34 <****> Nu uh
02:47 <****> hi
02:47 <****> I get the save result set error
02:47 <****> cuz I'm trying to get too many entries
02:47 <****> so now I'm going to limit the query to batches of 50K
02:48 <****> is there an easy way to query so that I get data starting from a certain row
Total 31 pages. You are browsing page 3/31.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last