User specific query

2001-08-17 Thread Xi Jiang
Hi all, We want to set up a user in mysql and allow him to send his queries to our database from his server. (PHP) The data in our database contains our other customers' as well as the guy who wants to directly access it. We would like to check his queries before send it to the database. Fo

float value is changed

2001-02-17 Thread Xi Jiang \(ITSPORTSNET\)
Dear all, I have a field defined as float (16,0). When I insert 99 (10 9s) into the table, it changed it's value to 100(1 and 10 0s). It also change some other inserted values. Does anybody have any idea what the reason causing it? And how can I fix that? Thanks in advance