How can we change the name and data type of a column of a
table?
- 9 Answers
- 24788 Views
- Google, I also Faced
- E-Mail Answers
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
Is mysql a relational database?
What is ddl, dml, and dcl?
How do you select a table?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Is mysql deprecated?
How can you retrieve a portion of any column value by using a select query?
What is a simple query?
What is a storage engine? What are the differences between innodb and myisam engines?
Where is mysql used?
What is tee command in mysql?
What is limit in mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
Is mysql a nosql database?
What are the advantages and disadvantages of using mysql?
What are slow queries?
