Error No : 1005
Error Type : Server Error
Error Code : 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)
Error Message : Can't create table '%s' (errno: %d)
This error may occur when you are trying to create a table and it fails.
There are many reasons that may cause this issue.
One of the reason is related to Foreign Key constraint that is not formed correctly (Error code 150).
MySQL QueryLanguage: SQL
CREATE TABLE `prog_lang` (
`lang_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
`lang_name` VARCHAR(100) NOT NULL,
`lang_desc` VARCHAR(255) NOT NULL,
`active_stat` CHAR(1)
);
CREATE TABLE `topic` (
`topic_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
`topic_desc` TEXT NOT NULL,
`lang_id` INT NOT NULL,
CONSTRAINT `fk_prog_lang` FOREIGN KEY(`lang_id`) REFERENCES `prog_lang`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Make sure that Engine and CHARSET of the tables match: ENGINE=InnoDB DEFAULT CHARSET=utf8.
More Posts related to MySQL,
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL Query for Schema/Structure of a Table
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- Connection Failed: 1130 PHP MySQL Error
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- How to find AUTO_INCREMENT Fields value in MySQL table
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- How to clear MySQL Console Screen
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- Fix MySQL ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- Display List of Databases in mysql Command Line
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL: How to Select Database via Terminal/Command Line
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Identify MySQL version in MySQL Command Line Prompt
More Posts:
- Best way to Convert Primitive long to int in Java with some Cautions - Java
- Android Disable EditText from Auto Focus on Activity load - Android
- How to force quit or kill Notepad++ Process - NotepadPlusPlus
- How to show Videos on SharePoint Page - SharePoint
- [fix] docker exec requires at least 2 arguments - Docker
- How to check of Updates on Microsoft Edge Browser on Mac (macOS) - MacOS
- Java JDBC NumberFormatException: For input string - Java
- Change Home Page on Safari for Mac (macOS) - MacOS