mysqlsqlyog
Can not able to set foreign key in mysql db using SqlYog
Getting error while setting foreign key to table as shown in image.
Database Version: MySql 5.6
Solution
Change Engine to InnoDB
Check the difference between MyISAM and InnoDB here to make suitable decision for your database design
- How to install com.mysql.jdbc.Driver "Could not find driver with class name: com.mysql.jdbc.Driver"?
- MySQLConnector c# update MySqlCommand parameters
- INSERT INTO after WITH statement in MySQL
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- Connect to mysql in a docker container from the host
- Executing SQL scripts on docker container
- XAMPP - Error: MySQL shutdown unexpectedly
- Undefined Module Mysl - Ballerina
- DBeaver error resolving maven dependencies
- ERROR - Must Declare Scalar Variable - C#
- Cannot delete or update a parent row: a foreign key constraint fails. Foreign keys exist though
- MySQL: IF EXISTS ... TRUNCATE
- mysql COUNT and Sum with join 2 tables
- Install Navicat on Linux Ubuntu 12.04
- How do I set MySQL temporarily to read-only through the command line?
- How to increment column values with CodeIgniter's update_batch()
- str_to_date is showing NULL when date is available
- Can I use a variable from the GET_ method to fetch MySQL data?
- select ... where id = any value. is it possible?
- Data truncated for column?
- Unable to install MySQL on Windows 10 - Installer hangs indefinitely
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- MySQL Workbench: Connecting to database automatically on the startup
- Select rows for a specific date using TIMESTAMP datatype
- GoLang How to load nested objects using GORM
- What COLLATE should i set to use all kind of possible languages?
- MYSQL - SELECT NULL otherwise latest DATE per group
- How do I set up replication from MySQL to MongoDB?
- NULL when value not found using substring_index in MYSQL
- How to convert an entire MySQL database characterset and collation to UTF-8?