|robdeman||do I need to compile? im using apt-get ?|
|chadmaynard||robdeman: i dont see how that search would help. It's just a configuration thing. Did you install php5-mysql?|
|XsSo||I 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';"|
|robdeman||chadmaynard: phpinfo(0)show smysql is loaded|
|XsSo||in which case, sid would increment 1|
|chadmaynard||robdeman: then you just don't have it enabled properly. New security features!|
|chadmaynard||update table set sid = sid+1;|
let me find the article you need robdeman.
|chadmaynard||just read the stuff on http://www.php.net/mysql under php 5_|
5+ i mean
|xnor||Hi, 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))
|kibble3||Question: What data type would be recommended for storing money values up to 10,000,000|
|kibble3||yep i've read it all|
|ToeBee||also, I would strongly recomend storing it in cents as integers, not as a float/double|
|kibble3||because its fastest and best storage space usage right?|
|ToeBee||more because math operations on floats and doubles incur rounding errors|
|kibble3||mostly i'm wondering how efficient decimal is, because thats the best option|
|ToeBee||you want to do all your calculations on integers when you need accuracy|
|kibble3||i need to store tenths of a cent, so integers won't work|
|ToeBee||sure they doo. just multiply by 1000|
|kibble3||so 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?
|ToeBee||hmm I guess decimal changed in 5.0 so no sure what all that changes|
|kibble3||i'm using 4.x|
|ToeBee||ah. "Prior to MySQL 5.0.3, calculations on DECIMAL values are performed using double-precision operations."|
|Shaun2222||i 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?
|kibble3||just mysql db or everythihgn|
|Shaun2222||just the mysql db...|
it's a db only server...
just a single database i should say...
|kibble3||replication could work but is a lot of work no?|