Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

How to add a column into a table in MySQL?

Sometimes we need to add a column that we require into the table. We can do this by using ADD keyword with ALTER command. Syntax: To add a column into a table, use the following syntax: ALTER TABLE table_name ADD COLUMN column_name data...

How to change the datatype of a column in MySQL?

Sometimes we need to change the data type of a column in a table. We can do this by using Modify keyword with ALTER command. Syntax: To change the data type of a column in a table, use the following syntax: ALTER TABLE table_name MODIFY...

How to add comment to a column in MySQL?

Sometimes wee need to add a comment to a column for understanding purpose means to easily identify what is the use of that particular column. We can add comment to a column by two ways- at the time of table creation or by ALTER command after ...

How to make a column as first column in MySQL?

Sometimes we need to make existing column as first column. For example you created a table and added column "id" after creating the column. Now you want to make "id" column as first column, then you can do this easily by using ALTER command as be...

How to add foreign key contraint to a column in MySql?

In many cases we need to create foreign key in a table. We can do this at the time of table creation and after the table creation by ALTER command. 1- At the time of table creation: CREATE TABLE user_device ( id int(11) NOT NULL AUTO...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: