USE ruwiki_p;
select* from page where page_title like 'Ж%ж%б%' limit 100; |
4 years ago |
USE ruwiki_p;
select* from page where page_title like 'Ж%ж%б%' limit 10; |
4 years ago |
USE ruwiki_p;
select* from page where page_title like 'Ж%ж%б%' limit 1; |
4 years ago |
USE ruwiki_p;
select* from page where page_title like 'ж%ж%б%' limit 1; |
4 years ago |
USE ruwiki_p;
select* from page limit 10; |
4 years ago |
USE ruwiki_p;
select count(*) from page; |
4 years ago |
USE ruwiki_p;
show tables; |
4 years ago |
USE ruwiki_p;
SELECT COUNT(*)
FROM pages; |
4 years ago |
SHOW databases LIKE "%ru%_p"; |
4 years ago |
SHOW databases LIKE "%ru_p"; |
4 years ago |
SHOW databases LIKE "%_p"; |
4 years ago |
select * from page where page_title LIKE 'жожоба' limit 10; |
4 years ago |
select * from page where page_title LIKE “жожоба” limit 10; |
4 years ago |
select * from page where page_lang is not null limit 10; |
4 years ago |
select * from page where page_lang = is not null limit 10; |
4 years ago |
select * from page limit 10; |
4 years ago |
select * from page where page_lang = 'ru' limit 10; |
4 years ago |
select * from page limit 10; |
4 years ago |
select * from page; |
4 years ago |
show table 'page'; |
4 years ago |
show table page; |
4 years ago |
show tables; |
4 years ago |
show tablse; |
4 years ago |