PHP, MySQL, Drupal, .htaccess, Robots.txt, Phponwebsites: Add column after specific field in mysql

17 Dec 2013

Add column after specific field in mysql

                       When you try to add add new column to your table, by default the column should be added to end of your table. But you can add it wherever you want in a table. It is possible in mysql.
Myql Query:
                     alter table tablename add column columnname datatype(length) AFTER specific field name

Add column after particular field in mysql:

               
                    Consider a example. Table1 is name of table. Normally the table look this this:

add column Mysql at phponwebsites


Now you are going to add column after specific column. The mysql query is:
     alter table Table1 add column Game_Tag varchar(30)  AFTER Game_Name

The output look like this:


add column after specific field in Mysql at phponwebsites


Now you will get column 'Game_Tag' is after 'Game_Name'.


Add column at first in mysql:


              Now you are going to add column before specific field. The mysql query is:
    alter table Table1 add column Game_Tag varchar(30) FIRST

The output look like this:

add column first in Mysql at phponwebsites

Now you'll get output as column 'Game_Tag' is present first of your table.


Add multiple columns after specific field in mysql:


               You can add multiple columns after particular column in mysql. The mysql query is:
     alter table Table1
        add column Game_Tag varchar(30),
        add column count int(10),
        add column category varchar(30)
              AFTER Image
The output look like this:


add multiple columns after specific field in Mysql at phponwebsites

No comments:

Post a Comment

Note: only a member of this blog may post a comment.