SQL command for MySQL ?

w if they have a optimised sql requets for said if the WHERE don't exist, he create it ! (if he don't have dom_id=4 AND Date_Start="2010-03-16 06:00:00" AND Date_End="2010-03-16 06:59:59" he create by in INSERT) (a IF NO EXIST ?) thanks Stephane -- MySQL General Mai

Mysql Performence config ?

~30 000 000 of entry for ~3.5Go Thanks for your help Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Charset and collation question

Hi all, Which charset and collatio would be the most suitable for a french / english system? Thanks Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my-medium vs my-huge cnf files

c and the my-huge configuration runs it in about 35 to 50 sec its never the same. Doesn't the my-huge suppose to be more efficient and faster when you have the memory to handle it? Or will I only see a difference running a test with multiple concurrent queries? Thanks in advance!

Mysql overall stability

Hi all, I've was wondering if anyone is using MySql as their main ERP production database, if so how stable and reliable is it? Thanks for your comments Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

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

RE: SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension

Message- From: Stephane Carre To: [EMAIL PROTECTED] Sent: 7/13/04 5:01 AM Subject: SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension I am using MySQL 4.0.18 on Windows. I want to give my users the possibility to change their MySQL password after they log in. T

SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension

I am using MySQL 4.0.18 on Windows. I want to give my users the possibility to change their MySQL password after they log in. The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the user has been created with no specific host extension in the mysql database (corresponding to

mysqld got signal 11;

ot sure if these would help me out. Does anyone have any suggestions for me to try and what other information I might be able to provide? Thank you, Stephane Raimbault. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Storing a BLOB in a MySQL database with the MySQL C API

*tmp" Could i send you my code ? because i don't find the solution of my problem. Best Regards Stephane Wirtel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Storing a BLOB in a MySQL database with the MySQL C API

res = mysql_store_result(mysql)) ) g_error("Failed Store Result : Error : %s\n", mysql_error(mysql)); mysql_field = mysql_fetch_field(mysql_res); g_print("Field name : %s\n", mysql_field->name);

RE: how to change mysql root password

Hi everyone.. I have a related problem with my mysql 3.23.54 on a RH7.3... Assigning the root password is ok with Mysqladmin -u root password 'newpassword' but when trying to do Mysqladmin -u root -h myhost.mydomain.tld password 'newpassword' i have the following... ./mysqladmin: connect to se

How to insert an Image in a table with libmysqlclient and API C ?

Hi all, my problem is the following, it's possible to insert an image in a table with the libmysqlclient ? My language is C i'm working with GNU/Linux Best Regards, Stephane Wirtel - Before posting, please chec

pbm on install 3.23.54

ck set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M So my question is, does anybody sees why i have these errors ? I run with a RH7.3 TIA Stephane - Before posting,

table Mysql.user doesn't exist

elp would be h helpful (c) monty python Regards Stephane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Re MySQL on Redhat 7.3

that you may want to use: * `--with-berkeley-db' * `--with-innodb' * `--with-raid' * `--with-libwrap' * `--with-named-z-lib (This is done for some of the binaries)' * `--with-debug[=full]' Have fun ;-)) Step

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

Compiling mysql on HP-UX

I want to install my sql on an HP-UX 10.20. I made ./configure with the options for HP-UX 10.20, as on the officiel site and I had no problem. But when I do "make", I have this error : why ? gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I.. -D__STDC_EXT__ -O3 -DDBUG_OFF -

Compiling on apache.

I have a problem with compiling mysql on HP-UX. I can't compile because it doesn't know that I have gcc. I have this error with ./configure : checking for gcc... cc checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes checking whether the C compiler (cc -Ae -D_REENTRANT ) is a c

Re: Commands...

;mysql'" <[EMAIL PROTECTED]> Cc: "Stephane Collas" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 7:20 PM Subject: RE: Commands... > * Stephane Collas > > Have installed: > > mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) > > >

Commands...

Hi all, Have installed: mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) I use a Win2K Pro, and downloaded it from http://www.myqsl.com The problem is that a lot of commands are missing, like CREATE TABLE, or even SHOW TABLE Any help? Regards Steph -

[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

Re: upgrade from SUSE7.0 solution...

t password 'your_password_here' instead of /usr/bin/mysqladmin -u root -h localhost password 'new-password' -p ?... thanks for the answer given on this list... Stephane - Before posting, please check: h

Re: upgrade from SUSE7.0

nstall the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - Before posting, please check: h

upgrade from SUSE7.0

min: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... TIA stephane - Before posting, please che

installation

have any mysqladmin anywhere on the disk, and especially not on /usr/bin... anyone had the same problem ?... TIA Stephane Parenton - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

[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

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] 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

[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

Connection from a computer to the server with mysql on it

Hello,I installed Mysql 31 on a server with an NT platform.Before that there was a Mysql 23 on it.When it is installed I made new users on it.I did it like that.GRANT ALL PRIVILEGES ON *.* TO dbuser@***.***.***.***(ip-address) IDENTIFIED BY 'password' WITH GRANT OPTION;When that is done I ca

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