Jump to content

SQL Change Field Type?

- - - - -
Started by TcM, Nov 30 2007 10:29 AM

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1
TcM
Posted 30 November 2007 - 10:29 AM

TcM

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 11,147 posts
I have a table for a website, and the field type is currently Text, but I want to change it to longtext. Anyone can help me please? Keep in mind that SQL is totally new to me. I browsed through phpMyAdmin and Google.. but I didn't find how to do it.


Thanks for your help.

#2
Guest_Jordan_*
Posted 10 December 2007 - 04:35 AM

Guest_Jordan_*
  • Guests
You have to use the ALTER command:

ALTER TABLE t1 CHANGE a LONGTEXT;

Execute that in the SQL tab on phpMyAdmin.

#3
TcM
Posted 12 December 2007 - 02:32 PM

TcM

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 11,147 posts
Thanks.. I would assume that t1 is the table name and that a is the field name?
Back to Database & Database Programming




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → Database & Database Programming
IPB skins by Skinbox