| USE euwiki_p;
SHOW COLLATION; |
6 years ago |
| USE euwiki_p;
SELECT "FOO" LIKE 'foo' COLLATE utf8; |
6 years ago |
| USE euwiki_p;
SELECT "FOO" LIKE 'foo'; |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT("foo" USING utf8) FROM 1 FOR 60); |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT("foo" USING utf8) FROM 0 FOR 60); |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT(el_to USING utf8) FROM 0 FOR 60) FROM... |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT(el_index USING utf8) FROM 0 FOR 60)... |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT(el_index USING utf8) FROM 0 FOR 60)... |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(CONVERT(el_index USING utf8), 0, 60) FROM... |
6 years ago |
| USE euwiki_p;
SELECT SUBSTRING(el_index, 0, 60) FROM externallinks LIMIT 10; |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
main_domain,
... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
main_domain,
... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
main_domain,
... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
SELECT
*
SELECT
main_domain,
... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
SELECT
main_domain,
COUNT(DISTINCT page_id) AS... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
SELECT
main_domain,
COUNT(DISTINCT page_id) AS... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
SELECT
main_domain,
COUNT(DISTINCT page_id) AS... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
-- Extract all (page_id, main_domain)... |
6 years ago |
| USE euwiki_p;
USE euwiki_p;
-- Extract all (page_id, main_domain)... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE euwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
| USE enwiki_p;
CREATE FUNCTION hello (s CHAR(20))
RETURNS CHAR(50)... |
6 years ago |
