Sfrgttk

Chess with symmetric move-square

Draw simple lines in Inkscape

I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)

Are tax years 2016 & 2017 back taxes deductible for tax year 2018?

How do you conduct xenoanthropology after first contact?

"You are your self first supporter", a more proper way to say it

Why is this code 6.5x slower with optimizations enabled?

Can Medicine checks be used, with decent rolls, to completely mitigate the risk of death from ongoing damage?

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

Why are only specific transaction types accepted into the mempool?

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

What would the Romans have called "sorcery"?

whey we use polarized capacitor?

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

What makes Graph invariants so useful/important?

If Manufacturer spice model and Datasheet give different values which should I use?

A function which translates a sentence to title-case

Why is the design of haulage companies so “special”?

Why are 150k or 200k jobs considered good when there are 300k+ births a month?

How to report a triplet of septets in NMR tabulation?

referntial integrity issue with two tables cant delete a record

Unexplained InnoDB timeoutsFinding rows for a specified date rangeSimple query is slow on 4M-rows tableOptimizing a simple query on a large tableDon't know why MySQL is not creating table with primary key constraintHow to improve query count execution with mySql replicate?MySQL query taking too longMySQLDump issue with a special charactersNeed help in writing stored procedures in MYSQL?slow queries on indexed columns (large datasets)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

So I am trying to delete a record from customers table. I would assume it's a referential integrity issue, however I don't really see what is wrong with it. Could anyone shed some light? Please and Thanks. Error Message below

 DELETE FROM customers

        WHERE customer_id = 1

