Is there a naming convention for MySQL?
Here’s how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I … Read more
mysql-workbench
How to get ER model of database from server with Workbench
Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench? 4 … Read more
MySQL Workbench: How to keep the connection alive
Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, … Read more
String concatenation in MySQL
I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn’t work : … Read more
Create a new database with MySQL Workbench
Being new to MySQL, I have installed the latest version of the MySQL Workbench (5.2.33). I would like to know how you can … Read more
How do I enlarge an EER Diagram in MySQL Workbench?
I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. … Read more
Error Code: 2013. Lost connection to MySQL server during query
I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a … Read more
MySQL: How to allow remote connection to mysql
I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect … Read more
Authentication plugin ‘caching_sha2_password’ cannot be loaded
I am connecting MySQL – 8.0 with MySQL Workbench and getting the below error: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image … Read more
MySQL error code: 1175 during UPDATE in MySQL Workbench
I’m trying to update the column visited to give it the value 1. I use MySQL workbench, and I’m writing the statement in … Read more