Problems with decimal numbers

2005-02-08 Thread Stephane Pinel
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:

Connect to MySQL using TCP/IP securely

2002-04-03 Thread Stephane Pinel
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)

[NEWBIE]Can't run mysql client

2002-01-28 Thread Stephane Pinel
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éphane

[NEWBIE] Problem to launch mysqld

2001-04-22 Thread Stephane Pinel
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

[NEWBIE] safe_mysqld

2001-03-27 Thread Stephane Pinel
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 -- Stphane Pinel 39, Rue du Docteur Heulin 75017

Re: [NEWBIE] safe_mysqld

2001-03-27 Thread Stephane Pinel
aemon 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 Message----- From: Stephane Pinel [mailto:[EMA

Access from anywhere to a hosted MySQL Database

2001-01-13 Thread Stephane Pinel
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 -- -- Stphane Pinel 39, Rue du