table structures:

    CREATE TABLE  payment_details  (

    paytype_id varchar(10),

   card_no  int(8) NOT NULL,

   customer_id  int(50)  NOT NULL,

   CVV  int(3) NOT NULL,

   card_type  ENUM ('Visa', 'Amex', 'American Express', 'Mastercard') NOT NULL,

   expiry_date  DATE NOT NULL,

   PRIMARY KEY(paytype_id),

   KEY customer_idfk1 (customer_id),

   CONSTRAINT customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and

CREATE TABLE  customers  (

   customer_id  int(50)  NOT NULL AUTO_INCREMENT,

   fname  varchar(20) NOT NULL,

   lname  varchar(20) NOT NULL,

   dateOfBirth date NOT NULL,

   address  varchar(30) NOT NULL,

   city  varchar(20) NOT NULL,

   county  ENUM('Armagh','Carlow','Cavan','Clare','Cork','Derry','Donegal','Down','Dublin','Fermanagh','Galway','Kerry','Kildare','Kilkenny','Laois','Leitrim','Limerick','Longford','Louth','Mayo','Meath','Monaghan','Offaly','Roscommon','Sligo','Tipperary','Tyrone','Waterford','Westmeath','Wexford','Wicklow') NOT NULL,

   phone  int(10) NOT NULL,

   email  varchar(20) NOT NULL,

   payment_method  ENUM ('Visa', 'Amex', 'Cash', 'American Express', 'Mastercard') NOT NULL,

   valid_licence varchar(5) NOT NULL,

   status  varchar(10),

   PRIMARY KEY (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

error - #1451 - Cannot delete or update a parent row: a foreign key
constraint fails (g00337857abu.payment_details, CONSTRAINT
customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers
(customer_id))

mysql

share

asked 9 mins ago

GrubertusinoGrubertusino

22

add a comment | 

0

So I am trying to delete a record from customers table. I would assume it's a referential integrity issue, however I don't really see what is wrong with it. Could anyone shed some light? Please and Thanks. Error Message below

 DELETE FROM customers

        WHERE customer_id = 1

table structures:

    CREATE TABLE  payment_details  (

    paytype_id varchar(10),

   card_no  int(8) NOT NULL,

   customer_id  int(50)  NOT NULL,

   CVV  int(3) NOT NULL,

   card_type  ENUM ('Visa', 'Amex', 'American Express', 'Mastercard') NOT NULL,

   expiry_date  DATE NOT NULL,

   PRIMARY KEY(paytype_id),

   KEY customer_idfk1 (customer_id),

   CONSTRAINT customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and

CREATE TABLE  customers  (

   customer_id  int(50)  NOT NULL AUTO_INCREMENT,

   fname  varchar(20) NOT NULL,

   lname  varchar(20) NOT NULL,

   dateOfBirth date NOT NULL,

   address  varchar(30) NOT NULL,

   city  varchar(20) NOT NULL,

   county  ENUM('Armagh','Carlow','Cavan','Clare','Cork','Derry','Donegal','Down','Dublin','Fermanagh','Galway','Kerry','Kildare','Kilkenny','Laois','Leitrim','Limerick','Longford','Louth','Mayo','Meath','Monaghan','Offaly','Roscommon','Sligo','Tipperary','Tyrone','Waterford','Westmeath','Wexford','Wicklow') NOT NULL,

   phone  int(10) NOT NULL,

   email  varchar(20) NOT NULL,

   payment_method  ENUM ('Visa', 'Amex', 'Cash', 'American Express', 'Mastercard') NOT NULL,

   valid_licence varchar(5) NOT NULL,

   status  varchar(10),

   PRIMARY KEY (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

error - #1451 - Cannot delete or update a parent row: a foreign key
constraint fails (g00337857abu.payment_details, CONSTRAINT
customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers
(customer_id))

mysql

share

asked 9 mins ago

GrubertusinoGrubertusino

22

add a comment | 

So I am trying to delete a record from customers table. I would assume it's a referential integrity issue, however I don't really see what is wrong with it. Could anyone shed some light? Please and Thanks. Error Message below

 DELETE FROM customers

        WHERE customer_id = 1

table structures:

    CREATE TABLE  payment_details  (

    paytype_id varchar(10),

   card_no  int(8) NOT NULL,

   customer_id  int(50)  NOT NULL,

   CVV  int(3) NOT NULL,

   card_type  ENUM ('Visa', 'Amex', 'American Express', 'Mastercard') NOT NULL,

   expiry_date  DATE NOT NULL,

   PRIMARY KEY(paytype_id),

   KEY customer_idfk1 (customer_id),

   CONSTRAINT customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and

CREATE TABLE  customers  (

   customer_id  int(50)  NOT NULL AUTO_INCREMENT,

   fname  varchar(20) NOT NULL,

   lname  varchar(20) NOT NULL,

   dateOfBirth date NOT NULL,

   address  varchar(30) NOT NULL,

   city  varchar(20) NOT NULL,

   county  ENUM('Armagh','Carlow','Cavan','Clare','Cork','Derry','Donegal','Down','Dublin','Fermanagh','Galway','Kerry','Kildare','Kilkenny','Laois','Leitrim','Limerick','Longford','Louth','Mayo','Meath','Monaghan','Offaly','Roscommon','Sligo','Tipperary','Tyrone','Waterford','Westmeath','Wexford','Wicklow') NOT NULL,

   phone  int(10) NOT NULL,

   email  varchar(20) NOT NULL,

   payment_method  ENUM ('Visa', 'Amex', 'Cash', 'American Express', 'Mastercard') NOT NULL,

   valid_licence varchar(5) NOT NULL,

   status  varchar(10),

   PRIMARY KEY (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

error - #1451 - Cannot delete or update a parent row: a foreign key
constraint fails (g00337857abu.payment_details, CONSTRAINT
customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers
(customer_id))

mysql

share

asked 9 mins ago

GrubertusinoGrubertusino

22

 DELETE FROM customers

        WHERE customer_id = 1

    CREATE TABLE  payment_details  (

    paytype_id varchar(10),

   card_no  int(8) NOT NULL,

   customer_id  int(50)  NOT NULL,

   CVV  int(3) NOT NULL,

   card_type  ENUM ('Visa', 'Amex', 'American Express', 'Mastercard') NOT NULL,

   expiry_date  DATE NOT NULL,

   PRIMARY KEY(paytype_id),

   KEY customer_idfk1 (customer_id),

   CONSTRAINT customer_idfk1 FOREIGN KEY (customer_id) REFERENCES customers (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE  customers  (

   customer_id  int(50)  NOT NULL AUTO_INCREMENT,

   fname  varchar(20) NOT NULL,

   lname  varchar(20) NOT NULL,

   dateOfBirth date NOT NULL,

   address  varchar(30) NOT NULL,

   city  varchar(20) NOT NULL,

   county  ENUM('Armagh','Carlow','Cavan','Clare','Cork','Derry','Donegal','Down','Dublin','Fermanagh','Galway','Kerry','Kildare','Kilkenny','Laois','Leitrim','Limerick','Longford','Louth','Mayo','Meath','Monaghan','Offaly','Roscommon','Sligo','Tipperary','Tyrone','Waterford','Westmeath','Wexford','Wicklow') NOT NULL,

   phone  int(10) NOT NULL,

   email  varchar(20) NOT NULL,

   payment_method  ENUM ('Visa', 'Amex', 'Cash', 'American Express', 'Mastercard') NOT NULL,

   valid_licence varchar(5) NOT NULL,

   status  varchar(10),

   PRIMARY KEY (customer_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

share

asked 9 mins ago

GrubertusinoGrubertusino

22

share

asked 9 mins ago

GrubertusinoGrubertusino

22

asked 9 mins ago

GrubertusinoGrubertusino

22

asked 9 mins ago

GrubertusinoGrubertusino

22