MySQL

This snippet of code will import data from a TXT file that you create locally.

LOAD DATA LOCAL INFILE '/mysql/mybooks.txt' INTO TABLE mybooks LINES TERMINATED BY '\r\n';

To delete all records from a table:

delete from mybooks;

To sort the records, use the following code:

SELECT title, year FROM mybooks ORDER BY year;

To search for a substring, use:

select * from mybooks where author like "Andrew%";

To count (cumulatively) related entries in a column, use:

select count(*), category from mybooks group by category;

To delete (drop) a database or table, use:

drop database databasename; or drop table tablename;