MySQLWorkbench 8.0.23 crashes for me on startup on macOS 11.1, but downgrading to 8.0.22 from MySQL archives allows it to startup without a problem. This bug is reported to the MySQL bug tracker: https://bugs.mysql.com/bug.php?id=102284
It turns out that VC++ 2017 redistributables are the culprit because they delete the registry keys used by VC++ 2015 redistributables. See this Microsoft Developer Community page for solution (TL;DR; you have to repair VC++ 2017 redistributables as this will restore missing 2015 registry keys). This process is as Eric describes: The steps are essentially: … Read more
In 5.7 the sqlmode is set by default to: ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION To remove the clause ONLY_FULL_GROUP_BY you can do this: SET sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”)); This supposed you need to make that GROUP BY with non aggregated columns. Regards
You cannot use MySQL Workbench as a Microsoft SQL Server client. But technically speaking, yes, you can connect to a Microsoft SQL Server database using ODBC if you are using the database migration wizard. Source: https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-connection.html
Always use Load Data Infile as a first attempt for huge sets of data. Mysql Manual page on Load Data Infile. Wrote up several answers for this question, but for a peer comparison, see this guy’s question and my Answer and his time comparisons of Workbench vs Load Data Infile.
Workaround for me: Create file named mysqldump.cmd with contents: @echo off “c:\Program Files\MySQL\MySQL Workbench 8.0 CE\mysqldump.exe” %* –column-statistics=0 (replace path to mysqldump.exe if necessary) Open MySQL Workbench and go to Edit > Preferences > Administration, change path to mysqldump tool and point it to mysqldump.cmd
This is likely because you have named at least one constraint with the same identifier as a column: /* You already have a column named `restaurant` in this table, but are naming the FK CONSTRAINT `restaurant` also… */ CONSTRAINT `restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO … Read more
To get an individual table’s creation script: just right click on the table name and click Copy to Clipboard > Create Statement. To enable the File: Forward Engineering SQL_CREATE Script.. option and to get the creation script for your entire database: Database > Reverse Engineer (Ctrl+R) Go through the steps to create the EER Diagram … Read more
If you just want to do a single table through the MySQL Workbench. In MySQL Workbench: Connect to a MySQL Server Expand a Database Right Click on a table Select Copy To Clipboard Select Create Statement A create statement for the table will be copied to your clipboard similar to the below: CREATE TABLE `cache` … Read more
I know this is old but the usual culprits are Non Null flag and Unsigned. Make sure you do match these on the foreign key column if the referenced column does have them enabled.