SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2001
    Location
    BC, Canada
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Creating Variable Types in MySQL

    I'm just learning sql and I was wondering if it is possible to created customer variables or types for the database. For example a variable called status that would have three possible values: complete, incomplete and void for example.

    Thanks a lot.

  2. #2
    Happy Holidays !! Paul S's Avatar
    Join Date
    Mar 2001
    Location
    Mexico
    Posts
    1,287
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    in MYSQL you can use the ENUM type,

    for example ENUM("complete", "incomplete", "void")

    Paul


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
  •