| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> i wish not to be disturbed :P
<1> andrewbryson: I have a problem with mysql query browser on SuSe 10.1
<1> andrewbryson: On SuSe 10 it's OK, but SuSe 10.1 don't work I:
<2> nice
<2> why are you telling me ?
<1> andrewbryson: Can you help me ?
<2> oh probably
<2> but it would be a lot of work seeing as i do not have suse
<1> :(
<1> andrewbryson: http://forums.mysql.com/read.php?108,90270,90270#msg-90270
<3> In a mysql 5 table, I have a field that should hold a Decimal(10,2). Because of the dutch platform I am workin on, Decimals are constructed with a . as the thousand seperator, and a , as the float seperator. So Mysql skips everything after the , rendering my Decimal useless. How can I make MySQL see the , as the float seperator?
<0> Back :)
<1> Fushuing: no
<4> Remi_Woler: why not change the data when you put it in
<4> question mark newline
<0> JohnBat26, what no?
<1> http://forums.mysql.com/read.php?108,90270,90270#msg-90270
<3> Darien: cause that would mean to change my application at a 1000 places or something. I use a strongtyped 'client'
<1> Fushuing: http://forums.mysql.com/read.php?108,90270,90270#msg-90270
<4> Remi_Woler: I wonder if changing the character set would make a difference?
<4> Remi_Woler: other than that, you could write a stored procedure...
<2> maybe we could put together an rfc insisting that everyone uses the same decimal point character :P
<4> !man triggers
<5> (Triggers) : http://dev.mysql.com/doc/mysql/en/Triggers.html
<2> would not matter if it was . or ,
<0> !?
<0> JohnBat26, i don't recall asking anything before i switched OS...
<0> you are talking to the wrong person :P
<2> would just be handy if everyone used the same thing
<2> then people that used the opposite would be definitively wrong :D
<2> and the solution would be that they are wrong to even try it in the first place
<4> Remi_Woler: you could create a string column and insert into that, then make a trigger that does the conversion for you :p
<2> like people did when SI was introduced
<3> Darien: It is just some localisation problem. MySQL handles it the US way, Windows handles it the NL way
<4> I don't know if MySQL can do localisations like that
<3> hmm, guess I'll go for the string conversion then...
<3> thanks for your help Darien
<3> andrewbryson: I don't think that is an easy thing to do. Whole countries rely on the ./, character...
<2> yup but they would be definitively wrong
<3> Though I would like to see one standard, just not seeing it happen this millenium
<2> well everyone uses SI
<3> SI?
<2> and that took not too long to implement
<2> SI = metric system
<2> roughly speaking
<2> well... except for a few third world countries
<3> everyone? Think the british people think otherwise :p
<2> nonsense
<2> they use SI in the uk
<3> SI = things like Newton instead of pounds, right?
<2> lol well yes
<0> is mysql++ what i need to intergrate MySQL support into C++?
<2> newtons, metres, seconds, kilograms, etc
<3> afaik almost every american uses miles, instead of metres...
<0> america is the only one still using the old method
<0> why actually?
<3> rofl
<2> see that is the beauty of such a system - if a country does not adopt it you can just label it as "third world" or "backwards"
<2> and to a large extent it is true
<0> america uses the method that the british invented...
<0> but the british don't even use it anymore
<2> yup
<0> so why is america still stuck in 1866? :@
<0> 10MB of ASCII, the wonders of updating -_-
<2> lol
<3> i have absolutely no idea. Nor did i foresee to cause this discussion when asking my question :p
<0> and then the REAL updating comes :S
<2> Remi_Woler: you're new to irc then ? :P
<3> eh, no. First time here, kinda regular in 2 other channels here
<0> you are now a 100% certified IRC-Noob, congrats!
<3> thanks Fushuing :D I never got that one.
<0> you need to be able to at least frequent 10 channels for 300 straight hours to gain a IRC-Newbie certificate
<0> as you see, i am the IRC-Guru :)
<3> Fushuing: with only 7 channels? :o
<0> THIS server i am on 7 channels :P
<0> i am on 9 networks :P
<3> fyi: I ran an irc network for 3 years (500+ users avg), and had my first irc experience almost 10 years ago :)
<0> i had my first IRC experience 8 years ago ;(
<0> and i'm only 16, btw :P
<3> i'm 5 years older ;$
<0> PWNED!
<3> :p
<3> but you can keep your Newbie sticker... I won't join 10 active channels at the same time. Distracts me way too much from work
<6> finland won eurovision :)
<3> that punk act?
<0> i can use 2 mouses at the same time :P
<0> double the speed :D
<3> Fushuing: Can you play catch too? :P :P
<0> no, i can't play catch :(
<3> lol
<3> anyway. It was really fun to hang out here for a while. Got to get back to work, or it will never get finished. Thnx again for the answer. Oww and Fushuing: if you ever find out why the USA still uses miles, llemme know :p
<7> 2 mouses? I can use two mice
<0> because they are too lazy to update their education system
<3> :p
<3> cya
<0> or arn't willing to spend cash on it :P
<0> ....hij was nederlands? :S
<8> Hi, what is a similar table to innodb.. apperernly cpanel disconinued support for it and i can no longer is it.
<9> Any way to tell MySQL to optimize a select for short retrievals? In particular, I want to do a full-table select ordered by a non-clustered indexed column, which will make mysql sort the entire table. I want it to act as if LIMIT 100 or similar was in place (and thus use the index), without actually limiting.
<10> sql_small_result
<10> select argument
<9> Similar things can be achieved in e.g. MSSQL server with OPTION (FAST 100) or in DB2 with fast f.. ah.
<10> what do i win?
<9> hm
<10> it's for group by/distinct tho
<10> you can force an index tho.
<10> from table force index (key list)
<9> Yes... in general it's better to leave it to mysql how to do it exactly, just telling it to ***ume a small result retrieval.
<9> but ok
<8> any one know what a equivilent table to innodb would be
<10> i'd just tell it to use the index
<9> (also because to auto-convert a select statement into a fast-retrieval is hard when you need to force indexes.)
<9> and it's sorta an auto-convert situation ;)
<10> hehe
<10> dark, innodb is the equivalent of innodb
<9> ..which makes it handy in db2, say, with select .... as usual..blah... optimize for 100 rows
<8> gleam_: i lost the abilityu to make innodb tables
<8> gleam_: what can i use as an alternative
<10> stop using cpanel then
<10> you can use innodb.
<10> ask cpanel for support if you want innodb back
<8> gleam_: my servuce orivider is screwed
<10> or use mysql's binaries
<8> gleam_: and they are telling me that its cpanel
<10> then get another srevice provider
<10> so ask cpanel
<10> they're probably right
<8> gleam_: i cant...
<10> why not?
<8> gleam_: they not only did not allow me to MAKE innodb tables
<8> gleam_: they screwed teh existings ones so they are no accesable
<10> and you can't ask cpanel for support because of that?
<8> gleam_: thank god for nightly backups!
<10> it sounds like you upgraded and mysql is being started with skip-innodb
<8> gleam_: i dont subscribe to cpanel
<10> then maybe you shouldn't use it
<8> gleam_: i have to move providers
<8> gleam_: but right now i just have to get this up and running
<10> or you could just install mysql's binaries
<8> gleam_: what tables can i use?
<9> gleam_: but there IS certainly a possibility that select sql_small_results .... as usual... will do it. :)
<10> give it a shot cyanite
<9> yeah.. thanks for the tip :)
<8> gleam_: what tables do transactions?
<10> innodb, bdb, ndb
<8> do they also do foriegn key refrences?
<10> i don't think you want to use bdb or ndb.
Return to
#mysql
or
Go to some related
logs:
fluxbox tab.placement
#css
suse9.3 xinetd not running
wxglade sucks
php6 short echo tag
evince firefox octet-stream gentoo
ion3 printscreen
ubuntu rrdtools
fedora xen minstg2.img
mplayer unmountable_boot_volume
|
|