User Profile

Collapse

Profile Sidebar

Collapse
sfh
sfh
Last Activity: Nov 1 '05, 01:26 AM
Joined: Sep 30 '05
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sfh
    replied to Primary Key datatype = varchar
    in General
    Nevermind....

    Nevermind,

    Completely forgot that the PK cant be edited, completely nullifying the point of an RDBMS....

    Sorry....
    See more | Go to post

      Leave a comment:

    • sfh
      started a topic Primary Key datatype = varchar
      in General

      Primary Key datatype = varchar

      Greetings all,

      (I had posted this in MS SQL on accident, my apologies :( )

      I have a question concerning primary key types.

      In the past, I have always created tables with a primary key as an "int" such as:

      [COLOR=Blue][FONT=Courier New]CREATE TABLE color_id (
      color_id int(10) unsigned NOT NULL auto_increment primary key,
      color varchar(45) default NULL
      ...
      See more | Go to post
      • sfh
        started a topic Primary key and varchar
        in General

        Primary key and varchar

        Greetings all,

        I have a question concerning primary key types.

        In the past, I have always created tables with a primary key as an "int" such as:

        [COLOR=Blue][FONT=Courier New]CREATE TABLE color_id (
        color_id int(10) unsigned NOT NULL auto_increment primary key,
        color varchar(45) default NULL
        ) TYPE=INNODB DEFAULT CHARSET=latin1; [/FONT] [/COLOR]

        But as...
        See more | Go to post
        No activity results to display
        Show More
        Working...