2009年8月26日水曜日

mysql基本コマンドまとめ

mysql> show databases;
mysql> create database karino;
mysql> use karino;
mysql> create table photolist(num int,title varchar(50));
mysql> show fields from photolist;
mysql> alter table photolist add date date;
mysql> insert into photolist values(0,'opencampass','2009-8-24');
mysql> select*from photolist;
mysql> update photolist set title='open' where num=1;
mysql> delete from photolist where num=4;
mysql> select*from photolist order by date;

0 件のコメント:

コメントを投稿