User Profile

Collapse

Profile Sidebar

Collapse
terenceyuen
terenceyuen
Last Activity: Jul 10 '07, 02:42 AM
Joined: May 14 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • terenceyuen
    replied to How to alter or change column with ALTER TABLE
    in MySQL
    Thank you so much. It's very useful tips..
    See more | Go to post

      Leave a comment:

    • terenceyuen
      replied to How to alter or change column with ALTER TABLE
      in MySQL
      Thanks a lot
      , I'v tried, but it return the following errors at the end. Is it possible to define the datetype : varchar(240) ?

      mysql> ALTER TABLE claims_summary ALTER COLUMN advance_call_de tails varchar(240) NOT NULL;

      ERROR 1064: You have an error in your SQL syntax near 'varchar(240) NOT NULL' at line 1
      See more | Go to post

        Leave a comment:

      • terenceyuen
        started a topic How to alter or change column with ALTER TABLE
        in MySQL

        How to alter or change column with ALTER TABLE

        I would like to change the type of Null to NO ,what is the command for this?
        I've tried this one, but no luck to get it work.
        ALTER TABLE claims_summary ALTER COLUMN advance_call_de tails SET NOT NULL;

        Thanks.
        Terence
        +----------------------+--------------+------+-----+---------+-------+
        | Field | Type | Null | Key | Default | Extra |
        +----------------------+--------------+------+-----+---------+-------+...
        See more | Go to post
        No activity results to display
        Show More
        Working...