How can we change the name and data type of a column of a
table?
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 |
Post New Answer View All Answers
Can varchar be primary key?
Is mysql case-sensitive?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What does mysql_fetch_assoc do?
How to execute mysql query in php?
What is the difference between primary key and candidate key?
How to create a new table by selecting rows from another table in mysql?
What is difference between group by and order by clause?
Can we use mysql and mysqli together?
How do I set user privileges in mysql?
What is the difference between procedure and function in mysql?
How to load data files into tables with 'mysqlimport'?
What is mysql installer?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
How do I flush privileges in mysql?