SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Apr 2006
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help with query error

    Can't seem to be able to see what's wrong with this query. Could a kind soul kindly advise me?

    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 'NULL ,

    `labpdfserial` VARCHAR NULL ,

    `isDoctor` TINYINT(1) NULL ,

    PRIMARY ' at line 48.

    SQL Error: 1064

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you have to declare a size for VARCHAR or CHAR datatypes.

  3. #3
    SitePoint Member
    Join Date
    Apr 2006
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by guelphdad View Post
    you have to declare a size for VARCHAR or CHAR datatypes.
    oh.. thanks for the tip. Was using mysql workbench to convert mssql to mysql.


Bookmarks

Posting Permissions

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