查询所有书籍.sql 299 B

12345678910111213141516
  1. -- 查询所有书籍信息
  2. SELECT
  3. `content_id` AS '书籍ID',
  4. `title` AS '书名',
  5. `author` AS '作者',
  6. `cover_url` AS '当前封面URL',
  7. `content_type` AS '类型(1=电子书,2=听书)',
  8. `status` AS '状态(1=连载,2=完结)'
  9. FROM `content`
  10. ORDER BY `content_id`;