mysql-workbench

Mysql Database design - checklist/quiz application

hello, I'm currently 'learning' codeigniter, php and mySql all at once as I try and create a "checklist" type of website, where visitors sign up, create a project and are asked a list of questions, where they must input certain fields I'm a little stuck on my mySQL DB-design... (completely stuck actually) what it comes down to is... ...

Mysql benchamrking GUI tool

Hi I need to optimize an application which is already there for a long time. Optimization will include move inline queries from php pages to "stored procedures", get rid of sub queries and convert them to "joins" etc etc. I guess the best way is to use benchmarking tools for this purpose, but is there any GUI based tool available which ...

import initial table data to .mwb model file

hi, how can i import initial table data to .mwb file? i know that there is 'inserts' tab for each table, but i would like to import like 200 records and i don`t want to do this by hand :) ...

MySQL Foreign Key Error 1005 errno 150

Hello, I'm doing a small DataBase with MySQL Workbench. I have a main table, called "Immobili", which has a Primary Key composed by four columns: (Comune, Via, Civico, Immobile). Now, I also have three other tables, wich have the same primary key (Comune, Via, Civico, Immobile), but these fields are also referenced to the table Immobili....