to add new columns in databases alter table <table name> add co

How can we change the name and data type of a column of a
table?

Question Posted / aftab alam

Answer Posted / aftab alam

to add new columns in databases

alter table <table name> add column <column name> datatype;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can varchar be primary key?

877

Is mysql case-sensitive?

835

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2051

What does mysql_fetch_assoc do?

909

How to execute mysql query in php?

860

What is the difference between primary key and candidate key?

940

How to create a new table by selecting rows from another table in mysql?

922

What is difference between group by and order by clause?

909

Can we use mysql and mysqli together?

941

How do I set user privileges in mysql?

837

What is the difference between procedure and function in mysql?

955

How to load data files into tables with 'mysqlimport'?

920

What is mysql installer?

947

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

862

How do I flush privileges in mysql?

937