| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> show the query and the full errormsg. use the pastebin if you want
<1> it doesn't like like '%@%' is all the error says.
<0> talwyn: if you know best, why are you asking? or in conclusion, why are you resisting providing adequate info so people can try and help you?
<0> ohwell. it's your time to waste.
<1> If I know best??? Wtf? I am asking for help and I just told you what it told me... I showed just the relevant ( ithink) part it said was a problem... code and message at:http://hashmysql.org/paste/viewentry.php?id=1700
<2> talwyn you having a bitch fit on irc
<2> amazing
<1> Huh?
<1> robcole what do you mean?
<2> did i stutter?
<1> robcole I have no idea what you are talking about.
<1> robcole I am just asking for some help and got what appeared to be a smarmy reply... not having a fit at all.
<3> talwyn: CONCAT(a,b,c..)
<4> Smarmy?
<3> just let it die..
<4> DIE
<4> X(
<4> Anyone play Ghost Recond Advanced Warfighter?
<4> Ghost Recon
<1> Jivedue .. the Concat seems to work apart from the where clause, specifically whats wrong with '%@%' is the @ a special character?
<4> No
<4> Paste query.
<1> http://hashmysql.org/paste/viewentry.php?id=1700
<0> talwyn: very simply, you'll want to remove the ()
<3> talwyn: take away the ()
<0> that's all. and that's eactly what the errormsg points to.
<3> no, thank you, for the notice!
<1> ok .. weird does mysql not support () to group precedence of logical operators?
<0> talwyn: in this context, the precedence has no relevance.
<3> not when you put the in the middle of conditions
<5> it does... but somehow, "not like" is *one* operator :)
<1> Ok as I said wierd ... ok thanks for the help.
<5> talwyn: think about it... you only have one operand in the (). that does not make sense.
<0> talwyn: if you find another RDBMS doing it differently, feel free to report a bug/featurereq at bugs.mysql.com. that's how things work. be sure to report which version of mysql you used.
<0> primarily, I'd be interested if the SQL standard mandates supporting () in this context.
<5> arjenAU: a subexpression with only a binary operator owith *one* operand will never work...
<0> Duesentrieb: well it could, but it's silly.
<1> Duesentrieb in notation it makes sense.. I don't think I've seen similar on SQLserver (MSSQL) .
<0> SQL is not Lisp ;-)
<3> arjenAU: if anything it should be (login_name NOT LIKE '%@%')
<0> Jivedue: correst.
<3> and it's not even that
<0> talwyn: MSSQL is not our typical example of SQL standard compliancy ;-)
<5> talwyn: not (x like y) works. x not (like y) cannot work. it's like 2 ( * 3). it does not make sense.
<0> talwyn: it also supports DELETE * FROM tblname... which makes very little sense in the world.
<0> Duesentrieb: good example. tnx
<1> Well not() is a func/op all by itself in programming languages so not (a) or !(a) is common expression elsewhere ( not necessarily SQL)... probably where I picked it up.
<1> Anyway thanks again.
<6> What would be considered better syntax? INTEGER(2), INT(2), integer(2), or int(2)?
<4> tengus, You know what the (2) is for?
<6> I do.
<4> Just checking :)
<4> Not many people do. They get confused.
<6> lol
<4> What does it mean?
<3> so how about: TINYINT(2) being the best syntax then?
<6> will[werk]: number of chars?
<4> Nope.
<4> Well, most likely nope, unless you clarified a little bit more.
<7> :)
<6> the number of characters expected?
<4> Now you're guessing
<7> "display width"
<4> DINH DINH
<6> That just proves how little I know. I am new to SQL in general.
<3> uhhh, it's not the display width unless it's ZEROFILL ;)
<7> heh
<3> otherwise it's the maximum display width ;P
<7> Jivedue wins!
<4> Haha, must watch what I type.
<7> use it well...
<3> I'm sure you (will, sjrussel) both know that.. it's just being stupid specific.
<7> I think that was the point
<3> so back to tengus: why not just TINYINT(2)?
<7> how about, "why ever specify it, it just confuses people"
<6> Jivedue: okay, thanks
<6> why TINYINT as opposed to INT?
<4> (2) is only relevant to ZEROFILL
<4> It has no other meaning.
<7> btw, what does it do when that happens? I've always wondered
<7> display all 3, right?
<4> Yes
<4> (2) is worthless without ZEROFILL.
<3> huh?
<4> Jivedue, (2) is for display width for ZEROFILL.
<4> If you leave off ZEROFILL, it means nothing.
<7> it won't pad with spaces?
<4> Pad a number with spaces?
<4> Uh, what would that do?
<8> right justify
<9> SPIZZ0Rt
<4> Integers are normally right justified?
<10> hi folks
<4> Someone have an example?
<8> lookat any good financial report
<4> archivist, I'm saying numbers are normally right justfied regardless.
<4> Even in the client. And even so, (2) won't cut it.
<3> well, yah, you right justify b/c that lines the digits up correctly.
<3> will: you're talking about just ints or what?
<4> Yes...
<4> Isn't that what all of us are talking about?
<3> well, I wasn't sure if you were limiting it to INT, TINYINT, etc. or all numeric types
<4> Well, other numeric types (i.e., decimal, iirc float) use (2) for precision.
<3> yah, which is why I wasn't sure what you were saying by it being worthless w/o zerofill
<3> but that's sorted out now ;)
<4> So we all know that the (2) in this case is worthless without ZEROFILL?
<6> *silence*
<4> ...
<4> Everyone ignores me :(
<11> im trying to install mythtv, and i get these errors from mysql: Specified key was too long; max key length is 1000 bytes
<4> Another MythTV problem...
<7> ok - re: widhth w/out zerofill, if you had 9, 8, 7 as values they could be 1 char wide; but with int(10) maybe they'd be padded to 10 char wide?
<4> sjrussel, http://hashmysql.org/paste/viewentry.php?id=1701
<4> Padding a number with spaces makes it a string...
<7> cool
<4> Therion, Why can't it be a syntax error if they specify display width without ZEROFILL??????
<4> Time to go!
<7> how about just making specifiying a width a syntax error ;)
<12> any plans for mysql to allo for any engine to be used like sqlite does? w/o requiring a server?
<13> How do I select on a date type of two months ago?
<9> will[werk]: I dunno. Parser ****s?
<14> hey do you guys mind if i stick my bot in here for a bit? i want to see how he does in a busier room. he wont talk unless you adress him by name i promise
<15> yes we mind
<16> vluther, how to list all indexes of a database
<17> Does anyone here know how to use php's mysqli on a mysql cluster?
<17> Is one connection to the master enough, or do I need multiple?
<7> huh?
<18> Cody`: only one
<17> Darien: How?
<17> Just connect to master?
<18> should be
<18> might want to read the docs on it
<17> There aren't docs on it
<17> already looked
<17> all the cluster doc parts are lacking or non existant
<19> how would you select all fields that start with a number?
<19> any letter would be WHERE field LIKE 'x%' but i can't think how to do it with a number
<17> Darien: Then I guess I just use mysqli_master_query() and mysqli_slave_query()?
<12> Therion: any plans for mysql to allo for any engine to be used like sqlite does? w/o requiring a server?
<17> mysqli_slave_query is in old docs, but not new ones :/
<18> you connect to the client node
<18> !m Cody` mysql cluster concepts
<20> Cody`: (Basic MySQL Cluster Concepts) : http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Basics.html
Return to
#mysql
or
Go to some related
logs:
sudo dpkg -reconfigure -xorg s3 unichrome
kdm-3.5* is blocking
gentoo mplayer mtune
#osdev
libical fc5 scalix
#linux
#php
gstreamer properties xfce
#awk
#qemu
|
|