Results 1 to 3 of 3

Thread: what is wrong with the code?

  1. 11-20-2005, 08:15 AM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    what is wrong with the code?

    mysql> create table mytabl2 if exists mytabl2
    -> seq int UNSIGNED auto_increment not null,
    -> primary key (seq)
    -> ) type = MYISAN auto_increment =1000;
    ________
    Weed news
    Last edited by sql; 03-06-2011 at 01:55 AM.
    Reply With Quote Reply With Quote
  2. 11-21-2005, 09:23 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What RDBMS?

    "if exists" has to be before create table.
    Reply With Quote Reply With Quote
  3. 11-21-2005, 01:21 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    >>create table mytabl2 if exists mytabl2

    How can you create table if it exists already?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules