| describe content_models |
2 years ago |
| show tables |
2 years ago |
| select * from page where 1 limit 0,1 |
2 years ago |
| select page_id from page where 1 limit 0,1 |
2 years ago |
| describe page |
2 years ago |
| show tables |
2 years ago |
| SELECT * from content where p.page_id LIKE "%Q1319786%" |
2 years ago |
| SELECT * from content where page.page_id LIKE "%Q1319786%" |
2 years ago |
| DESCRIBE content; |
2 years ago |
| SHOW TABLES |
2 years ago |
| Select * from schema_name.table_name |
2 years ago |
| SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE... |
2 years ago |
| SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE... |
2 years ago |
