单项选择题
把user 表中凡是名字为’jack’的记录删除的语句为()
A. delete * from user where name=”jack”
B. drop from user where name=”jack”
C. alter from user where name=”jack”
D. delete user where name=”jack”
点击查看答案
相关考题
-
单项选择题
下面三条语句的执行结果为()
A.删除掉 ‘产品数据库’
B.把‘产品数据库’改名为’product’
C.删除掉‘product’
D.把’product’改名为‘产品数据库 -
单项选择题
查看年龄为20的所有人的记录,SQL语句为()
A. SELECT * FROM CUSTOMERS WHERE AGE=20
B. DROP FROM CUSTOMERS WHERE AGE=20
C. SELECT FROM CUSTOMERS WHERE AGE=20
D. DELETE FROM CUSTOMERS WHERE CUSTID=5 -
单项选择题
删除CUSTOMERS 表中 CUSTID=5 的记录的语句为()
A. DROP FROM CUSTOMERS WHERE CUSTID=5
B. DELETE FROM CUSTOMERS WHERE CUSTID=5
C. SELECT FROM CUSTOMERS WHERE CUSTID=5
D. DROP CUSTOMERS WHERE CUSTID=5
