Results 1 to 3 of 3

Thread: mysql alter table

  1. 09-22-2006, 11:37 PM #1
    manoj_jnics1
    manoj_jnics1 is offline Registered User
    Join Date
    Sep 2006
    Posts
    8

    Exclamation mysql alter table

    how can i delete a column of an existing table in mysql.
    plz help............with one example.
    Reply With Quote Reply With Quote
  2. 09-23-2006, 10:05 AM #2
    mikr0s
    mikr0s is offline Registered User
    Join Date
    Sep 2005
    Posts
    168
    ALTER TABLE yourtable DROP COLUMN yourcolumn

    --HTH--
    http://giatinamalia-blog.blogspot.co...or-amalia.html
    Reply With Quote Reply With Quote
  3. 09-25-2006, 02:05 AM #3
    manoj_jnics1
    manoj_jnics1 is offline Registered User
    Join Date
    Sep 2006
    Posts
    8
    Quote Originally Posted by mikr0s
    ALTER TABLE yourtable DROP COLUMN yourcolumn

    --HTH--

    thanks.
    i did it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules