创建表格的SQL语句的正确描述
A. create student(int id,String name)
B. create table student(int id,String name)
C. create table student(id int,name String)
D. create table student(id int,name varchar(20))
表student中的包含两个字段,整型的id,字符串型的name。向表student中插入一条记录的正确SQL语句( )
A. insert into student(2018001,“张三”)
B. insert into student values(2018001,'张三')
C. insert into student(2018001,'张三')
D. insert into student values (2018001,“张三”)
表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是()
A. select name from student
B. select * from student
C. select from name in student
D. select name
表student中的包含两个字段,整型的id,字符串型的name。删除名字为张三的记录的SQL语句是()
A. delete * from student where name="张三"
B. delete name from student where name="张三"
C. delete from student where name="张三"
D. delete from student where name='张三'