- 5
Fill in the blanks to create a table with three columns: ''id'' as a primary key, username and password of type varchar. test (
9 Answers
+ 2
Fill in the blanks to create a table with two columns: ''id'' as a primary key integer, and ''name'' of type varchar.
+ 1
CREATE TABLE test (
id int ,
username varchar (30),
password varchar(20),
PRIMARY KEY (id)
);
+ 1
varchar
50
0
CREATE TABLE
INT
varchar
PRIMARY KEY
THAT IS CORRECT
0
CREATE TABLE test (
id int ,
username varchar (30),
password varchar(20),
PRIMARY KEY (id)
);
0
SELECT name, (cost)
FROM items WHERE name
'%boxes of frogs' AND
seller_id (68, 6, 18)
LIKE MIN NOT AVG BETWEEN IN
i don't understand this one help?
0
Answer is TABLE, NOT, AUTO_INCREMENT, and PRIMARY KEY.
0
SELECT name, MIN (cost)
FROM items WHERE name
LIKE '%boxes of frogs' AND
seller_id IN (68, 6, 18)
LIKE MIN NOT AVG BETWEEN IN
- 2
create table test(
id number(10) primary key,
username varchar(20),
password varchar(20));
//I created table by assuming username and password are not referring any keys