Which of the following statements can be used to change the name of the column name into firstname?

Consider the following table:

mysql> DESC friends;

1 row in set (0.03 sec)

Which of the following statements can be used to change the name of the column name into firstname?

Consider the following table:

mysql> DESC friends;

1 row in set (0.03 sec)

Which of the following statements can be used to change the name of the column name into firstname?

A.
ALTER TABLE friends CHANGE name firstname VARCHAR(20)

B.
ALTER TABLE friends CHANGE name VARCHAR(20) firstname VARCHAR(20)

C.
ALTER TABLE friends RENAME name TO firstname



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Google

Google

That is the end of this report. Right here youll obtain some internet sites that we believe you will appreciate, just click the links.