Change column position in mysql table

-

Here is the syntax in which i change column position in mysql table.

ALTER TABLE table_name MODIFY password varchar(20) AFTER id;

Comments

Post a Comment

Popular posts from this blog

Easy Way to download cakephp 3.0

-
    Installation step in cakephp 3.0      Installing Composer        CakePHP uses Composer, a dependency management tool, as the officially        supported method for  installation. Installing Composer on Linux and macOS Run the installer script as described in the official Composer documentation and follow the instructions to install Composer. Execute the following command to move the composer.phar to a directory that is in your path: mv composer . phar / usr / local / bin / composer Installing Composer on Windows For Windows systems, you can download Composer’s Windows installer. Create a CakePHP Project Now that you’ve downloaded and installed Composer, let’s say you want to create a new CakePHP application into my_app_name folder. For this just run the following composer command: php composer.phar create-project --prefer-dist cakephp/app my_app_name ...
Read more