Re: cascade on delete problem

Gleb Paharenko Fri, 28 Jan 2005 06:30:13 -0800

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 [EMAIL PROTECTED] IDENTIFIED BY 'spurcell' WITH 
GRANT

OPTION;

CREATE DATABASE builder2;

use builder2;

CREATE TABLE menu_sequence (id INT NOT NULL);

insert into menu_sequence VALUES (0);

 CREATE TABLE MENU_GROUP (

 id int NOT NULL,

parent_id int NOT NULL DEFAULT '0',

sort int,     

visible VARCHAR(1) NOT NULL DEFAULT 'T',

);

ALTER TABLE MENU_GROUP ADD CONSTRAINT PK_MENU_GROUP PRIMARY KEY(id);



UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 0, 1, 'T');

UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 0, 2, 'T');

UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 0, 3, 'T');

menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 0, 4, 'T');

UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 1, 1, 'T');

UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 3, 1, 'T');

UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);

INSERT INTO MENU_GROUP values (last_insert_id(), 4, 1, 'T');

TABLE MENU_TYPE (

id INT NOT NULL AUTO_INCREMENT,

attribute_type varchar(200) NOT NULL,

primary key (id)

);

INSERT INTO MENU_TYPE (attribute_type) values ('jsp'), ('menu'), ('cat_name');

CREATE TABLE MENU_GROUP_REL (

menu_type varchar(200),

data_id int NOT NULL,

display_name varchar(250),

link varchar(250),

);

ALTER TABLE MENU_GROUP ADD CONSTRAINT PK_MENU_GROUP_REL FOREIGN KEY(data_id) 
REFERENCES

MENU_GROUP(id) ON DELETE CASCADE;

INSERT INTO MENU_GROUP_REL values (1, 1, 'Company', 'companyInfo.jsp');

INSERT INTO MENU_GROUP_REL values (3, 2, 'Communities', 'communities');

INSERT INTO MENU_GROUP_REL values (1, 3, 'Contact', 'contact.jsp');

INSERT INTO MENU_GROUP_REL values (1, 4, 'Inventory Homes', 'invHomes.jsp');

INSERT INTO MENU_GROUP_REL values (1, 5, 'About Me', 'about.jsp');

INSERT INTO MENU_GROUP_REL values (1, 6, 'Customer Service', 'custService.jsp');

INSERT INTO MENU_GROUP_REL values (1, 7, 'Open Sunday', 
'opensunday.jsp');"Scott Purcell" <[EMAIL PROTECTED]> wrote:

[snip]



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




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

Re: cascade on delete problem

Reply via email to