mercredi 20 janvier 2021

Cannot Import Wordpress Website to MySQL Database

Here is my error: `SQL query:

--
-- Database: `nicolebrem1`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_amd_zlrecipe_recipes`
--

CREATE TABLE IF NOT EXISTS `wp_amd_zlrecipe_recipes` (
  `recipe_id` bigint(20) unsigned NOT NULL auto_increment,
  `post_id` bigint(20) unsigned NOT NULL,
  `recipe_title` text,
  `recipe_image` text,
  `summary` text,
  `rating` text,
  `prep_time` text,
  `cook_time` text,
  `total_time` text,
  `yield` text,
  `serving_size` varchar(50) default NULL,
  `calories` varchar(50) default NULL,
  `fat` varchar(50) default NULL,
  `ingredients` text,
  `instructions` text,
  `notes` text,
  `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
MySQL said: Documentation

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key`



Aucun commentaire:

Enregistrer un commentaire