SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE person ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) ); CREATE TABLE shirt ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, style ENUM('t-shirt', 'polo', 'dress') NOT NULL, color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL, owner SMALLINT UNSIGNED NOT NULL REFERENCES person(id), PRIMARY KEY (id) ); INSERT INTO person VALUES (NULL, 'Antonio Paz'); INSERT INTO shirt VALUES (NULL, 'polo', 'blue', LAST_INSERT_ID()), (NULL, 'dress', 'white', LAST_INSERT_ID()), (NULL, 't-shirt', 'blue', LAST_INSERT_ID()); INSERT INTO person VALUES (NULL, 'Lilliana Angelovska'); INSERT INTO shirt VALUES (NULL, 'dress', 'orange', LAST_INSERT_ID()), (NULL, 'polo', 'red', LAST_INSERT_ID()), (NULL, 'dress', 'blue', LAST_INSERT_ID()), (NULL, 't-shirt', 'white', LAST_INSERT_ID()); INSERT INTO person VALUES (NULL, 'A Gluschenko'); CREATE INDEX i1 ON person (name(10)); SELECT * FROM person where id>1 or name LIKE 'An%'; CREATE TEMPORARY TABLE tmp SELECT * FROM person WHERE id > '1'; INSERT INTO tmp SELECT * FROM person WHERE name LIKE 'An%'; SELECT * from tmp; DROP TABLE tmp; CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body) ); INSERT INTO articles VALUES (0,'MySQL Tutorial', 'DBMS stands for DataBase ...'), (0,'How To Use MySQL Efficiently', 'After you went through a ...'), (0,'Optimising MySQL','In this tutorial we will show ...'), (0,'1001 MySQL Trick','1. Never run mysqld as root. 2. ...'), (0,'MySQL vs. YourSQL', 'In the following database comparison ...'), (0,'MySQL Security', 'When configured properly, MySQL ...'); SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); SELECT id,MATCH (title,body) AGAINST ('Tutorial') FROM articles; SELECT id, body, MATCH (title,body) AGAINST ('Security implications of running MySQL as root') AS score FROM articles WHERE MATCH (title,body) AGAINST ('Security implications of running MySQL as root'); SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear