 1. Go to &quot;Database&quot; Menu option 
 2. Select the &quot;Reverse Engineer&quot; option.
 3. A wizard will be open and it will generate the ER Diagram for you.

I want to enhance Mr. [Kamran Ali][1]&#39;s answer with pictorial view.
Pictorial View is given step by step:
---

&gt;  1. Go to &quot;**Database**&quot; Menu option
&gt;  2. Select the &quot;**Reverse Engineer**&quot; option.

[![enter image description here][2]][2]


&gt;  3. A wizard will come. Select from &quot;**Stored Connection**&quot; and press &quot;**Next**&quot; button.

[![enter image description here][3]][3]

&gt;  4. Then &quot;**Next**&quot;..to..&quot;**Finish**&quot;

Enjoy :)

  [1]: https://stackoverflow.com/users/1065171/kamran-ali
  [2]: http://i.stack.imgur.com/14Z3H.png
  [3]: http://i.stack.imgur.com/kv1QC.png

1. Migrate your DB &quot;simply make sure the tables and columns exist&quot;. 
2. Recommended to delete all your data (this freezes MySQL Workbench on my MAC everytime due to &quot;software out of memory..&quot;)

___

1. Open MySQL Workbench
2. click + to make MySQL connection
3. enter credentials and connect
4. go to database tab
5. click reverse engineer
6. follow the wizard Next &gt; Next ….
7. DONE :)
8. now you can click the arrange tab then choose auto-layout (keep clicking it until you are satisfied with the result)

On mac, press `Command + R` or got to `Database` -&gt; `Reverse Engineer` and keep selecting your requirements and `continue` 




