#mysql
15 November 2007
Total 10 pages. You are browsing page 2/10.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:14 <****> Abobo what is crap about stored procedures ? you're talkig crap, if you "compare" them with such prejudice
00:14 <****> adaptr: on the other hand, we're not into pissing contests in this channel.
00:14 <****> adaptr, i asked a question first
00:14 <****> arjenAU I, indeed, am not - I asked questions
00:14 <****> Abobo one that I cannot answer, since I just explained that I do not use mysql for the same tasks as MS SQL
00:15 <****> yea but you claimed that mssql does things better
00:15 <****> you have to have at least one example
00:15 <****> I run big-ass enterprise clusters of MS SQL2005, a field I have zero experience with in MySQL
00:15 <****> hmm, then i suppose you shouldn't be making those claims etc
00:16 <****> no, I said that if you compare mysql to sql2000, you're going to surprised by 2005, and I would be surprised if it hadn't "caught up" by now
00:16 <****> let's drop it here please.
00:16 <****> no, you said I'd, "be hard pressed to find anything in mysql that it doesn't do as well or better"
00:16 <****> glad to
00:17 <****> he's just looking for a fight
00:17 <****> yea, better slink out of this one
00:39 <****> arjenAU - thanks....
00:40 <****> anyone here currently at a system running a slave/master replication process
00:46 <****> hi all
00:46 <****> is possible to get the maximum value from two columns?
00:47 <****> i need to do something like "SELECT MAX(5,610)"
00:47 <****> but 5 and 610 are column values
00:50 <****> knoopx: you're looking for HIGHEST()
00:50 <****> you could do HIGHEST(MAX(col1),MAX(col2))
00:50 <****> uh ok thanks
00:51 <****> your construct might also indicate an incorrect table design though, but that depends
00:52 <****> uh not really
00:52 <****> that data is for stats
00:52 <****> not for a real use
00:58 <****> _Lemon_ - hey....
00:59 <****> FUNCTION my_table.HIGHEST does not exist
00:59 <****> :S
01:00 <****> knoopx: it isn't my_table.HIGHEST... it is just "HIGHEST"
01:00 <****> _Lemon_ - in researching the slave/master issue.. it appears that you could have multiple slave DBs on a single machine, and that you could have a cron process, iterate through each salvedb by having the mysql do a "change master"..(sp??) but this would essentially be like doing a round robin between all the slaves...
01:01 <****> ToeBee: i know thats what mysql throws
01:02 <****> that's because it is GREATEST() : )
01:02 <****> good point. I thought it didn't quite look right
01:03 <****> lol
01:03 <****> xd
01:03 <****> your right chadmaynard its GREATEST
01:03 <****> haha
01:04 <****> i know
01:37 <****> 'k'
01:37 <****> haha :)
01:38 <****> sv2_: I suppose you will need a cron job afterall, this will do the round robin operation that you were originally planning for. Alternatively you could have multiple mysql processes (which I don't recommend)
01:38 <****> sv2_: Anyway, almost 1am here, not really in the best frame of mind to give advice :p
01:39 <****> _Lemon_, sv2_: In 5.1, there will be a builtin event scheduler in mysql, which makes a lot of cron scripts obsolete
01:39 <****> _Lemon_ - get some sleep!!
01:40 <****> k - yeah.. i know, but it doesn't apply to my given situation, and 5.1 won't be production for awhile yet anyway..
01:41 <****> _Lemon_ - the issue i'm trying to resolve now, is how figure out/determine when a slave is updated relative to the master..
01:41 <****> the "show slave status/G" looks promising, but i'd have to parse it's output..
01:47 <****> somelog.csv
01:48 <****> MrKeuner: mysql -e "your query"
01:48 <****> k great! thanks
01:49 <****> How much data can a text field hold?
01:49 <****> Unlimited?
01:50 <****> br3nden: 2GB or in that range
01:50 <****> text is 64KB
01:50 <****> hmm.. thats a big difference.... 2gb and 64kb
01:50 <****> longtext is 4GB
01:51 <****> ok so longtext would be appropiate for....say... storying submitted essays?
01:51 <****> k: :-P
01:51 <****> br3nden: 4GB essay? wow.
01:51 <****> well obviously not a 4gb essay... but that would be the ideal datatype right?
01:51 <****> or any long text area
01:51 <****> is the essay in plaintext or is it in microsoft word format or something?
01:52 <****> plaintext
01:52 <****> then yes, longtext is fine
01:52 <****>
01:52 <****> ok thanks.
01:52 <****> forcing someone to submit an essay through a textarea is a horrible thing to do :-P
01:52 <****> 4gb through the browser?
01:52 <****> br3nden: if it's just a couple pages of text submitted through a web browser, regular TEXT is more than enough, probably. how much are people supposed to be submitting?
01:53 <****> litheum: no more than a couple pages of text. probably max 40 pages of text.
01:53 <****> there is also mediumtext
01:53 <****> 64K characters, or even 20K in the case of utf-8, is a lot to cram into a textarea
01:53 <****> maybe just text is good for me?
01:54 <****> 40 pages * 25 lines * 80 char
01:54 <****> thats up to 80k
01:55 <****> Relatively new Computer Security Site http://www.wgforums.com Check it out FORUMS FOR EVERYTHING: Computer Hacking, Computer Security, Computer Networking, Computer Programming, Lots of Warez, Gaming, ++ Lots MORE!!....Thank You. Once again the site is HTTP://WWW.WGFORUMS.COM
01:55 <****> hmm... spam much?
01:57 <****> Elite_Chaos: don't spam here.
01:57 <****> then we all spam the forum :)
02:03 <****> How would I make a mysql table automatically add a date and time stamp?
02:04 <****> !m br3nden timestamp
02:05 <****> br3nden: (Overview of Date and Time Types) : http://dev.mysql.com/doc/mysql/en/date-and-time-type-overview.html
02:08 <****> hi I have a utf-8 field and i am using select ... into outfile. However the utf-8 characters are not showing right. How can I specify to write as utf-8?
02:09 <****> has anyone here used 5.1 in a semi production/full production environment? I want to try out the data partitioning thing for a product I'll be launching in January, but I want to know if anyone has any caveats. or people's level of comfort with it
02:11 <****> i am trying to get mysql running on kubuntu 7.10 i installed it from the repo but when i try to start mysql nothings happens, i am missing the /etc/init.d/mysqlbut no matter if i un-install and re-install it does not seems to create that specific file, what am i missing? thanks
02:14 <****> |neon|: it is included in 5.0 package
02:14 <****> mysql-server-5.0
02:14 <****> you have to run sudo /etc/init.d/mysql restart
02:15 <****> MrKeuner: yea i know i have installed that file and un-install it several times it will not create mysql under the the /etc/inint.d/ directory
02:16 <****> |neon|: aren't you getting any error messages during installation?
02:17 <****> |neon|: I am using 7.10 and I have that script there
02:17 <****> invoke-rc.d: unknown initscript, /etc/init.d/mysql not found
02:18 <****> do you get when installing or uninstalling?
02:18 <****> i am installing from th gutsy repo
02:18 <****> installing
02:18 <****> yes, I have installed it from there
02:18 <****> sudo apt-get install mysql-server-5.0
Total 10 pages. You are browsing page 2/10.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last