>show tables;
>show columns from directory;
>create table directory (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, type INT, last varchar(30));
>select * from directory;
>select * from directory order by id;
>insert into directory values ('www','xxx','yyy','zzz');
>update directory set owner='JVP' where last='Jones';
>delete from directory where type='2';
>alter table directory add other varchar(30);
>alter table directory modify other varchar(50);
>alter table directory drop column id;