RE: Executing multiple SQL commands.

[Michael Lépine]

 Could you provide us with the error messages you are getting?!?!

My apologies. The problem appears to have been the copying of unexpected
characters into the SQL. I generated the SQL for the tables and put it into
a file. Apparently when I copy and paste the SQL, some hidden characters are
being copied into the queries which are causing the problems.

Sorry for not figuring this out before posting.

 - Original Message -
 From: "Michael Lpine" [EMAIL PROTECTED]
 To: "MySQL List" [EMAIL PROTECTED]
 Sent: Monday, February 19, 2001 11:57
 Subject: Executing multiple SQL commands.


  I'm trying to execute multiple create table commands and am getting SQL
  errors. I'm using the MySqlManager.exe that comes with the Win32 version
 of
  MySQL and the syntax is similar to the following:
 
  /*==*/
  /* Database name:  physical data model 1*/
  /* DBMS name:  MySQL 3.23   */
  /* Created on: 2/18/01 10:43:37 PM  */
  /*==*/
 
 
  drop table if exists tbl_nm_sfxs;
 
  drop table if exists tbl_cntct_typs;
 
  /*==*/
  /* Table : tbl_cntct_typs   */
  /*==*/
  create table if not exists tbl_cntct_typs
  (
 cntct_typ_id int unsigned not null,
 primary key (cntct_typ_id)
  )
  type = bdb;
 
  /*==*/
  /* Table : tbl_nm_sfxs  */
  /*==*/
  create table if not exists tbl_nm_sfxs
  (
 nm_sfx_id tinyint unsigned auto_increment not null,
 primary key (nm_sfx_id)
  )
  type = bdb;
 
  _
 
  I looked through the archives, but couldn't find something to
 help me (not
  really sure what keywords to use to find help with this). The
 error seems
 to
  be occurring when the second SQL command in a sequence attempts to
 execute.
  If I isolate any of the above commands, they will run independently, but
  together (as above) they fail.
 
  Anyway, if anyone could help me figure out why I'm getting an error, it
  would be appreciated.
 
  - Mike
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Data modeling tool

[Michael Lépine]

I asked a similar question recently and as a result of my searching, I found
a moderately priced, $99 (I think), data modeling tool from XTG (download
here):

http://www.xtgsystems.com/download.php3

I downloaded it and set up a few tables (only 4 are allowed with eval), then
generated the sequel to create one of the tables. I liked it but didn't go
much further with it as I didn't want to pay for a modeling tool until I had
tried a few more.

Currently, I use Power Designer from Sybase which supports MySQL too but not
as well as the modelling tool from XTG although it includes many more
options, bells and whistles. You can download the eval and use it fully for
45 days.

XTG -   $99 (US)
Power Designer - (approximately)$2000 (US)

Try them for yourself and hopefully you'll like one.

HTH,
Mike

 -Original Message-
 From: Cal Evans [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, February 10, 2001 6:42 PM
 To: [EMAIL PROTECTED]
 Subject: Data modeling tool


 As much as I love creating models by hand, my databases are growing to the
 point where I need a tool to help me "see" them.  Does anyone
 know of a tool
 like ERWin or ER/Studio that supports MySQL?

 Cal
 http://www.calevans.com


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Data Modeling

[Michael Lépine]

I've tried searching the archives, but I haven't seen a direct question
about an open source tool or freely available application that could be used
to model a relational database schema. Some of my friends use Sybase's Power
Designer or ERwin, but these are very expensive (at least for me) tools.

If anyone knows of a good tool, please let me know.

Thanks,
Mike


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php