Results 1 to 8 of 8

Thread: Adding column field, please help

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member jokerfool's Avatar
    Join Date
    Dec 2006
    Location
    Gold Coast, Australia
    Posts
    452

    Resolved Adding column field, please help

    This is my current database with MySQL, everything works really well and submitting data to it works really well.

    Code:
    CREATE DATABASE bril_mx;
    
    use test;
    
    CREATE TABLE users (
    	id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
    	firstname VARCHAR(30) NOT NULL,
    	email VARCHAR(50) NOT NULL,
    	age INT(3),
    	location VARCHAR(50),
    	date TIMESTAMP
    );
    However, I would now like to add an additional column field called username.

    Is this the correct procedure to add username?

    Code:
    ALTER TABLE test
    ADD UserName varchar(255);
    Thank you.
    Last edited by jokerfool; Oct 23rd, 2019 at 07:45 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width