PHP, MySQL, Drupal, .htaccess, Robots.txt, Phponwebsites: Changing the column size in mysql

25 Dec 2013

Changing the column size in mysql

                       You created a table with specific size of column. Sometimes you need to increase the size of column, if the size is not enough. At the time, you can modify the size of field. It is possible in mysql. The following mysql query is used for this:
Mysql Query:
                         Alter table table_name modify column_name datatype(length)


Consider the example:
 table1 is name of this table.

changing column size in mysql at phponwebsites



When you click the structure of table in your database. It is look like this:

srtucture of column in mysql


                          Suppose you've to add more characters to column Game_name. On that time you can change the field size. The mysql query is:
                     Alter table table1 modify Game_name varchar(40)  

Now your structure look like this:

change column size in mysql table

     Now your Game_name column size is changed into 40.


Changing the multiple column size at the time in mysql:


                      You can change multiple column size at a time in mysql. The mysql query as follow as:
Mysql Query:
                          Alter table table1
                                    modify Game_name varchar(50),
                                    modify Image varchar(40)

                          Now your output look like this:

changing multiple column size at a time in Mysql at phponwebsites

                          Now you will get output as Game_name with 50 size and Image with 40 size.

Related Post:

No comments:

Post a Comment