pyxllq的博客

归档记录/*查找表中符合条件的所有记录*/SELECT * FROM my_test WHERE name='test'/*查找表中符合条件的并且name字段不重复的所有记录数*/SELECT COUNT(DISTINCT name) FROM my_testWHERE starttime>='2018-05-09 00:00:00' AND endtime<='2018-05-09...

 在之前一篇blog中有提到mysql常用数据库语句时，使用过以下语句：insert into new_table select NULL,a.phone,name,age,address,NULL, b.birth from students a, info_table b where studentnum in ( '20180722121735', '20180721174...