[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/wPi7u.png

In my Django app, I need to get the host name from the referrer in `request.META.get(&#39;HTTP_REFERER&#39;)` along with its protocol so that from URLs like:

- https://docs.google.com/spreadsheet/ccc?key=blah-blah-blah-blah#gid=1
- https://stackoverflow.com/questions/1234567/blah-blah-blah-blah
- http://www.example.com
- https://www.other-domain.com/whatever/blah/blah/?v1=0&amp;v2=blah+blah ...

I should get:

- https://docs.google.com/
- https://stackoverflow.com/
- http://www.example.com
- https://www.other-domain.com/

I looked over other related questions and found about urlparse, but that didn&#39;t do the trick since

    &gt;&gt;&gt; urlparse(request.META.get(&#39;HTTP_REFERER&#39;)).hostname
    &#39;docs.google.com&#39;


Get protocol + host name from URL

Suppose I have the following two objects:

    first_name_relation = User.where(:first_name =&gt; &#39;Tobias&#39;) # ActiveRecord::Relation
    last_name_relation  = User.where(:last_name  =&gt; &#39;F&#252;nke&#39;) # ActiveRecord::Relation

is it possible to combine the two relations to produce one `ActiveRecord::Relation` object containing both conditions?

*Note: I&#39;m aware that I can chain the wheres to get this behavior, what I&#39;m really interested in is the case where I have two separate `ActiveRecord::Relation` objects.*

Combine two ActiveRecord::Relation objects

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench?

How to get ER model of database from server with Workbench

<p>Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench?</p>


I have been trying to import Database through phpMyAdmin. My database file is `a.sql` and it&#39;s size is 1.2 GB 
I am trying to import this on local and phpMyAdmin is saying:

&gt; You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Please help I really need this to work.

Can&#39;t import database through phpmyadmin file size too large

The [MySQL documentation][1] says that it should be `\&#39;`. However, both scite and mysql shows that `&#39;&#39;` works.  I saw that and it works. What should I do?


  [1]: http://dev.mysql.com/doc/refman/5.0/en/string-literals.html#character-escape-sequences

How to escape apostrophe (&#39;) in MySql?

I have a column called CODE in a MySQL table which can be NULL. Say I have some rows with CODE=&#39;C&#39; which I want to ignore in my select result set. I can have either CODE=NULL or CODE!=&#39;C&#39; in my result set.

The following query does not return a row with CODE as NULL:

    SELECT * from TABLE where CODE!=&#39;C&#39;


But this query works as expected and I know it is the right way to do it.

    SELECT * from TABLE where CODE IS NULL OR CODE!=&#39;C&#39;

My question is why does having only CODE!=&#39;C&#39; does not return rows where CODE=NULL? Definitely &#39;C&#39; is not NULL. We are comparing no value to a character here. Can someone throw some light as why it doesn&#39;t work that way?

MySQL comparison with null value

I can run this query to get the sizes of all tables in a MySQL database:

    show table status from myDatabaseName;

I would like some help in understanding the results. I am looking for tables with the largest sizes. 

Which column should I look at?



How to get the sizes of the tables of a MySQL database?

Is there any way to get milliseconds out of a timestamp in `MySql` or `PostgreSql` (or others just out of curiosity)?

    SELECT CURRENT_TIMESTAMP
    --&gt; 2012-03-08 20:12:06.032572

Is there anything like this:

    SELECT CURRENT_MILLISEC
    --&gt; 1331255526000

or the only alternative is to use the `DATEDIFF` from the `era`?

CURRENT_TIMESTAMP in milliseconds

What is actually the difference between:

    this.HasRequired(a =&gt; a.Something)
        .WithMany()
        .Map(a =&gt; a.MapKey(&quot;SomethingId&quot;));


and


    this.HasRequired(a =&gt; a.Something)
        .WithMany()
        .HasForeignKey(a =&gt; a.SomethingId);


MapKey vs HasForeignKey Difference - Fluent Api

I want to generate an ER diagram of an SQL database using Microsoft [SQL Server Management Studio][1] (SMSS). However, I don’t know how to.

I found this technique online: *[Making ER Diagram from SQL Server 2008 Database][2]*

However, I am not able to see &quot;Database Node&quot; or &quot;Database Diagrams&quot; nodes as mentioned in the first and second steps.

Hence, how can I generate an ER diagram from an existing database?

From the comments, I realize that I was right in my understanding that *Database node* means the node with my database name. But then my problem is I am not able to find the &quot;Database Diagrams&quot; node under my Database name. What should I do so that I can see it?

PS: It’s not a local database.


  [1]: https://en.wikipedia.org/wiki/SQL_Server_Management_Studio
  [2]: http://forums.asp.net/t/1790223.aspx?Making%20ER%20Diagram%20from%20SQL%20Server%202008%20Database





How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?

I&#39;m trying to save a query result of about 1,000,000 records in MySQL Workbench.

When I run the SELECT, only 1000 records shows up (MySQL Workbench&#39;s default limit). I know I can change the limit, or remove the limit, but I don&#39;t want 1,000,000 records to be loaded into the result panel (which might crash my computer?), but I do want to save the results to a file. 

Does MySQL Workbench let you save the results of a query directly to a file? Or save the whole result set instead of the 1,000?

Exporting query results in MySQL Workbench beyond 1000 records

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?

Error Code: 2013. Lost connection to MySQL server during query

When trying Edit Table Data in MySQL Workbench 5.2.37, its in read only mode.

It is editable only if the table has a primary key.

Is there any fix to deal with table without primary key??

Thanks

As one of the suggestion I tried upgrading WB 5.2.40. But still this issue exists..
Could any one Help please..

MySQL Workbench Edit Table Data is read only

I&#39;m trying to update the column `visited` to give it the value 1. I use MySQL workbench, and I&#39;m writing the statement in the SQL editor from inside the workbench. I&#39;m writing the following command:

    UPDATE tablename SET columnname=1;

It gives me the following error:

&gt; You are using safe update mode and you tried to update a table without
&gt; a WHERE that uses a KEY column To disable safe mode, toggle the option
&gt; ....


I followed the instructions, and I unchecked the `safe update` option from the `Edit` menu then `Preferences` then `SQL Editor`. The same error still appear &amp; I&#39;m not able to update this value. Please, tell me what is wrong?

MySQL error code: 1175 during UPDATE in MySQL Workbench

Having spent a number of years working primarily with MS SQL Server (and hence SQL Server Management Studio for common tasks), I am now beginning to work with MySql. To date I have been using &lt;em&gt;MySQL Workbench&lt;/em&gt; and am generally happy with it.

I would, however, like to be able to assign &lt;strong&gt;custom keyboard shortcuts&lt;/strong&gt; for certain commands (e.g. commands from &lt;a href=&quot;http://dev.mysql.com/doc/workbench/en/wb-keys.html&quot;&gt;this list&lt;/a&gt;). For example, I&#39;d prefer to stick to the MS-SQL approach of &#39;F5&#39; to execute queries, rather than hitting &#39;Modifier+Return&#39;. I haven&#39;t yet come across a simple way to do this. My questions are then:
&lt;ul&gt;
&lt;li&gt;Is this possible somehow in MySQL Workbench (e.g. additional plugin)?&lt;/li&gt;
&lt;li&gt;If not, do any of the alternatives to MySQL Workbench offer this functionality?&lt;/li&gt;
&lt;/ul&gt;

Environment:
&lt;ul&gt;
&lt;li&gt;Ubuntu 12.04 LTS, 32 bit&lt;/li&gt;
&lt;li&gt;MySQL server version 5.5.24-0ubuntu0.12.04.1&lt;/li&gt;
&lt;li&gt;MySQL Workbench Version 5.2.38, rev 8753&lt;/li&gt;
&lt;/ul&gt;

Cheers!

Content Type	Original Author	Original Content on Stackoverflow
Question	zdarsky.peter	View Question on Stackoverflow
Solution 1 - Mysql	Kamran Ali	View Answer on Stackoverflow
Solution 2 - Mysql	SkyWalker	View Answer on Stackoverflow
Solution 3 - Mysql	Mahmoud Zalt	View Answer on Stackoverflow
Solution 4 - Mysql	Hari_pb	View Answer on Stackoverflow

How to get ER model of database from server with Workbench

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

I want to enhance Mr. Kamran Ali's answer with pictorial view. Pictorial View is given step by step:

Solution 3 - Mysql

Solution 4 - Mysql

Combine two ActiveRecord::Relation objects

Get protocol + host name from URL

Attributions