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 Workbench could not detect any MySQL server running. This means that MySQL is not installed or is not running.
- Fix: pip install mysqlclient error: subprocess-exited-with-error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL: Error Code: 1175 You are using safe update mode
- Display List of Databases in mysql Command Line
- How to install MySQL Workbench on Mac (M1/M2)
- [macOS] Fix: MySQL ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- MySQL: How to know which Database Schema you are on in Terminal
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL Workbench - Connection Warning - Incompatible/nonstandard server version or connection protocol detected
- MySQL: How to Select Database via Terminal/Command Line
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Connection Failed: 1130 PHP MySQL Error
- Identify MySQL version in MySQL Command Line Prompt
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- How to Create Database in MySQL
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to query database table names [MySQL/Oracle/SQL Server]
- How to clear MySQL Console Screen
More Posts:
- Add Text at Start and End of Each Line Notepad++ - NotepadPlusPlus
- How to Comment out Code in PowerShell Script - Powershell
- How to make a Android button act as a toggle button - Android
- How to add hours and minutes to Java Instant - Java
- PHP 301 Redirect Permanently - PHP
- Round Number up to 2 decimal places in Python - Python
- Accept Only 0-9 Numbers RegEx Example - HowTos
- Take input argument from command line in Python Programming - Python