MySQL SQL编写笔记
记录一些SQL编写的技巧,不断更新中……
多个字段查询
SELECT id_number,birthday,gender_typecode FROM `ord_passenger` where order_id in (123456, 654321);
套接查询
select * from order where order_id = (select id from ord_order where order_no = '123456');
记录一些SQL编写的技巧,不断更新中……
多个字段查询
SELECT id_number,birthday,gender_typecode FROM `ord_passenger` where order_id in (123456, 654321);
套接查询
select * from order where order_id = (select id from ord_order where order_no = '123456');