Hello.
Your syntax shouldn't work in the MySQL server (comas at the end of CREATE TABLE
statments). What type of storage engine do you use? You can see it with the
following
statement:
SHOW CREATE TABLE MENU_GROUP;
[snip]
DROP DATABASE builder2;
GRANT ALL PRIVILEGES ON *.* TO [EM
> Sent: Thursday, January 27, 2005 10:17 AM
> To: mysql@lists.mysql.com
> Subject: cascade on delete problem
>
>
> Hello,
>
> I apologize for a possible simple question, but I am having
> trouble with the below code.
>
> I have three simple tables. In short, &qu
Hello,
I apologize for a possible simple question, but I am having trouble with the
below code.
I have three simple tables. In short, "menu_group" has an id, that is
referenced in the "menu_group_rel". When a user deletes an id from the
"menu_group", I wanted the entry in "menu_group_rel" (d
Hello everyone.
I have an issue that can't figure out, and was wondering if someone can help
me with it.
I offer mySQL based e-mail account to my users.
The actual e-mails are stored in a text based directory.
Sometimes when the e-mail is put in the trashcan, it actually deletes the
e-mail folder,
Riccardi,
Wednesday, March 13, 2002, 5:48:28 PM, you wrote:
RM> Hi all,
RM> I'm trying to delete records with this query on php program:
RM> delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
RM> ID_GROUP = '$group')
RM> I use it on MSSQL and work fine but on mysql don't work
t;; Mysql List <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 5:48 PM
Subject: Delete problem
> Hi all,
>
> I'm trying to delete records with this query on php program:
> delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
> ID_GROUP = '$group')
Yes i review manual many times without success
-Messaggio originale-
Da: Rick Emery [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 13 marzo 2002 16.52
A: 'Riccardi Moreno'; Php List; Mysql List
Oggetto: RE: [PHP-DB] Delete problem
MySQL does not currently support sub-sel
: Wednesday, March 13, 2002 9:48 AM
To: Php List; Mysql List
Subject: [PHP-DB] Delete problem
Hi all,
I'm trying to delete records with this query on php program:
delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
ID_GROUP = '$group')
I use it on MSSQL and work fi
Hi all,
I'm trying to delete records with this query on php program:
delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
ID_GROUP = '$group')
I use it on MSSQL and work fine but on mysql don't work, there's some other
query that make the same result on mysql
Thank's all
---
