Problems with decimal numbers

Hello, When I try to insert decimal numbers like 12857.59, 13858.58 or 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?! DataType is DECIMAL 10,2 Any idea of a way to avoid this annoying issue ? Thanks. Regards. Stéphane. -- MySQL General Mailing List For list archives: http://lis

Connect to MySQL using TCP/IP securely

How can I connect to a distant MySQL Server -using tcp/ip- securely ? Thanks Stéphane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

[NEWBIE] safe_mysqld

When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stéphane Pinel 39, Rue du Docteur Heulin 75017

Re: [NEWBIE] safe_mysqld

t;starting mysqld daemon with databases from /var/lib/mysql" "010327 23:11:20 mysqld ended" I saw that even the owner of /var & /var/lib is 'root', the owner of /var/lib/mysql is 'mysql'. Is it right ? Thanks for your help. Stephane > > -Original

[NEWBIE]Can't run mysql client

I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box. Everything seems to be OK (the server runs) but I cannot connect to it using mysql client: When I enter "mysql -u etc..." I've got a "bash: mysql: command not found" Any idea ? Thanks -- Stéphan

[NEWBIE] Problem to launch mysqld

I try to execute "safe_mysqld --user=mysqladmin &" and the system return: "chown: mysqladmin: usesager invalide Starting mydqld daemon with databases from var/lib/mysgl 010422 : 17:59:25 mysqld ended" I'm extremely newbie in Linux and I waould appreciate some help To launch MySQL PII 350 Mhz

Access from anywhere to a hosted MySQL Database

I would like to know If there are webhosters that accept connections to hosted MySQL databases from other domains than localhost (via php) ? I want to manage MySQL database directly from anywhere with home-made tools. Thanks -- -- Stéphane Pinel 39, Rue du Docte

[OFF] URL of e-business websites that use MySQL/PHP4/Apache

I've some troubles with a competitor that says to my client that an Apache/PHP4/MySQL solution on Linux is unable to produce an e-commerce website. This person proposal is ASP/M$ SQLServer on an NT 4 Server... Can you send me some URLs that illustrate the ability to an Apache/PHP4/MySQL platfo