Multiple revision of a record

Hi I am a beginner to mySQL so I hope this is not a too basic question I'd like to be able to track changes made to the attribute of one record, without wanting to duplicate the complete record each time . How an I achieve this? Thanks laurent -- MySQL General Mailing List For list

Re: Multiple revision of a record

Thanks to all for the answers. I have now some tries to do! Laurent Sent from my iPhone On Mar 4, 2008, at 5:58 PM, Jerry Schwartz [EMAIL PROTECTED] infoshop.com wrote: The tack we take is to have a separate table that tracks changes. It does, of necessity, contain the same fields

key words: problem to start the MySql Server

Hello, My name is Laurent (from Belgium) and I got some problems to start the MySql server. 1)I installed the 5.0 version a few days a go. I followed the manual how to install Mysql according to my machine : windows XP (service pack 2).I choosed the standard version and the installation

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

this working? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2002: Can't connect to local MySQL server through socket var/lib/mysql/mysql.sock' (2)

it and restart mysqld and find it working :-) ... but it still doesn't work... I checked the runlevel editor where mysql was not started, so it's no miracle it doesn't work! After ahving the new Mysql 4.0 Server installed, I started that service in runlevel editor and now it ssems to work! Laurent

ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)

User mysqladmin has not the rights to access mysql? How can that be? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

try. Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Upgrade to MySQL 4.1.0-alpha [No Virus found]

Hello, I'm trying to upgrade to version 4.1.0-alpha of MySQL from version 3.23.51 on a Windows 2000 platform. I've downloaded the binary distribution of 4.1.0-alpha and followed the install process(README.1st) for an upgrade install. At the step : * Execute the

Re: core dump in clients in MYSQL 3.23.49 using groups

Sinisa Milivojevic wrote: This seems worth investigating. Please send me your entire /etc/my.cnf Change password if you have defined it there. The full my.cnf I have used has been send in the report without change. snip--- [bug] host=foobar snip--- If the the group

Re: core dump in clients in MYSQL 3.23.49 using groups

Sinisa Milivojevic wrote: Do you mean that you have defined a group as [bug] ??? Yes. I've discovered the problem upgrading a server and reproduced it with minimal C program and minimal my.cnf on another host. Does it change anything if spaces are trimmed of host=foobar line ?? No. The

Re: optimization of large records

you can do some profiling of your application to pinpoint where the bottlenecks are. -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http://liafa.jussieu.fr

Re: 64bit mysql and gcc

] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http

Re: Obtaining MySQL for Solaris 8, Intel Version

On Wed, Sep 26, 2001 at 12:41:43PM -0700, Pauljames Dimitriu wrote: Hello, Where can I get a version of MySQL for Solaris 8, Intel version? Do I use the FreeBSD version of MySQL or should I d/l the Linux version? I am just getting used to the Solaris / UNIX environment. I do

Re: Client-side developing

On Tue, Sep 25, 2001 at 06:26:58PM -0300, Walter Omar Autalán wrote: Hi. Please, excuse me for this Off topic message. I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must

Re: C API problem

reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' looks like you have a version of libc that is too old -- Laurent Oget, Ph.D. [EMAIL PROTECTED

Re: moving database to another computer

someone help me? Thanks. Ming Hsu this is usually a good occasion to clean up databases, but if you do not want to do that you can use mysqldump, compress the file and then have mysql read the dump file. You do need a telnet access to that machine though. -- Laurent Oget, Ph.D

UPDATE using other table

Is there a way to update a column of a table using values from other tables something like update table1 set table1.column1=table2.column1 where table1.column2=table2.column1 -- Laurent Oget, Ph.D. [EMAIL PROTECTED] Senior Engineer Zvolve Systems Inc http://zvolve.com