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 ->
ncountered something 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://li
machine and execute :
>
> $ mysql -u tfiedler 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" par
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"
e in the table.
>
> I want to do something 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 Li
column in your table 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]
