How alter table in MySQL?

Ads
 

How alter table in MySQL?

Hi,

I have a table and I want to alter an int field into text field. How to alter the table in MySQL?

Thanks

View Answers

December 14, 2013 at 4:14 PM

Hi,

You can use the following query:

alter table employees change empid empid varchar(100);

Check the tutorial Mysql Alter Column Datatype.

Check more examples of alter table statements in MySQL.

Thanks

Ads









Related Tutorials/Questions & Answers:
How alter table in MySQL?
JDBC: Alter Table Example
Advertisements
SQL Alter Table Name
SQL Alter Table
mysql alter table add column
alter table create index mysql
SQL Alter Table Name
alter table create index mysql
MySql Alter User
Mysql Alter Table Syntax
Mysql Alter Table
mysql alter table add unique constraint
SQL Alter Table Primary Key
alter table add foreign key mysql
SQL Alter Table Syntax
Mysql Alter Rename Table
Mysql Alter Rename Table
mysql alter table add multiple columns
Mysql Alter Table Identity
Mysql Alter Table
SQL Alter Table
SQL Alter Table Add Multiple Columns
ModuleNotFoundError: No module named 'mysqlx-connector'
Mysql Alter Table Primary Key
SQL Alter Table Add Multiple Columns
Alter Database Table Using JDBC Batch Process
MySql Alter Database
How to update table in Hibernate
How To Create a Table.
SQL Alter Column Name
how to create a table

Ads