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

 

posted @ 2020-11-04 16:10  paul_hch  阅读(27)  评论(0编辑  收藏