删除Goods表中，g_ID='040002'的商品信息语句是_______ from Goods where g_ID='040002'
举一反三
- 下列不能为查询列指定别名的语句是 A: select g_ID=商品号 from Goods B: select g_ID 商品号 from Goods C: select g_ID AS 商品号 from Goods D: select 商品号=g_ID from Goods
- 删除商品信息表Goods中的所有信息的语句() A: DELETE B: DELETE FROM C: DELETE FROM Goods D: DELETE DATABASE
- 写出下列SQL语句的功能DELETE FROM goods WHERE id>;5
- 智慧职教: 查看商品表，比较 SELECT * FROM goods； 和 SELECT * FROM goods G； 你认为G的作用是？
- 删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;