面试时遇到的SQL记录

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‘);