Topic: Importing from SAPDB 7.4.3 to Mysql 5.0

[$username]

I have this from my SAPDB database. I would like to import this to a mysql database. I dont know why this is an error

Any help would be much appreciated

Here is the table def.

CREATE TABLE "DBM350_WRNB"
(
   "FAXNUMBER"               Varchar (40) UNICODE,
   UNIQUE("FAXNUMBER"),
   "FORBIDDEN"               Integer,
   "LASTSTATUS"               Varchar (100) UNICODE,
   "REASON"               Integer,
   "RETRY"               Integer,
   "RETRYDIALED"               Integer,
   "SECONDSTOWAIT"               Integer,
   "NEXTVALIDDATETIME"               Timestamp,
   "LASTTRYDATETIME"               Timestamp,
   "COMMENT"               Varchar (100) UNICODE,
   "LONGSTATUS"               Varchar (100) UNICODE,
   "STATUSCODE"               Integer,
   "DIST_NUM"               Integer,
   "DIST_LASTWRITE"               Timestamp,
   "MSN"               Fixed (10,0)    NOT NULL    DEFAULT SERIAL (1),
   "DIST_OWNER"               Varchar (64) UNICODE,
   "PRIORITY"               Integer    DEFAULT           0,
   "DIST_FILE"               LONGBLOB,
   PRIMARY KEY ("MSN")
)

here is the error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SERIAL (1),
    "DIST_OWNER"               Varchar (64) UNICODE,
    "PRIORITY"    ' at line 18

[toplay]

I don't know what you're trying to do with "SERIAL (1)" but that's not valid. You can use "DEFAULT 0" instead there.

You'll have a problem with "UNICODE" too.

Look at create table syntax:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html