use world_x;
[`world_x`.`dual`]
select 1;
[]
syntax error case
[]
select * from ta join tb using (id)
[`sakila`.`ta` `sakila`.`tb`]
select * from ta, tb limit 1
[`sakila`.`ta` `sakila`.`tb`]
drop table tb
[`sakila`.tb`]
drop table db.tb
[`db`.`tb`]
drop database db
[`db`.`dual`]
create database db
[`db`.`dual`]
create index idx_col on tbl (col)
[`sakila`.tbl`]
DROP INDEX idx_col on tbl
[`sakila`.tbl`]
SELECT * FROM film WHERE length = 86;
[`sakila`.`film`]
SELECT * FROM film WHERE length IS NULL;
[`sakila`.`film`]
SELECT * FROM film HAVING title = 'abc';
[`sakila`.`film`]
SELECT * FROM sakila.film WHERE length >= 60;
[`sakila`.`film`]
SELECT * FROM sakila.film WHERE length >= '60';
[`sakila`.`film`]
SELECT * FROM film WHERE length BETWEEN 60 AND 84;
[`sakila`.`film`]
SELECT * FROM film WHERE title LIKE 'AIR%';
[`sakila`.`film`]
SELECT * FROM film WHERE title IS NOT NULL;
[`sakila`.`film`]
SELECT * FROM film WHERE length = 114 and title = 'ALABAMA DEVIL';
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 and title = 'ALABAMA DEVIL';
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 and language_id < 10 and title = 'xyz';
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 and language_id < 10;
[`sakila`.`film`]
SELECT release_year, sum(length) FROM film WHERE length = 123 AND language_id = 1 GROUP BY release_year;
[`sakila`.`film`]
SELECT release_year, sum(length) FROM film WHERE length >= 123 GROUP BY release_year;
[`sakila`.`film`]
SELECT release_year, language_id, sum(length) FROM film GROUP BY release_year, language_id;
[`sakila`.`film`]
SELECT release_year, sum(length) FROM film WHERE length = 123 GROUP BY release_year,(length+language_id);
[`sakila`.`film`]
SELECT release_year, sum(film_id) FROM film GROUP BY release_year;
[`sakila`.`film`]
SELECT * FROM address GROUP BY address,district;
[`sakila`.`address`]
SELECT title FROM film WHERE ABS(language_id) = 3 GROUP BY title;
[`sakila`.`film`]
SELECT language_id FROM film WHERE length = 123 GROUP BY release_year ORDER BY language_id;
[`sakila`.`film`]
SELECT release_year FROM film WHERE length = 123 GROUP BY release_year ORDER BY release_year;
[`sakila`.`film`]
SELECT * FROM film WHERE length = 123 ORDER BY release_year ASC, language_id DESC;
[`sakila`.`film`]
SELECT release_year FROM film WHERE length = 123 GROUP BY release_year ORDER BY release_year LIMIT 10;
[`sakila`.`film`]
SELECT * FROM film WHERE length = 123 ORDER BY release_year LIMIT 10;
[`sakila`.`film`]
SELECT * FROM film ORDER BY release_year LIMIT 10;
[`sakila`.`film`]
SELECT film_id FROM film ORDER BY release_year LIMIT 10;
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 ORDER BY length LIMIT 10;
[`sakila`.`film`]
SELECT * FROM film WHERE length < 100 ORDER BY length LIMIT 10;
[`sakila`.`film`]
SELECT * FROM customer WHERE address_id in (224,510) ORDER BY last_name;
[`sakila`.`customer`]
SELECT * FROM film WHERE release_year = 2016 AND length != 1 ORDER BY title;
[`sakila`.`film`]
SELECT title FROM film WHERE release_year = 1995;
[`sakila`.`film`]
SELECT title, replacement_cost FROM film WHERE language_id = 5 AND length = 70;
[`sakila`.`film`]
SELECT title FROM film WHERE language_id > 5 AND length > 70;
[`sakila`.`film`]
SELECT * FROM film WHERE length = 100 and title = 'xyz' ORDER BY release_year;
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 and title = 'xyz' ORDER BY release_year;
[`sakila`.`film`]
SELECT * FROM film WHERE length > 100 ORDER BY release_year;
[`sakila`.`film`]
SELECT * FROM city a INNER JOIN country b ON a.country_id=b.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a LEFT JOIN country b ON a.country_id=b.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a RIGHT JOIN country b ON a.country_id=b.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a LEFT JOIN country b ON a.country_id=b.country_id WHERE b.last_update IS NULL;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a RIGHT JOIN country b ON a.country_id=b.country_id WHERE a.last_update IS NULL;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a LEFT JOIN country b ON a.country_id=b.country_id UNION SELECT * FROM city a RIGHT JOIN country b ON a.country_id=b.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city a RIGHT JOIN country b ON a.country_id=b.country_id WHERE a.last_update IS NULL UNION SELECT * FROM city a LEFT JOIN country b ON a.country_id=b.country_id WHERE b.last_update IS NULL;
[`sakila`.`city` `sakila`.`country`]
SELECT country_id, last_update FROM city NATURAL JOIN country;
[`sakila`.`city` `sakila`.`country`]
SELECT country_id, last_update FROM city NATURAL LEFT JOIN country;
[`sakila`.`city` `sakila`.`country`]
SELECT country_id, last_update FROM city NATURAL RIGHT JOIN country;
[`sakila`.`city` `sakila`.`country`]
SELECT a.country_id, a.last_update FROM city a STRAIGHT_JOIN country b ON a.country_id=b.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT a.address, a.postal_code FROM sakila.address a WHERE a.city_id IN  (SELECT c.city_id FROM sakila.city c);
[`sakila`.`address` `sakila`.`city`]
SELECT city FROM( SELECT city_id FROM city WHERE city = "A Corua (La Corua)" ORDER BY last_update DESC LIMIT 50, 10) I JOIN city ON (I.city_id = city.city_id) JOIN country ON (country.country_id = city.country_id) ORDER BY city DESC;
[`sakila`.`city` `sakila`.`country`]
DELETE city, country FROM city INNER JOIN country using (country_id) WHERE city.city_id = 1;
[`sakila`.`city` `sakila`.`country`]
DELETE city FROM city LEFT JOIN country ON city.country_id = country.country_id WHERE country.country IS NULL;
[`sakila`.`city` `sakila`.`country`]
DELETE a1, a2 FROM city AS a1 INNER JOIN country AS a2 WHERE a1.country_id=a2.country_id;
[`sakila`.`city` `sakila`.`country`]
DELETE FROM a1, a2 USING city AS a1 INNER JOIN country AS a2 WHERE a1.country_id=a2.country_id;
[`sakila`.`city` `sakila`.`country`]
DELETE FROM film WHERE length > 100;
[`sakila`.`film`]
UPDATE city INNER JOIN country USING(country_id) SET city.city = 'Abha', city.last_update = '2006-02-15 04:45:25', country.country = 'Afghanistan' WHERE city.city_id=10;
[`sakila`.`city` `sakila`.`country`]
UPDATE city INNER JOIN country ON city.country_id = country.country_id INNER JOIN address ON city.city_id = address.city_id SET city.city = 'Abha', city.last_update = '2006-02-15 04:45:25', country.country = 'Afghanistan' WHERE city.city_id=10;
[`sakila`.`address` `sakila`.`city` `sakila`.`country`]
UPDATE city, country SET city.city = 'Abha', city.last_update = '2006-02-15 04:45:25', country.country = 'Afghanistan' WHERE city.country_id = country.country_id AND city.city_id=10;
[`sakila`.`city` `sakila`.`country`]
UPDATE film SET length = 10 WHERE language_id = 20;
[`sakila`.`film`]
INSERT INTO city (country_id) SELECT country_id FROM country;
[`sakila`.`city` `sakila`.`country`]
INSERT INTO city (country_id) VALUES (1),(2),(3);
[`sakila`.`city`]
INSERT INTO city (country_id) VALUES (10);
[`sakila`.`city`]
INSERT INTO city (country_id) SELECT 10 FROM DUAL;
[`sakila`.`city`]
REPLACE INTO city (country_id) SELECT country_id FROM country;
[`sakila`.`city` `sakila`.`country`]
REPLACE INTO city (country_id) VALUES (1),(2),(3);
[`sakila`.`city`]
REPLACE INTO city (country_id) VALUES (10);
[`sakila`.`city`]
REPLACE INTO city (country_id) SELECT 10 FROM DUAL;
[`sakila`.`city`]
SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM ( SELECT film_id FROM  film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film ) film;
[`sakila`.`film`]
SELECT * FROM film WHERE language_id = (SELECT language_id FROM language LIMIT 1);
[`sakila`.`film` `sakila`.`language`]
SELECT * FROM city i left JOIN country o ON i.city_id=o.country_id union SELECT * FROM city i right JOIN country o ON i.city_id=o.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM (SELECT * FROM actor WHERE last_update='2006-02-15 04:34:33' and last_name='CHASE') t WHERE last_update='2006-02-15 04:34:33' and last_name='CHASE' GROUP BY first_name;
[`sakila`.`actor`]
SELECT * FROM city i left JOIN country o ON i.city_id=o.country_id union SELECT * FROM city i right JOIN country o ON i.city_id=o.country_id;
[`sakila`.`city` `sakila`.`country`]
SELECT * FROM city i left JOIN country o ON i.city_id=o.country_id WHERE o.country_id is null union SELECT * FROM city i right JOIN country o ON i.city_id=o.country_id WHERE i.city_id is null;
[`sakila`.`city` `sakila`.`country`]
SELECT first_name,last_name,email FROM customer STRAIGHT_JOIN address ON customer.address_id=address.address_id;
[`sakila`.`address` `sakila`.`customer`]
SELECT ID,name FROM (SELECT address FROM customer_list WHERE SID=1 order by phone limit 50,10) a JOIN customer_list l ON (a.address=l.address) JOIN city c ON (c.city=l.city) order by phone desc;
[`sakila`.`city` `sakila`.`customer_list`]
SELECT * FROM film WHERE date(last_update)='2006-02-15';
[`sakila`.`film`]
SELECT last_update FROM film GROUP BY date(last_update);
[`sakila`.`film`]
SELECT last_update FROM film order by date(last_update);
[`sakila`.`film`]
SELECT description FROM film WHERE description IN('NEWS','asd') GROUP BY description;
[`sakila`.`film`]
alter table address add index idx_city_id(city_id);
[`sakila`.address`]
alter table inventory add index `idx_store_film` (`store_id`,`film_id`);
[`sakila`.inventory`]
alter table inventory add index `idx_store_film` (`store_id`,`film_id`),add index `idx_store_film` (`store_id`,`film_id`),add index `idx_store_film` (`store_id`,`film_id`);
[`sakila`.inventory`]
SELECT	DATE_FORMAT(t.last_update, '%Y-%m-%d'),	COUNT(DISTINCT (t.city))	FROM city t WHERE t.last_update > '2018-10-22 00:00:00'	AND t.city LIKE '%Chrome%'	AND t.city = 'eip' GROUP BY DATE_FORMAT(t.last_update, '%Y-%m-%d') ORDER BY DATE_FORMAT(t.last_update, '%Y-%m-%d');
[`sakila`.`city`]
create table hello.t (id int unsigned);
[`hello`.`t`]
select * from tb where data >= '';
[`sakila`.`tb`]
alter table tb alter column id drop default;
[`sakila`.tb`]
select maxId, minId from (select max(film_id) maxId, min(film_id) minId from film where last_update > '2016-03-27 02:01:01') as d;
[`sakila`.`film`]
select maxId, minId from (select max(film_id) maxId, min(film_id) minId from film) as d;
[`sakila`.`film`]