RE: triggers or stored procedures

Hi, I would agree with Martijn that both features are important. It is like arguing if air conditioning is more important than automatic gearbox when you buy a car. They are both useful but which one you go for depends on where and how you drive the car. Personally, I would have both and also l

RE: mysqldump problem

uot;UNLOCK TABLES;" in the middle of the insertion block. Hence, the syntax error during restoration. Is this a mysqldump bug? Regards, Gilbert -Original Message- From: Gilbert Wu Sent: 24 May 2004 17:10 To: Brian Reichert Cc: [EMAIL PROTECTED] Subject: RE: mysqldump problem Sorr

RE: mysqldump problem

Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server. -Original Message- From: Brian Reichert [mailto:[EMAIL PROTECTED] Sent: 24 May 2004 15:42 To: Gilbert Wu Cc: [EMAIL PROTECTED] Subject: Re: mysqldump problem On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote: >

mysqldump problem

abase I can backup and restore? Many Thanks. Regards, Gilbert Wu [EMAIL PROTECTED] <http://www.sabrefund.com/> http://www.sabrefund.com/ Sabre Fund Management Limited Windsor House 55 St James's Street London SW1A 1LA Tel +44 20 7316 2820 Fax +44 20 7316 0180

OLEDB Provider for Mysql

Hi, We are developing in Microsoft's C++.NET with MS SQL Server as the underlying DBMS. We are planning to move to MySQL.Please kindly advise if there is a OLEDB provider for MySQL? or do I have to stay with ODBC? Many thanks. Gilbert Wu -- MySQL General Mailing List For list archives:

RE: Need DSN less help

Try something similar to this: ConStr = "Provider=MSDASQL;DRIVER=MYSQL ODBC 3.51 DRIVER;SERVER=ABC;DATABASE=MYDATABASE;UID=root" Gilbert Wu [EMAIL PROTECTED] http://www.sabrefund.com Sabre Fund Management Limited Windsor House 55 St James's Street London SW1A 1LA Tel +

Dr. Watson error

ace showed the following calls before it died: msafd!WSPGetSockOpt ws2_32!WSARecv wsock32!recv ! RtlpWaitForCriticalSection RtlEnableEarlyCriticalSectionEventCreation. I wonder if any of our fellow mysql users has experienced a similar problem? Regards, Gilbert Wu -- MySQL General Mailing Lis

RE: Transactions tutorial

Try Microsoft's "Inside SQL Server 2000" by Delaney. -Original Message- From: Thomas Svenson [mailto:[EMAIL PROTECTED] Sent: 15 August 2003 01:44 To: MySQL list Subject: Transactions tutorial I'm looking for any online resources/tutorials and such about transactions. Preferable for MySQL

RE: alter date

Is mysql still in business? Their web page is down. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem restoring database from a sql file created by mysqldump

Hi, I used the command similar to the following to dump out both the structure and contents of my database: mysqldump -F -u root --opt tradingdata >"c:tradingdatadump.sql" I got an error half way through restoring the database into another test database using the following command: mysql -u r

RE: Transactions

Have you considered writing your own DBMS as well? -Original Message- From: Patrick [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 23:03 To: Dan Nelson Cc: mysqllist Subject: Re: Transactions Well said Dan. While foreign keys, cascades and built-in transactions are convenient, atomicity a

Problem in connecting to mysql from MSAccess 2000

27; to database 'tradingdata' (#1044). Any help would be much appreciated. Regards, Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQLDump

Message- From: Sent: 15 July 2003 17:11 To: Gilbert Wu Subject: Re: MySQLDump sure, just tell it to lock the tables while it does the dump. curtis On Tuesday 15 July 2003 12:02, Gilbert Wu wrote: > Hi, > > I am new to MySQL. I wonder if someone could tell me if I can run MySQLDu

MySQLDump

. Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]