常用sql操作语句

select * from books
select * from book_catalogue
select * from book_chapter

select * from book_catalogue
select * from book_catalogue limit 100 offset 300
select count(*) as total_numbers from book_catalogue;
select count(*) as done_numbers from book_catalogue where down_flag='1';
select count(*) as init_numbers from book_catalogue where down_flag='0';
select *  from book_catalogue where down_flag='0';
select count(*) as fail_numbers from book_catalogue where down_flag='2';


select * from book_chapter where chapter_id ='116'
select * from book_chapter 
select count(*) from book_chapter 
select count(*) from book_chapter where chapter_content like '%看更多好看的小说%'
select chapter_content from book_chapter where chapter_id ='1'

posted @ 2021-11-18 10:55  yxmichael  阅读(64)  评论(0编辑  收藏  举报