List:GUI Tools« Previous MessageNext Message »
From:Reinhold Riedersberger Date:March 3 2002 12:17am
Subject:error
View as plain text  
Hallo,

I'm using Mycc 0.8.1

I can't create new tables with the following syntax:

CREATE TABLE /*!32300 IF NOT EXISTS*/ h_etikettendrucker (
  Fabrikat varchar(15) DEFAULT '0' ,
  Typ tinyint(3) unsigned DEFAULT '0' ,
  Drucktechnik tinyint(3) unsigned DEFAULT '0' ,
  Aufloesung tinyint(3) unsigned DEFAULT '0' ,
  Druckkopf tinyint(3) unsigned DEFAULT '0' ,
  Druckgeschwindigkeit tinyint(3) unsigned DEFAULT '0' ,
  Druckbreite tinyint(3) unsigned DEFAULT '0' ,
  Materialbreite tinyint(3) unsigned DEFAULT '0' ,
  Foliensparautomatik tinyint(3) unsigned DEFAULT '0' ,
  Schriften tinyint(3) unsigned DEFAULT '0' ,
  Barcodes tinyint(3) unsigned DEFAULT '0' ,
  Rollendurchmesser_Etiketten tinyint(3) unsigned DEFAULT '0' ,
  Etikettenaufnahme tinyint(3) unsigned DEFAULT '0' ,
  Folienlänge tinyint(3) unsigned DEFAULT '0' ,
  Schnittstellen tinyint(3) unsigned DEFAULT '0' ,
  Externer_Speicher tinyint(3) unsigned DEFAULT '0' ,
  Abmessungen tinyint(3) unsigned DEFAULT '0' ,
  Gewicht tinyint(3) unsigned DEFAULT '0'
); 

CREATE TABLE /*!32300 IF NOT EXISTS*/ h_etikettenfirmen (
  firma char(50) ,
  url char(50) ,
  email char(30) ,
  produkte char(200) ,
  weitere char(200) ,
  benutzer char(15) ,
  passwort char(10)
);

If I use the syntax separately (for each table) it will be OK.
But if I start it like above I will become an error like: [Administrator@localhost:3306]
ERROR 1064: You have an error in your SQL syntax near ';
CREATE TABLE /*!32300 IF NOT EXISTS*/ h_etikettenfirmen (firma char(50) ,' at line 20

It seems to be an error within Mycc?!

May someone help me?

-- 
With best regards,
 Reinhold        

 
=======================================
The Bat! - Der alternative eMail-Client
http://www.ritlabs.com/de/the_bat/
=======================================

Thread
errorReinhold Riedersberger3 Mar