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 generally (not always) have a auto increment PK. I use the following convention: tablename_id (e.g. foo_id, foo_bar_id, etc.). When a table contains a column that is a foreign key, I just copy … Read more
Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench? 4 Answers 4
Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;…mysource3…mysource4 multiplied 1000 times) Each batch takes a considerable amount of time, some of … Read more
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 : select first_name + last_name as “Name” from test.student 5 Answers 5
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 create a database with this application. In the Overview tab of the SQL editor there are few “MySQL Schema” displayed, are these schemas the existing databases? 10 Answers 10
I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. Does anyone know how to enlarge it to two or more pages? 7 Answers 7
I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away to increase the timeout value? 35 Answers 35 New versions of MySQL WorkBench have … Read more
I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that? 17 Answers 17
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 not found I have tried with other client tool as well. Any solution for this? 33 s 33
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 the SQL editor from inside the workbench. I’m writing the following command: UPDATE tablename SET columnname=1; It gives me the following error: You are using safe update mode and you tried to … Read more
