Skip to content

Instantly share code, notes, and snippets.

@paulozullu
Created March 4, 2022 11:30
Show Gist options
  • Save paulozullu/3bfba0a0c56ed8a36bf1f3d16dec5c6e to your computer and use it in GitHub Desktop.
Save paulozullu/3bfba0a0c56ed8a36bf1f3d16dec5c6e to your computer and use it in GitHub Desktop.
mySQL / phpAdmin

1 - Fix error on importing database

Error message: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message.

SET @ORIG_SQL_REQUIRE_PRIMARY_KEY = @@SQL_REQUIRE_PRIMARY_KEY;
SET SQL_REQUIRE_PRIMARY_KEY = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment