1.MySQL创建表和设置主键
a. CREATE TABLE db (‘id‘ VARCHAR(10), ‘name‘ int(20), ‘phone‘ VARCHAR(11), ‘score‘ varchar(10)) PRIMARY key (‘id‘);
b. select name, score from db where score in (‘100‘, ‘60‘ ‘0‘);
2022-10-10 21:26:39
1.MySQL创建表和设置主键
a. CREATE TABLE db (‘id‘ VARCHAR(10), ‘name‘ int(20), ‘phone‘ VARCHAR(11), ‘score‘ varchar(10)) PRIMARY key (‘id‘);
b. select name, score from db where score in (‘100‘, ‘60‘ ‘0‘);