Announcement

Collapse
No announcement yet.

change of database structure

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • change of database structure

    how to change the mysql database structure?

    for eg, i've set A as varchar(35) but now i want to change to varchar (50) how to do it?

  • #2
    ALTER TABLE tablename CHANGE fieldname fieldname VARCHAR(50);
    Chen Avinadav
    Better to remain silent and be thought a fool than to speak out and remove all doubt.

    גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X