How to do a query in Mysql WorkBench?


Problem :

I have an .sql script that contains inserts and creates tables. I used the "Create EER Model From Script"

It created the tables but I can't see the data inside these tables.

I went to the query menu and tried to make a query but it gives me an error about not being able to connect to localhost.

Am I doing it right?



Solution :

As documented under Create EER Model from SQL Script:

Clicking this action item launches the Reverse Engineer SQL Script wizard. This is a multi-stage wizard that enables you to select the script you want to create your model from.

For further information, see Section 7.7.9.1, “Reverse Engineering Using a Create Script”.

Following that link:

However, if you are working with a script that also contains DML statements you need not remove them; they will be ignored.

Instead, you want the Manage Data Import/Export option under Server Administration (within the Workspace section of the Home window).


Mysql Tutorials

Mysql Howto..

How to connect Flash Builder 4 application to the remote mySQL database?

How to insert a new row between existing rows using mysql with autonum field updated [duplicate]

conditional join - how intelligently will mysql handle implicit information

How can a not null constraint be dropped?

Mysql - How to get all records being in other column in the same table

How to solve mysql warning: “InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal ”?

How to concatenate and store MYSQL column values?

How to resolve incorrect SQL syntax error when using “Dimension Lookup / Update” with MySql?

Idea how to implement server-push content without php looping

How to use checkboxes to enter true (1) or false (0) into mySQL AND show as checked in php / html form?

How do I access a MySQL database with Entity Framework

how to save a javascript rendered countdown timer to mysql using PHP?

How to get Rank in mysql? [duplicate]

How to MERGE records in MYSQL

How to generate a chart out of retrieved data from mysql?

How to setup inno db in mysql 5.5.8

How to create new button/functionality in Gmail via extension?

How to alter an event in mysql which is already created

How to get variables from MSQL query with WHERE IN clause

How To Insert , Update multiple checkboxes to mysql?

how to avoid deadlock in mysql

how to insert multiple rows into the database at the same time?

How to Import data (.sql fle) in mysql whose size is greater than 200 MB

how to filter repeated rows based on date in Mysql?

SQL and DateTime - How do I select all rows that have existed for a specific time period?

How to Add $_GET['data'] in URL (media.php?data=123) when I choose data from dropdownlist?

How to count URL domains in MySQL?

MySQL: How to filter out groups that don't contain a specific value?

How to escape this mysql query in php script?

How do I add up multiple SUMs from different subqueries into one result?