MySQL Workbench auto increment disabled
You need to set auto increment in table
mysql-workbench
MySQL Workbench not displaying query results
This is a known bug: link. Upcoming release 6.2.2 fixes this for OS X (Unfortunately, Linux version is still broken). At least on my computer it’s not dissapeared, just folded, and it’s edge is almost merged with the edge of ‘Action Output’ block. When you move your mouse to that edge, the cursor starts looking … Read more
How can I directly view blobs in MySQL Workbench
In short: Go to Edit > Preferences Choose SQL Editor Under SQL Execution, check Treat BINARY/VARBINARY as nonbinary character string Restart MySQL Workbench (you will not be prompted or informed of this requirement). In MySQL Workbench 6.0+ Go to Edit > Preferences Choose SQL Queries Under Query Results, check Treat BINARY/VARBINARY as nonbinary character string … Read more
How to export table data in MySql Workbench to csv?
You can select the rows from the table you want to export in the MySQL Workbench SQL Editor. You will find an Export button in the resultset that will allow you to export the records to a CSV file, as shown in the following image: Please also keep in mind that by default MySQL Workbench … Read more
MySQL Workbench 6.3 (Mac) hangs on simple queries
UPDATE 3: The problem is fixed for MacOS HighSierra in MySQL Workbench 6.3.10. UPDATE 2: It looks like the bug is recurring again in MacOS HighSierra. See https://bugs.mysql.com/bug.php?id=83658 for more details. There is an unofficial build that fixes the problem. You can download it at: https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing The build was created by Bob Davenport. See https://bugs.mysql.com/bug.php?id=87714 … Read more
How to get a table creation script in MySQL Workbench?
I cannot find such an option either, at least in the Community edition. I suppose this corresponds to the Reverse Engineering feature, which, unfortunately, is only available in the commercial edition (quoting) : reverse engineering a database directly from a MySQL server applies to commercial versions of MySQL Workbench only. Still, you can use plain-SQL … Read more
Export Data from mysql Workbench 6.0
mysqldump: [ERROR] unknown variable ‘delayed-insert=FALSE’ This error occurs on various systems and can be temporarily fixed by: Going to the appropriate directory depending on the system: a) Windows: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules (32-bit installation on x64 systems: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules) b) Mac OS X: Applications/MYSQLWorkbench.app/Contents/Resources/plugins – right click on the app … Read more
MySQL Workbench Edit Table Data is read only
I’m assuming the table has a primary key. First try to run a unlock tables command to see if that fixes it. If all else fails you can alter the table to create a new primary key column with auto-increment and that should hopefully fix it. Once you’re done you should be able to remove … Read more
SELECT INTO Variable in MySQL DECLARE causes syntax error?
I ran into this same issue, but I think I know what’s causing the confusion. If you use MySQL Query Analyzer, you can do this just fine: SELECT myvalue INTO @myvar FROM mytable WHERE anothervalue = 1; However, if you put that same query in MySQL Workbench, it will throw a syntax error. I don’t … Read more
How to view table contents in Mysql Workbench GUI?
Open a connection to your server first (SQL IDE) from the home screen. Then use the context menu in the schema tree to run a query that simply selects rows from the selected table. The LIMIT attached to that is to avoid reading too many rows by accident. This limit can be switched off (or … Read more