| select cat_title from category where cat_title like "%解放军%"
|
2 years ago |
| select cat_title from category where cat_title like "%解放军%"；
|
2 years ago |
| select cat_title from category where cat_title like "%解放军%" limit 10;
|
2 years ago |
| select cat_title from category where cat_title like "%军%" limit 10;
|
2 years ago |
| select * from category limit 10;
|
2 years ago |
| select distinct gt_type from geo_tags; |
2 years ago |
| select count(*) from geo_tags; |
2 years ago |
| show tables |
2 years ago |
| select * from page_props limit 10; |
2 years ago |
| show tables |
2 years ago |
| select * from content limit 10; |
2 years ago |
| select * from page limit 10; |
2 years ago |
| show tables |
2 years ago |
| select count(*) from page_p;
|
2 years ago |
| select count(*) from geo_tags;
|
2 years ago |
| select count(*) from geo_tags;
|
2 years ago |
| select distinct gt_type from geo_tags;
|
2 years ago |
| select count(*) from geo_tags
;
|
2 years ago |
| select count(*) from geo_tags count(*);
|
2 years ago |
| select count(*)from geo_tags count(*);
|
2 years ago |
| select * from geo_tags return count(*);
|
2 years ago |
| select * from category where cat_title like "%military%"limit 10;
|
2 years ago |
| select * from category limit 10;
|
2 years ago |
| describe category; |
2 years ago |
| show tables;
|
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id and... |
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id and... |
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id and... |
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id limit 10; |
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id and... |
2 years ago |
| select * from geo_tags, page where geo_tags.gt_page_id = page.page_id and... |
2 years ago |
| select * from geo_tags, page where geo_tags.page_id = page.page_id and... |
2 years ago |
| select * from geo_tag, page where geo_tags.page_id = page.page_id and... |
2 years ago |
| select * from gt_tag, page where geo_tags.page_id = page.page_id and... |
2 years ago |
| select * from gt_tag, page where gt_tags.page_id = page.page_id and... |
2 years ago |
| select * from gt_tags, page where gt_tags.page_id = page.page_id and... |
2 years ago |
| describe page; |
2 years ago |
| show tables;
|
2 years ago |
| tables;
|
2 years ago |
| describe pages_p; |
2 years ago |
| describe pages; |
2 years ago |
|
select * from geo_tags where gt_type="military" limit 10; |
2 years ago |
|
select distinct(gt_type) from geo_tags; |
2 years ago |
|
select distinct(gt_type) from geo_tags limit 10; |
2 years ago |
|
select * from geo_tags limit 10; |
2 years ago |
