【单选题】如何删除students表中的所有记录()
A. Drop table students; B. Delete from students; C. Alter table students; D. delete user students;
A. Drop table students; B. Delete from students; C. Alter table students; D. delete user students;
举一反三
- 在MySQL数据库中,创建一个名为Stu的新表，同时要求该表与原有的Students表的表结构相同，同时包括Students表中的记录，正确的SQL语句是( )。 A: CREATE TABLE Stu LIKE students; B: CREATE TABLE Stu (SELECT * FROM Students); C: CREATE TABLE Stu AS SELECT * FROM Students; D: CREATE TABLE Stu LIKE SELECT sno,sname FROM Students;
- 下列选项中，可以删除表user中所有记录的SQL语句是（ ）。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`
- MySQL中，删除列的SQL语句是（） A: ALTER TABLE ……DELETE…… B: ALTER TABLE ……DELETE COLUMN…… C: ALTER TABLE ……DROP COLUMN…… D: DELETE FROM ……
- CREATE TABLE students_copy LIKE students; 创建了一个新的表students。
- The number of ________ in our class ________ fifty. A: A. student, is B: B. the students, are C: C. the students, is D: D. students, are