MySQL Forums
Forum List  »  MySQL Workbench

Re: Table create fails
Posted by: Peter Brawley
Date: August 13, 2021 02:50PM

> I can't spell and I'm dyslexic.

If you're going to be working with databases, you'll need to develop robust error-fixing workarounds for that problem..

Then, does the referenced table 'wp_wpinventory_item' exist? If not, create it before x=creating any tables which depend upon its existence. If so, let's see the result of ...

show create table wp_wpinventory_item;

Similarly, the constraint ...

Quote

2 CONSTRAINT `fk_inventorycaegory_category`
FOREIGN KEY (`categoy_id`)
REFERENCES `abbott_wp6`.`wp_wpinventory_category` (`category_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)

.. requires the existence of the wp_wpinventory_category table.

Options: ReplyQuote


Subject
Views
Written By
Posted
1214
August 13, 2021 11:56AM
371
August 13, 2021 12:20PM
404
August 13, 2021 02:11PM
458
August 13, 2021 02:32PM
Re: Table create fails
398
August 13, 2021 02:50PM
376
August 14, 2021 02:53PM
372
August 14, 2021 03:49PM
366
August 15, 2021 08:40AM
348
August 15, 2021 12:37PM
326
August 16, 2021 12:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.