| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> when i was lerning how it worked i saw and example useing //
<1> 0 rows returned :(
<2> Table gleam does not exist.
<1> i have two dads!
<3> i derive what codepage a varchar is encoded in, using utf-8?
<0> is that a question ?
<3> er, how do i, even
<3> heh
<4> can I use | as a delimiter? if so do I have to use a special character like \|
<0> no you don't
<0> Led-Hed
<5> i want to make an exact copy of a table in a database
<5> what's the easiest way to do this?
<5> ( i can dump/restore, but that's kinda lame )
<0> Xerox
<2> sickdm, It's not lame, actually. That is the best way to do it.
<4> I3ooI3oo: SELECT uid FROM mailbox |; should work?
<5> will[werk]: haha
<0> you don't need the ;
<2> Led-Hed, Why ;?
<0> but yes
<2> sickdm, Why haha?
<0> Led-Hed: SELECT uid FROM mailbox |
<5> well, the table name is embedded in the mysqldump file
<5> so when i dump the table
<2> So?
<5> i'd want to restore to a different one, without manually editing the file
<5> hmm, though i guess i can make mysqldump restore into a new table?
<2> if it's only one table, you can use CREATE TABLE LIKE ... And then INSERT INTO newtable SELECT FROM old table
<2> No, you'll have to modify the dump
<4> SELECT uid FROM mailbox | = "You have an errir in your SQL syntax"
<0> what id you type on you delimiter
<0> Delimiter |
<0> or
<0> delimiter |;
<5> oh ok
<0> if the second then your delimiter is |; not |
<4> I typed: SELECT uid FROM mailbox |
<0> the delimiter command doesn't require a delimiter
<1> why would you want to use | as a delimiter anyway?
<0> led type this
<0> in you mysql
<0> delimiter |
<4> cuz I'm going to egrep -v 'something|something2|something3'
<0> then hit enter
<1> why don't you do something like select group_concat(uid separator "|") from mytable
<1> mind you
<1> will already told you to use group_concat.
<1> and again to mysql "delimiter" means "query terminator"
<1> not "value separator"
<0> lol
<2> PEOPLE DON'T LISTEN
<0> THEY DO WHEN YOU USE CAPS THOU
<1> THOU ART?
<2> WE SHALL TALK LIKE THIS FOR NOW ON
<1> FO SHO.
<0> THEN YELLL AT OTHER THAT USE CAPS TOO
<2> YOU YELL AT PEOPLE WITH LOWER CASE DUH
<0> NO YELLING IS BOLD
<2> KICKBAN IS BOLD
<0> BUT I WAS REFERING TO WE SHOULD SCOLD OTHER STILL FOR USING ALL CAPS
<2> NO
<4> YoU gUyS ArE LaMe.
<1> !kick Led-Hed
<2> MIXED CAPS IS LAME
<2> haha sukka
<1> heheheheheheeh
<0> any you don't read well
<0> *and
<2> Led-Hed, MAYBE IF YOU LISTEN IN THE BEGINNING YOU MIGHT LEARN SOMETHING
<6> Question: Shoudl root access to mysql have p***word protection?
<1> yes.
<6> ok
<2> Answer: Yes. But MySQL comes default with none (so you can log in...)
<6> yes, and I dont remember how to set p***word
<2> !m Tuzlo set p***word
<7> Tuzlo: (SET P***WORD Syntax) : http://dev.mysql.com/doc/mysql/en/SET_P***WORD.html
<2> !m Tuzlo mysqladmin
<7> Tuzlo: (mysqladmin, Administering a MySQL Server) : http://dev.mysql.com/doc/mysql/en/mysqladmin.html
<4> I was reading about GROUP_CONCAT, but then I3ooI3oo said something different. So I tried it. whats wrong withthat? Or has it gotten to the point that anything I ask is gonna catch me flak
<2> Right right right...
<4> OMG
<2> Flak is great.
<2> You're dealing with 12 year olds. What do you expect?
<2> We've never had girlfriends nor ever been laid.
<1> pimply faced youth
<2> All we do is talk in caps on IRC
<1> irc
<1> stop shouting will
<2> mirc!
<4> is that the reason for Child Pron? You think you're 12, and want to get laid?
<2> Of course.
<2> gleam-, NO!
<2> Led-Hed, Remember, we don't joke about child porn.
<8> gleam-: reran load data from master just finished. the MYD sizes differ by 200k over 9 G
<2> And what the hell is "pron"? Is that like shrimp?
<4> I don't, but you do
<2> Not anymore.
<5> will[werk]: oh awesome the create table like thing is working great
<4> Pron is like Porn only spelled differently
<2> sickdm, I bet it does.
<5> will[werk]: it actually is just one table, i need to take a snapshot of something now and hten and compare them
<2> Led-Hed, That is LaMe
<2> sickdm, Cool beans.
<4> not as lame as your claiming to look at child pron
<2> Ok enough...
<8> anyone work with replication?
<2> Yes, but when I attempted it, she said no.
<6> I have a database from an old computer on a secondary harddrive, can I copy the files over to /var/lib/mysql and safely run it?
<9> Same version of mysql?
<2> If the new installation is a new DB. What version?
<2> newer version...
<6> will[werk]: Im not sure of the old version
<6> can I import it ?
<2> You can always try!
<10> how can I sum a count(*)? I'm trying this: select sum(count(a.col)) from t a where a.col <> 0 group by a.col;
<10> is that accurate?
<10> that's a watered down version of the actual sql
<10> if you need the real sql I can paste it.
<10> its one line.
<1> why would you do that? why wouldn't you just count(*) where a.col <> 0?
<10> well, here's the real thing: select count(a.reg_num) as Total, sum(count(a.reg_num)) from gm_dealers a, region_names b where a.liq_ind <> 0 and a.reg_num = b.reg_num group by a.reg_num;
<1> you probably want "WITH ROLLUP"
<10> which is just a tweak from a prior select that returns values in 4 rows
<10> I want the values in those 4 rows summed
<1> yes.
<10> select count(a.reg_num) as Total from gm_dealers a, region_names b where a.liq_ind <> 0 and a.reg_num = b.reg_num group by a.reg_num;
<10> gleam: I've never used with rollup before.
<1> http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
<10> where is it used?
<10> checking
<10> oh awesome!
<10> thanx. That worked perfectly
<1> good good
<11> should these two queries not be equivalent? http://hashmysql.org/paste/viewentry.php?id=1855
<2> No
<2> Why are you using parenthesis?
<11> should I not be?
<2> It's the reason why things are being messed up.
<11> which ones?
<2> I forgot why that happens, because I don't use them.
<2> Both.
<2> Not doing what you expect.
<2> Which one does things the way you want?
<11> the second one does
<2> Yeah, I was going to guess that.
<2> Even then, drop the ( )
Return to
#mysql
or
Go to some related
logs:
gentoo chroot :cannot run command /bin/bash Exec format error
#mysql
#python
distcc gentoo directory access denied
www.ragnarokextreme.com/control/
azureus ShareResource: Torrent create failed
#math
gentoo apache network interface lo does not exist
checking for KDE kiso error
winetools xubuntu
|
|