Last update: Friday 24th February 2006 15:33 PT, AHD


MySQL hints
-----------

This document is an aide-memoire for the author and is not a tutorial for beginners. 

****************************************

$ mysql -h localhost -u adawson -p adawson

mysql> show tables;

mysql> CREATE TABLE Books (title VARCHAR(20), author VARCHAR(20),subject VARCHAR(20), isbn VARCHAR(15));

mysql> LOAD DATA LOCAL INFILE 'books.data' INTO TABLE Books LINES TERMINATED BY '\r\n';

mysql> select * from Books;
mysql> delete from Books where title = "";
mysql> delete FROM Books WHERE author = '';

To delete the entire table from a database, use:
mysql> drop table tablename;












****************************************