SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    May 2002
    Location
    Oslo
    Posts
    138
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Alter table in MySQL

    I have this existing table:

    create table gjestebok
    (
    id int default NULL auto_increment,
    name varchar(255),
    email varchar(255),
    note text,
    date varchar(255),
    currentunixtimestamp bigint,
    primary key(id)
    );

    How can I add the column ' password varchar(255) ' to this table without loosing any data?

  2. #2
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ALTER TABLE gjestebok ADD password VARCHAR(255)


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
  •