Re: REPLACE INTO and CASCADEs.

2004-02-16 Thread Tan Shao Yi
that can simulate the UPSERT. :) Thanking in advance. Regards, Tan Shao Yi - Original Message - From: Heikki Tuuri Date: February 16 2004 9:12am Subject: Re: REPLACE INTO and CASCADEs. Hi! The REPLACE + FOREIGN KEY behavior indeed changed between 4.0.17 - 4.0.18, because the old behavior

REPLACE INTO and CASCADEs.

2004-02-14 Thread Tan Shao Yi
similar? I have only one box available so I am not able to re-test my observations again (I have reverted to 4.0.17). Thanking in advance. Regards, Tan Shao Yi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Backup Recover Database

2004-02-06 Thread Tan Shao Yi
BigData db_backup.sql ERROR 1044: Access denied for user: '@localhost' to database 'BigData' Hello, You specified a -p to the mysqldump command. Would you like to try specifying the -p parameter to the mysql command too? :) Cheers, Tan Shao Yi -- MySQL General Mailing List For list archives

Re: Bind on Unix Socket: Permission Denied

2003-12-22 Thread Tan Shao Yi
On Mon, 22 Dec 2003, Aleksei Wolff wrote: I just installed the server and I am getting this message in the mysql.log when I execute: ./bin/safe_mysqld --user=mysql Hi Alex, You might want to check the permissions of your /tmp directory. Is it drwxrwxrwt? :) Regards, Tan Shao Yi -- MySQL

Re: Help with count(*)

2003-08-14 Thread Tan Shao Yi
like: select count(count(*)) from results group by user; But that doesn't work.. Hello, How about SELECT COUNT(DISTINCT user) FROM results? Hope this helps. Cheers, Tan Shao Yi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: no duplicate entries..

2003-07-20 Thread Tan Shao Yi
a primary key since it is to contain only unique values? Cheers, Tan Shao Yi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]