-
随便创建一个表,插入一些数据。
-
想查出谁居住在上海和北京,可以输入:
select * from teacher where address='上海' or address='北京';
-
或者输入:
select * from teacher where address in('上海','北京');
47.in
于 2022-03-05 20:42:03 首次发布
随便创建一个表,插入一些数据。
想查出谁居住在上海和北京,可以输入:select * from teacher where address='上海' or address='北京';
或者输入:select * from teacher where address in('上海','北京');