相关考题
-
单项选择题
已知表tb_user的存储引擎为MyISAM,下面哪条SQL语句可以将该表的存储引擎修改为InnoDB?()
A.ALTER TABLE tb_user RENAME tb_user1
B.ALTER TABLE tb_user ADD COMMENT VARCHAR(100)
C.ALTER TABLE tb_user ENGINE=InnoDB
D.ALTER TABLE tb_user MODIFY ENGINE=InnoDB -
单项选择题
哪条SQL语句用于在表tb_user中添加字段?()
A.ALTER TABLE tb_user RENAME tb_user1
B.ALTER TABLE tb_user ADD COMMENT VARCHAR(100)
C.ALTER TABLE tb_user DROP tc
D.ALTER TABLE tb_user ENGINE=MyISAM -
单项选择题
哪条SQL语句可以将表tb_user的表名称修改为tb_user1?()
A.ALTER TABLE tb_user RENAME AS tb_user1
B.ALTER TABLE tb_user MODIFY AS tb_user1
C.ALTER TABLE tb_user ADD tb_user1
D.ALTER TABLE tb_user UPDATE tb_user1
