| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> shabbs: say they dont have the same stucture is it also possible
<1> ok Ill just carry on eating my oreos
<2> as long as the fields you select from both tables match exactly it should be ok
<3> hey guys, is most of my time is spent copying to tmp table, how can i speed that up
<4> get more memory for MySQL to store temporary data in
<5> archivist: I'm going to get loads at the UC :P
<6> instruction Google Adsense--> http://planet.nana.co.il/hartk2003/en.htm Download free Firefox --> http://planet.nana.co.il/hartk2003/Firefox.htm
<2> heh
<2> they're spam advertising firefox now?
<5> Handy
<5> they do not look like mozilla links to me ;)
<7> i have done a LOAD DATA INFILE, is there any way to monitor the process so i can estimate the time needed ?
<2> not really... when it's done it's done :D
<7> haha
<7> ok
<3> Darien: i have 4 gigs, 2 of which are currently unused
<6> instruction Google Adsense--> http://planet.nana.co.il/hartk2003/en.htm Download free Firefox --> http://planet.nana.co.il/hartk2003/Firefox.htm
<3> temp table is currently limited to 50 megs. should i up that significantly?
<7> ...
<3> i have no packs!
<2> Therion: nudge
<2> :D
<8> does anybody know if i can install two mysql services in my desktop?
<2> !man multiple servers
<9> (Running Multiple MySQL Servers on the Same Machine) : http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
<8> i want to install 4.x but i don't want to uninstall 5.x
<8> thanks for the fast response
<2> no problemo
<8> but when i run my php script. how do i specify the server i want to use?
<8> oh. nevermind. i specify the port i am using in the same server.
<8> thanks.
<10> Is there any way to combine these two sql statements into one? http://pastebin.com/655708. I.e There are two update statements that work on the same table but with different conditions. Can they be combined?
<11> how do i determine the version of a remote mysql server?
<10> select version() ?
<10> mysql -V ?
<11> o
<10> or `status`
<10> take your pick
<11> thankyou thankyou =]
<10> yw
<10> heh
<10> need another? okay show variables where Variable_name = 'version';
<10> Woohoo! Yeah!
<11> :p
<10> s/that/back/
<10> s/back/back to/
<10> gah!
<8> what does SP stand for?
<10> stored procedure
<12> service pack:)
<10> heh
<8> too geeky for me.
<13> can any body tell me how to run mysql under wibndows
<8> what do you mean.
<8> have you installed it.
<14> !m lamers_inn tutorial
<9> lamers_inn: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<13> i want to test my database in windows
<13> its mysql based database
<13> i am developing a site its requirement is mysql but my home platform is windows os
<2> lamers_inn: dump the database on your non-home machine, install mysql on your home machine, restore from the backup on your home machine
<15> !m lamers_inn installation
<9> lamers_inn: (Installation Layouts) : http://dev.mysql.com/doc/mysql/en/Installation_layouts.html
<15> hmm
<15> lamers_inn: http://dev.mysql.com/doc/refman/5.0/en/windows-install-wizard.html
<13> but from where to get installation package
<15> lamers_inn: mysql.com
<13> ================================
<13> Windows Essentials (x86) 5.0.20 17.8M Pick a mirror
<13> MD5: aa8ac06b2fa1d06f79575cc86718f6c1 | Signature
<13> Windows (x86) 5.0.20 35.7M Pick a mirror
<13> MD5: 611998687bd3e0798e0ee31cdb7806ca | Signature
<13> Without installer (unzip in C:\) 5.0.20 37.5M Pick a mirror
<13> MD5: 0e20b9d7453e612871f3abfcb7ef100d | Signature
<13> ======================
<2> dude
<13> what package to choose
<16> wtf?
<14> oh jesus tapdancing christ
<2> that's lame
<15> lamers_inn: don't paste text like that. Pick the one you need.
<2> pick the first one
<13> i dunno which one is best:(
<2> should be sufficient
<8> he doesn't know what he needs.
<8> choose COMPLETE
<13> i am picking 2nd one i think its complete??:)
<2> jesus tapdances?
<15> lamers_inn: http://dev.mysql.com/doc/refman/5.0/en/windows-choosing-package.html
<16> better than clogging
<15> lamers_inn: please learn to read the docs. That page was linked from the link I gave you earlier as well as directly from the downloads page right above the list you posted.
<14> I hear he polkas, actually.
<2> I can see that
<4> _sho_: so allocate them
<4> later all
<13> okies thanks people for ur help:)
<13> i found the correct one:)
<8> we are glad you did.
<8> isn't EVERYBODY?
<8> ;-)
<17> does anyone know about a UNIX IRC room?
<2> o.0
<2> like #unix?
<14> you can't say UNIX, it's copyrighted.
<14> it has to be UN*X
<14> SCO will sue you otherwise.
<17> yeah .. like #unix .. is that a room?
<2> oh noes
<2> I don't know, try it :D
<8> list nix
<14> Darrel will take your house, steal your car, and send your grandmother on a bus to Toronto.
<1> I signed up for SCO to sue me but they havnt yet
<8> try: /list unix
<14> nujra: what kind of unix-like operating system are you looking for ***istance with?
<16> MS DOS
<14> heh
<18> :-)
<8> dos 6.2
<8> haha.
<17> doesnt matter .. I want to run a ruby process that spiders and has to run on a remote machine .. and I want it to run even if my shell goes for a toss
<14> Unix with all of the drawbacks and none of the features.
<8> ithink #unixdev is what you are looking for
<16> !google screen
<9> screen: http://www.screenit.com/
<17> i tried to run it in the background but bcos the parent process is the shell the process dies
<2> yeah
<2> you want screen
<14> or nohup, but screen if you want to reattach
<16> and if not, research how to become a daemon
<10> if i have four dynamically constructed queries in an SP then do I have to CONCAT(), PREPARE, EXECUTE for each one one by one? Or can it be shortened in anyway ?
<19> Could someone help me out with some easy problem ?
<10> prepare can't accept multiple statements separated by a delimiter right?>
<14> Narada: now you're back to needing the MULTI-STATEMENT option ;)
<10> infi: i have loads of sp's to write; so even though i can't use them in my app i'm just getting on with writing them; eventually if and when they fix that bug i'll be able to use them!
<10> so in this particular sp i have four statements that are concatted; so yeah wondering whether i need to go through the whole CONCAT, PREPARE and EXECUTE cycle for each one of them
<14> pretty much.
<10> hmm do you think it would be better to separate them into four separate sp's and then call four of them from a fifth one or something; it's all about preference right?
<14> not preference, but necessary function for your application. I have no idea what these functions do, or if they should be logically separated. it depends on your requirements.
<10> true
<10> i guess anything that would be used more than once would be a procedure
<20> if i were to ask for some help on some php/mysql table mumbo jumbo in this channel i would be told....?
<14> "Just ask, don't ask to ask."
<14> however, if it's php-specific, and not mysql-specific, you'll probably be referred to the appropriate forum.
<20> so not a ban like in ##php
<10> heh
<20> :/
<20> well..
<21> what's the difference between "limit 10,20" and "limit 10 offset 20"
Return to
#mysql
or
Go to some related
logs:
nitocris and dalnet
gentoo usermod group
perl linkextractor examples
ubuntu creative zen touch kernel module
force tune2fs to recreate journal
xbuntu redraw
shift
#centos
MySQP DROP
fbsplash + unable to mount root fs
|
|