#mysql - Sat 3 Mar 2007 between 17:39 and 18:50

NY Lost Funds



robdemando I need to compile? im using apt-get ?
Gatoelhogoogle it
chadmaynardrobdeman: i dont see how that search would help. It's just a configuration thing. Did you install php5-mysql?
robdemanchadmaynard: yes
XsSoI have a column that is an integer, that column needs to increment on each UPDATE that I pass to it...is there any way o do this in MySQL? something like "UPDATE logs SET sid = ++ WHERE chat_id = '73';"
robdemanchadmaynard: phpinfo(0)show smysql is loaded
XsSoin which case, sid would increment 1
chadmaynardrobdeman: then you just don't have it enabled properly. New security features!
robdemanchadmaynard: ugh
chadmaynardupdate table set sid = sid+1;
let me find the article you need robdeman.
robdemanok thanks
chadmaynardjust read the stuff on http://www.php.net/mysql under php 5_
5+ i mean
xnorHi, i have a colum with integers from 1 to 5, is it possible to get the average value rounded to a integer?
i solved it with round(avg(table))
kibble3Question: What data type would be recommended for storing money values up to 10,000,000
ToeBeekibble3: http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
kibble3yep i've read it all
ToeBeealso, I would strongly recomend storing it in cents as integers, not as a float/double
kibble3because its fastest and best storage space usage right?
ToeBeemore because math operations on floats and doubles incur rounding errors
kibble3mostly i'm wondering how efficient decimal is, because thats the best option
ToeBeeyou want to do all your calculations on integers when you need accuracy
kibble3i need to store tenths of a cent, so integers won't work
ToeBeesure they doo. just multiply by 1000
kibble3so store all money values in multiples of 1000?
then the limit becomes 2 mil
decimal seems to be the only one thats accurate, and won't incur rounding errors
at the cost of some efficiency. does that sound right?
ToeBeehmm I guess decimal changed in 5.0 so no sure what all that changes
kibble3i'm using 4.x
ToeBeeah. "Prior to MySQL 5.0.3, calculations on DECIMAL values are performed using double-precision operations."
Shaun2222i have a 90GB db i need to move from one server to another with a minimal amount of down time... obviously 90GB is alot and it's moving accross network at 100mbit link... What do you guys think would be the best way to move the data? I was thinking maybe setup replication to the new server wait for it all the sync up and then removing the trust...
what do you guys think?
kibble3just mysql db or everythihgn
Shaun2222just the mysql db...
it's a db only server...
just a single database i should say...
kibble3replication could work but is a lot of work no?

Page: 4 11 18 25 32 

IrcArchive

NY Lost Funds