|
More site info...
Workbench - Newbie | Forum profile
|
|
Forum profile page for Workbench - Newbie on http://www.mysql.com.
This report page is the aggregated overview from a single forum: Workbench - Newbie, located on the Message Board at http://www.mysql.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Workbench - Newbie" on the Message Board at http://www.mysql.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Workbench - Newbie:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
17
|
38
|
93
|
|
Post:
|
22
|
54
|
130
|
|
|
Workbench - Newbie Posting activity graph:
|
Top authors during last week:
user's latest post:
Re: Workbench start parameters
Published (2009-12-10 02:07:00)
Hey Leonard, so far this is not possible. WB will try to open the given file as a model currently, and errors out as it is not a model file (obviously). It's on our todo list, though. Mike Mike Lischke, Senior Software Engineer Developer Tools Database Group, Sun Microsystems Inc., www.sun.com
user's latest post:
Re: How can i add the feature...
Published (2009-12-10 09:01:00)
Hmm, i just downloaded the new workbench beta but i can't load my EER diagram :( if i try to load it, the "EER diagram" window is completly empty/grey. But it seems to me, that the tables are on their default positions... i only can't see it. Screenshot: http://www19.zippyshare.com/v/15201216/file.html Edited 1 time(s). Last edit at 12/10/2009 09:10AM by Sebastian Kahl.
user's latest post:
disable autocreation of index?
Published (2009-12-07 11:36:00)
Hello, I came from DBDesigner and want disable the autocreation ao FK index. I'm using MyIsam table and want to set my own indize. I can't change the automtaic indix, adding fields or so on. Thanks Sven PS: Sorry for my english
user's latest post:
WB SQL (Foreign Keys) Won't...
Published (2009-12-06 15:35:00)
WB 5.1.18 r.4456 I have the following: -- ----------------------------------------------------- -- Table `webdb`.`Goal` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `webdb`.`Goal` ( `goal_id` INT NOT NULL AUTO_INCREMENT , `motivation` VARCHAR(255) NULL , `set_date` DATETIME NULL , `end_date` DATETIME NULL , `completion_date` DATETIME NULL , PRIMARY KEY (`goal_id`) , INDEX `priority_id` () , INDEX...
user's latest post:
Re: Create database with...
Published (2009-12-08 10:26:00)
thanks Chad, need your advice again mate :) if there were 2 applicants on the form would the clients table need to be amended with the same fields: firstname2 etc? many thanks again mate
user's latest post:
Workbench start parameters
Published (2009-12-09 06:44:00)
Hi Forum! does anyone know if there's any way to open a sql file with Workbench from the console? is there a list of start parameters? Is that possible at all? i'm planing on writing a plugin for eclipse that executes a few other commands and then opens a specific file in workbench. Is there any way to do that? Thanks, L.
user's latest post:
Re: Error #1005 - Can't...
Published (2009-12-10 08:06:00)
Hi, Check the column details,Table options,Indices for that particular id. All should be same.
|
|
|
|
Latest active threads on Workbench - Newbie::
Started 1 week, 1 day ago (2009-12-08 02:51:00)
by Mike Lischke
Sebastian,
we need a bit more context to be able to help. Where were you looking at when you asked this question? Is it something about the Workbench and its table editor? Are in a model or the SQL IDE? If it is about Workbench, which version do you use on which OS?
If this is a question about the MySQL DDL syntax then you are in the wrong forum and should look elsewhere.
Mike
...
Started 1 week, 5 days ago (2009-12-03 21:17:00)
by Brian ONeill
The issue was that I was not setting the PK on the other table as auto increment. I made this change and it worked fine.
Started 6 days, 11 hours ago (2009-12-10 02:07:00)
by Mike Lischke
Hey Leonard,
so far this is not possible. WB will try to open the given file as a model currently, and errors out as it is not a model file (obviously).
It's on our todo list, though.
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun Microsystems Inc., www.sun.com
Started 1 week, 1 day ago (2009-12-08 02:51:00)
by Mike Lischke
Sebastian,
is this is general question regarding the DDL syntax of CREATE TABLE and specifically the FK part or something in MySQL Workbench you wanna know?
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun Microsystems Inc., www.sun.com
Started 2 weeks ago (2009-12-01 15:17:00)
by Chad Bourque
Andy,
It's difficult to say for sure without knowing more about your requirements. But, in a general way relating to the information you've provided, you could have something like this ( off the cuff, mind you, so there may be errors and/or better ways to do it):
create table Products
(
productId int not null auto_increment primary key,
name varchar(50),
description varchar(...
Started 1 week, 1 day ago (2009-12-08 02:50:00)
by Mike Lischke
Hey Sven,
sorry, I don't really understand your question. What is the "automatic creation of an FK index" for you? I know that columns get created when you create a relationship on the model diagram, but I guess this is not what you mean. Otherwise indices are only created if you do that.
Mike
PS: If you like we can discuss this in realtime in #workbench on irc. freenode.net (even ...
Started 1 week, 2 days ago (2009-12-07 02:40:00)
by Mike Lischke
Hey Simon,
reordering isn't supported currently. If you like create a feature request at http://bugs.mysql.com so we don't forget about it.
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun Microsystems Inc., www.sun.com
Started 1 month, 1 week ago (2009-11-09 02:43:00)
by Mike Lischke
Hey Geoffrey,
you didn't say which WB version you are using. However, I think the way to do what you want is the same since 5.0. Activate the schema you want to remove by clicking on its tab. Then press the "-" button in the bar above the schema tabs to remove it. Consequently, use the "+" button to add a new, empty schema.
Mike
Mike Lischke, Senior Software Engineer Developer Tools...
Started 1 week, 2 days ago (2009-12-07 02:33:00)
by Mike Lischke
Hey David,
this script was created by WB? It's faulty. The index and FK definitions are incomplete. Are you sure you have complete definitions in your model data? It looks as if you created e.g. index `priority_id` in the table editor, but forgot to assign it a column. Similar for the foreign keys.
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun ...
Started 1 week, 6 days ago (2009-12-03 01:49:00)
by Mike Lischke
With WB you have actually 3 possibilities to do that. One is, as you guessed, using plain SQL code, just as you would do on the command line. This might be the fastest one, depending on your skill level. Also using an SQL script file containing all the definitions you need will help a lot (you can execute this in WB).
The other two options are rather graphically oriented. That means you can ...
|
|
Hot threads for last week on Workbench - Newbie::
Started 1 week, 1 day ago (2009-12-08 02:51:00)
by Mike Lischke
Sebastian,
we need a bit more context to be able to help. Where were you looking at when you asked this question? Is it something about the Workbench and its table editor? Are in a model or the SQL IDE? If it is about Workbench, which version do you use on which OS?
If this is a question about the MySQL DDL syntax then you are in the wrong forum and should look elsewhere.
Mike
...
Started 1 week, 1 day ago (2009-12-08 02:51:00)
by Mike Lischke
Sebastian,
is this is general question regarding the DDL syntax of CREATE TABLE and specifically the FK part or something in MySQL Workbench you wanna know?
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun Microsystems Inc., www.sun.com
Started 1 week, 1 day ago (2009-12-08 02:50:00)
by Mike Lischke
Hey Sven,
sorry, I don't really understand your question. What is the "automatic creation of an FK index" for you? I know that columns get created when you create a relationship on the model diagram, but I guess this is not what you mean. Otherwise indices are only created if you do that.
Mike
PS: If you like we can discuss this in realtime in #workbench on irc. freenode.net (even ...
Started 6 days, 11 hours ago (2009-12-10 02:07:00)
by Mike Lischke
Hey Leonard,
so far this is not possible. WB will try to open the given file as a model currently, and errors out as it is not a model file (obviously).
It's on our todo list, though.
Mike
Mike Lischke, Senior Software Engineer Developer Tools
Database Group, Sun Microsystems Inc., www.sun.com
Started 2 weeks ago (2009-12-01 15:17:00)
by Chad Bourque
Andy,
It's difficult to say for sure without knowing more about your requirements. But, in a general way relating to the information you've provided, you could have something like this ( off the cuff, mind you, so there may be errors and/or better ways to do it):
create table Products
(
productId int not null auto_increment primary key,
name varchar(50),
description varchar(...
Started 1 week, 5 days ago (2009-12-03 21:17:00)
by Brian ONeill
The issue was that I was not setting the PK on the other table as auto increment. I made this change and it worked fine.
|
|
Size: 559 bytes
