[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: ERROR 1005
From:       Jason Lim <jasonlsm () tm ! net ! my>
Date:       2005-04-29 2:16:31
Message-ID: 001201c54c61$77093d00$0d00a8c0 () aisbdomain
[Download RAW message or body]


Hi John,

Thanks for your views.

I tried USE; but to no avail.

That's what I meant - by just creating a primary key field doesn't involve any \
constraints.at all and yet I can't create the 'employee' table. It seems there's some \
indexing files I failed to remove during my last DROP DATABASE demo40. What do you \
think?

Like I said, there's no problem at all creating a database with names other than \
'demo40'.

I did not get any errors using the CREATE DATABASE statement.



Jason





----- Original Message ----- 
  From: jbonnett@sola.com.au 
  To: jasonlsm@tm.net.my ; win32@lists.mysql.com 
  Sent: Friday, April 29, 2005 07:08
  Subject: RE: ERROR 1005


  You probably need a ";" after USE demo40 but that may not be the
  problem.

  I can't see this problem being related to bad constraints and foreign
  key references since you have only just created the database. I assume
  you do not get any errors on the CREATE DATABASE statement?

  Your sequence of commands (even without the semi-colon) works fine on my
  test database server.

  John Bonnett



[prev in list] [next in list] [prev in thread] [next in thread]